Wednesday, April 24, 2013

Create table with Column level constraint for Dept table.


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