CREATE TABLE PERSONS USING PRIMARY KEY AND NOT NULL CONSTRAINTS IN SQL

SQL> CREATE TABLE PERSONS(PID INT PRIMARY KEY,NAME CHAR(30)NOT NULL,ADDRESS CHAR(90),CONTACT NUMB

10)NOT NULL);

Table created.

SQL> DESC PERSONS;

 Name                                      Null?         Type

 ---------------------------------- --------          ----------------------------

 PID                                         NOT NULL  NUMBER(38)

 NAME                                    NOT NULL  CHAR(30)

 ADDRESS                                                   CHAR(90)

 CONTACT                              NOT NULL  NUMBER(10)

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM PERSONS;

no rows selected

SQL> INSERT INTO PERSONS VALUES(101,'SANKET','VASHI',8547125470);

1 row created.

SQL> INSERT INTO PERSONS VALUES(&PID,'&NAME','&ADDRESS',&CONTACT);

Enter value for pid: 102

Enter value for name: SANKET2

Enter value for address: JUINAGAR

Enter value for contact: 8569745148

old   1: INSERT INTO PERSONS VALUES(&PID,'&NAME','&ADDRESS',&CONTACT)

new   1: INSERT INTO PERSONS VALUES(102,'SANKET2','JUINAGAR',8569745148)

1 row created.

SQL> /

Enter value for pid: 103

Enter value for name: SANKET3

Enter value for address: NERUL

Enter value for contact: 7458965547

old   1: INSERT INTO PERSONS VALUES(&PID,'&NAME','&ADDRESS',&CONTACT)

new   1: INSERT INTO PERSONS VALUES(103,'SANKET3','NERUL',7458965547)

1 row created.

SQL> /

Enter value for pid: 104

Enter value for name: SANKET4

Enter value for address: SANPADA

Enter value for contact: 3256478945

old   1: INSERT INTO PERSONS VALUES(&PID,'&NAME','&ADDRESS',&CONTACT)

new   1: INSERT INTO PERSONS VALUES(104,'SANKET4','SANPADA',3256478945)

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM PERSONS;

       PID NAME

---------- ------------------------------

ADDRESS

--------------------------------------------------------------------------------

   CONTACT

----------

       101 SANKET

VASHI

8547125470

       102 SANKET2

JUINAGAR

       PID NAME

---------- ------------------------------

ADDRESS

--------------------------------------------------------------------------------

   CONTACT

----------

8569745148

       103 SANKET3

NERUL

7458965547

       PID NAME

---------- ------------------------------

ADDRESS

--------------------------------------------------------------------------------

   CONTACT

----------

       104 SANKET4

SANPADA

3256478945