© Ben Brumm 2019
Ben BrummBeginning Oracle SQL for Oracle Database 18chttps://doi.org/10.1007/978-1-4842-4430-2_14

14. Creating a Table

Ben Brumm1 
(1)
Melbourne, VIC, Australia
 

Earlier in this book, you created a new table called employee and added data to it. You did this using the menu options within SQL Developer. There is another way to create tables, which we will learn about in this chapter.

Creating Tables Using SQL Code

An alternative to creating tables using the menu options is to use SQL code. The SQL code you’ve learned so far allows you to read data from an existing table using the SELECT statement. There is a range of different SQL statements that can be used, and one of them is for creating a table.

Why would you create a table using SQL ...

Get Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.