Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TABLE CREATION

Create table as per below data & briefly discuss the why you use these the script for creating of table . only one attribute will be primary key.
The other two attributes will Restrict the duplication and must store data values.

Table name: DEPARTMENT
DPT_CODE DPT_NAME DPT_ALLOTMENT
-------- --------------- -------------
57 IT 65000
63 Finance 15000
47 HR 240000
27 RD 55000
89 QC 75000

Comments

Post Details

Added on Aug 3 2022
#database, #sql, #sql-developer, #table
1 comment
89 views