table name :: DEPT
--------------------------------------------
Create table Command for DEPT table
create table dept
(deptno number(3,0) primary key,
dname varchar2(15) not null,
location varchar2(15)
)
table description after above Command is as under.
Here we Give column level Constraint for DEPTNO.
Here DEPT NO is Primary key for Dept table.
No comments:
Post a Comment