New data types
Q) You are going to create new table to be housed in the USERS01 tablespace.
The table name will be METALS and will be used to store a description of various metals. The following offers some additional direction on how the table should be created.
* The table shall have a primary key called METALS_ID.
* An inline primary key constraint shall be defined. The constraint name shall be METALS_ID_PK shall be used.
* An addition column of METAL_DESCRIPTION shall be added to the table definition.
* A unique constraint on METAL_DESCRIPTION shall be added to the table definition. The constraint name shall be METAL_DESC_UK shall be used.
Can you write and execute the SQL commands.
Q) You are going to create new table to be housed in the USERS01 tablespace.
The table name will be METALS and will be used to store a description of various metals. The following offers some additional direction on how the table should be created.
* The table shall have a primary key called METALS_ID.
* An inline primary key constraint shall be defined. The constraint name shall be METALS_ID_PK shall be used.
* An addition column of METAL_DESCRIPTION shall be added to the table definition.
* A unique constraint on METAL_DESCRIPTION shall be added to the table definition. The constraint name shall be METAL_DESC_UK shall be used.
Can you write and execute the SQL commands.
Need a quick solution to this question? Comment on this post!!!
No comments:
Post a Comment