Notes

INSERT INTO addresses(street,city,country)
VALUES('121STATE ROAD','london','UK');

INSERT INTO addresses(street,city,country)
VALUES('VALLEY WAY','KATHMANDU','NEPAL');

INSERT INTO addresses(street,city,country)
VALUES('KING STREET','TEXAS','USA');

INSERT INTO addresses(street,city,country)
VALUES('BIG STREET','DHAKA','DHAKA');

INSERT INTO addresses(street,city,country)
VALUES('PARIS','DELHI','INDIA');


INSERT INTO locations (location_id,location_name, location_country, location_longitude,location_latitude,locations)
VALUES (
seq_locations.NEXTVAL, 'EUROPE WEST','UK','120F','90E', location_type('IMPERIAL BLVD', 'LOS ANGELES', 'NA'));

INSERT INTO locations (location_id,location_name, location_country, location_longitude,location_latitude,locations)
VALUES (
seq_locations.NEXTVAL, 'EUROPE WEST','UK','120F','100E', location_type('ORACLE DRIVE', 'SAN FRANCISCO', 'UG'));

INSERT INTO locations (location_id,location_name, location_country, location_longitude,location_latitude,locations)
VALUES (
seq_locations.NEXTVAL, 'ASIA SOUTH','NEPAL','120F','20E', location_type('3', 'KATHMANDU', 'JORPATI'));

INSERT INTO locations
VALUES (
seq_locations.NEXTVAL, 'ASIA SOUTH','NEPAL','10F','80E', location_type('3', 'LALITPUR', 'EKANTAKUNA'));

INSERT INTO locations
VALUES (
seq_locations.NEXTVAL, 'ASIA SOUTH','NEPAL','20F','90E', location_type('5 FWDR', 'KANCHANPUR', 'MAHENDRANAGAR'));

INSERT INTO locations
VALUES (
seq_locations.NEXTVAL, 'ASIA SOUTH','NEPAL','50F','100E', location_type('5 FWDR', 'BAJURA', 'MARTADI'));

/*inserting in festival nature table*/
INSERT INTO festival_natures(festival_nature_id,festival_nature_name,festival_program_type,festival_date)
VALUES(seq_festival_natures.NEXTVAL,'CHILD','AWARNESS','05-JUN-02');

INSERT INTO festival_natures(festival_nature_id,festival_nature_name,festival_program_type,festival_date)
VALUES(seq_festival_natures.NEXTVAL,'FITNESS','AESTHETIC','05-JUN-02');

INSERT INTO festival_natures(festival_nature_id,festival_nature_name,festival_program_type,festival_date)
VALUES(seq_festival_natures.NEXTVAL,'ZUMBA','AWARNESS','05-JUN-02');

INSERT INTO festival_natures(festival_nature_id,festival_nature_name,festival_program_type,festival_date)
VALUES(seq_festival_natures.NEXTVAL,'DASHAIN','CULTURER','05-JUN-02');

INSERT INTO festival_natures(festival_nature_id,festival_nature_name,festival_program_type,festival_date)
VALUES(seq_festival_natures.NEXTVAL,'TIHAR','CULTURER','05-JUN-02');

INSERT INTO festival_natures(festival_nature_id,festival_nature_name,festival_program_type,festival_date)
VALUES(seq_festival_natures.NEXTVAL,'CHIRSTMAS','AWARNESS','05-JUN-02');



--inserting into table staff.
INSERT INTO staffs(staff_id,staff_fname,staff_lname,staff_fullname,staff_salary,date_of_birth,gender,email,Contacts,address)
SELECT seq_staffs.NEXTVAL,'JOHN','THAPA',NULL,120000,'05-JUN-1999','M','[email protected]',
contact_varray_type(
contact_type('BANESHWOR','101','+012345678','MAHADEV','+099120')),
REF(a) FROM addresses a WHERE a.street='121STATE ROAD';

INSERT INTO staffs(staff_id,staff_fname,staff_lname,staff_fullname,staff_salary,date_of_birth,gender,email,address,Contacts)
SELECT seq_staffs.NEXTVAL,'SUBESH','SHRESTHA',NULL,20000,'15-JUN-006','M','[email protected]',
contact_varray_type(
contact_type('BANESHWOR','201','+0123456798','LUBU','+099120')),
REF(a) FROM addresses a WHERE a.street='VALLEY WAY';

INSERT INTO staffs(staff_id,staff_fname,staff_lname,staff_fullname,staff_salary,date_of_birth,gender,email,address,Contacts)
SELECT seq_staffs.NEXTVAL,'SWOSTIKA','TAMANG',NULL,100000,'05-JAN-008','F','[email protected]',
contact_varray_type(
contact_type('JORPATI','301','+01234456798','SHIVACHOWK','+09920')),
REF(a) FROM addresses a WHERE a.street='KING STREET';

INSERT INTO staffs(staff_id,staff_fname,staff_lname,staff_fullname,staff_salary,date_of_birth,gender,email,address,Contacts)
SELECT seq_staffs.NEXTVAL,'SINA','KHADKA',NULL,150000,'15-JAN-009','F','[email protected]',
contact_varray_type(
contact_type('JORPATI','401','+0123456798','SHIVARATNA','+099205')),
REF(a) FROM addresses a WHERE a.street='BIG STREET';

INSERT INTO staffs(staff_id,staff_fname,staff_lname,staff_fullname,staff_salary,date_of_birth,gender,email,address,Contacts)
SELECT seq_staffs.NEXTVAL,'DAWA','SHERPA',NULL,190000,'25-JAN-009','M','[email protected]',
contact_varray_type(
contact_type('FRANCE','501','+0123456798','NARAYANTAR','+099205')),
REF(a) FROM addresses a WHERE a.street='PARIS';

/*
INSERT INTO staffs--(staff_id,staff_fname,staff_lname,staff_fullname,staff_salary,date_of_birth,gender,email,address,Contacts)
VALUES(seq_staffs.NEXTVAL,'SUBESH','SHRESTHA',NULL,20000,'15-JUN-006','M','[email protected]',
(SELECT REF(a)
FROM addresses a
WHERE a.street='VALLEY WAY'),
contact_varray_type(
contact_type('BANESHWOR','201','+0123456798','LUBU','+099120')));


INSERT INTO staffs--(staff_id,staff_fname,staff_lname,staff_fullname,staff_salary,date_of_birth,gender,email,address,Contacts)
VALUES(seq_staffs.NEXTVAL,'SWOSTIKA','TAMANG',NULL,100000,'05-JAN-008','F','[email protected]',
(SELECT REF(a)
FROM addresses a
WHERE a.street='KING STREET'),
contact_varray_type(
contact_type('JORPATI','301','+01234456798','SHIVACHOWK','+09920')));



INSERT INTO staffs--(staff_id,staff_fname,staff_lname,staff_fullname,staff_salary,date_of_birth,gender,email,address,Contacts)
VALUES(seq_staffs.NEXTVAL,'SINA','KHADKA',NULL,150000,'15-JAN-009','F','[email protected]',
(SELECT REF(a)
FROM addresses a
WHERE a.street='BIG STREET'),
contact_varray_type(
contact_type('JORPATI','401','+0123456798','SHIVARATNA','+099205')));


INSERT INTO staffs--(staff_id,staff_fname,staff_lname,staff_fullname,staff_salary,date_of_birth,gender,email,address,Contacts)
VALUES(seq_staffs.NEXTVAL,'DAWA','SHERPA',NULL,190000,'25-JAN-009','M','[email protected]',
(SELECT REF(a)
FROM addresses a
WHERE a.street='PARIS'),
contact_varray_type(
contact_type('FRANCE','501','+0123456798','NARAYANTAR','+099205')));

--COMMIT;





















/*festival table inserted using nested table*/
INSERT INTO Festivals(festival_id,location_id,festival_nature_id,festival_name,festival_item)
VALUES(seq_festivals.NEXTVAL,302,502,'TIHAR',festival_item_table_type(festival_item_type('15-MAY-02','15-JUNE-02','CULTRAL')));

INSERT INTO Festivals(festival_id,location_id,festival_nature_id,festival_name,festival_item)
VALUES(seq_festivals.NEXTVAL,303,503,'CHATT',festival_item_table_type(festival_item_type('30-JAN-02','10-FEB-02','CULTURE')));

INSERT INTO Festivals(festival_id,location_id,festival_nature_id,festival_name,festival_item)
VALUES(seq_festivals.NEXTVAL,304,504,'KRISHNA JANMAST',festival_item_table_type(festival_item_type('30-JAN-02','10-FEB-02','CULTURE')));

INSERT INTO Festivals(festival_id,location_id,festival_nature_id,festival_name,festival_item)
VALUES(seq_festivals.NEXTVAL,305,505,'HOLI',festival_item_table_type(festival_item_type('30-AUG-02','10-SEP-02','CULTURE')));

INSERT INTO Festivals(festival_id,location_id,festival_nature_id,festival_name,festival_item)
VALUES(seq_festivals.NEXTVAL,305,505,'HOLI',festival_item_table_type(festival_item_type('30-AUG-02','10-SEP-02','CULTURE')));


/*inserting in festival table*/
INSERT INTO festival_staffs(festival_staff_id,festival_staff_name,festival_staff_salary,festival_id,staff_id)
VALUES(seq_festival_staffs.NEXTVAL,'CHARLIE',10000,402,102);

INSERT INTO festival_staffs(festival_staff_id,festival_staff_name,festival_staff_salary,festival_id,staff_id)
VALUES(seq_festival_staffs.NEXTVAL,'CHERRY',40000,403,103);

INSERT INTO festival_staffs(festival_staff_id,festival_staff_name,festival_staff_salary,festival_id,staff_id)
VALUES(seq_festival_staffs.NEXTVAL,'DAWA',60000,404,104);

INSERT INTO festival_staffs
VALUES(seq_festival_staffs.NEXTVAL,'YOGI',300000,405,105);

INSERT INTO festival_staffs
VALUES(seq_festival_staffs.NEXTVAL,'HARI',20000,406,106);