![]() ![]() On top of this, the owner of the new table must have the quota for the tablespace that contains the new table or UNLIMITED TABLESPACE system privilege. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |