Oracle CREATE TABLEIn Oracle, CREATE TABLE statement is used to create a new table in the database. To create a table, you have to name that table and define its columns and datatype for each column. Syntax: Parameters used in syntax
Oracle CREATE TABLE ExampleHere we are creating a table named customers. This table doesn't have any primary key. This table contains three columns
Oracle CREATE TABLE Example with primary keyWhat is Primary keyA primary key is a single field or combination of fields that contains a unique record. It must be filled. None of the field of primary key can contain a null value. A table can have only one primary key. In Oracle, total number of columns cannot be more than 32.Next TopicOracle CREATE TABLE AS |