DDL COMMANDS- ENFORCING INTEGRITY CONSTRAINTS
1. Creation of accounts table:
SQL> create table accounts (acno number(5) primary key, name
varchar2(50), address varchar2(50) not null, city varchar2(50)
check(city in('hyd','chennai','bangalore')), pincode number(6) default
000000, state varchar2(50), dob date, doj date default sysdate, phone
number(10) unique, balance number(10) check(balance>500));
Table created.
Insertion of values into table:
•SQL> insert into accounts
values(10001,'susmit','sangareddy','hyd',502313,'telangana','11-aug-
2005','21-mar-2025',7416796685,50000);
1 row created.
•SQL> insert into accounts
values(10002,'aryan','bowenpally','hyd',503515,'telangana','28-sep-
2005','21-mar-2025',8247586600,50000);
1 row created.
Check constraint violation:
•SQL> insert into accounts
values(10001,'susmit','sangareddy','vizag',502313,'telangana','11-aug-
2005','21-mar-2025',7416796685,50000);
insert into accounts
values(10001,'susmit','sangareddy','vizag',502313,'telangana','11-aug-2005','21-
mar-2025',7416796685,50000)
*
ERROR at line 1:
