Note that you must have the CREATE TABLE system privilege to create a new table in your schema and CREATE ANY TABLE system privilege to create a new table in another user’s schema. Third, add table constraints if applicable e.g., primary key, foreign key, check.A column definition includes the column name followed by its data type e.g., NUMBER, VARCHAR2, and a column constraint such as NOT NULL, primary key, check. In case a table has multiple columns, you need to separate them by commas (,). Second, list all columns of the table within the parentheses.First, specify the table name and schema name to which the new table belongs on the CREATE TABLE clause.
) Code language: SQL (Structured Query Language) ( sql )
0 kommentar(er)
