FOR FREE CONTENT

CREATE TABLES AND INSERT VALUES

CREATE TABLE SAILORS:

CREATE TABLE sailors(

sid NUMBER(5) PRIMARY KEY, 

sname VARCHAR(50),

rating NUMBER(5),

age NUMBER(3));

Table Sailors is created.

Insert the values in the table "SAILORS":

INSERT INTO sailors VALUES(1, 'Anirban Das', 10, 20);

INSERT INTO sailors VALUES(2, 'Jufishan Boksha', 7, 21);

INSERT INTO sailors VALUES(3, 'Ramesh', 5, 25);

INSERT INTO sailors VALUES(4, 'Sumana Das', 8, 23);

INSERT INTO sailors VALUES(5, 'Shiladitya', 6, 21)

INSERT INTO sailors VALUES(6, 'Rahul', 8, 23)

INSERT INTO sailors VALUES(7, 'Rajib', 4, 27);

Output:

7 rows created

CREATE TABLE "BOATS":

CREATE TABLE boats(

bid NUMBER(5) PRIMARY KEY,

bname VARCHAR2(50),

color VARCHAR2(20));

Output:

Table Boats is created.

Insert the values in the table "BOATS":

INSERT INTO boats VALUES(1, 'Interlake', 'Red');

INSERT INTO boats VALUES(2, 'Jhil', 'Green');

INSERT INTO boats VALUES(3, 'Blacker', 'Yellow');

INESRT INTO boats VALUES(4, 'Sea King', 'Red');

INESRT INTO boats VALUES(5, 'Time', 'Red');

Output:

5 rows created.

CREATE TABLE RESERVES

CREATE TABLE reserves(

sid NUMBER(5) REFERENCES sailors(sid),

bid NUMBER(5) REFERENCES boats(bid),

day NUMBER(5));

Output:

Table Reserves is created.

Insert the values in the table "RESERVES":

INSERT ALL INTO reserves VALUES(1, 1, 10);

INSERT INTO reserves VALUES(2, 2, 3);

INSERT INTO reserves VALUES(3, 5, 4);

INSERT INTO reserves VALUES(4, 3, 3);

INSERT INTO reserves VALUES(5, 1, 1);

Output:

5 rows created.