Notes

--@E:SA18408447week3varray.txt
/*
Name=Shahas Dhungana
UN ID=18408447
Week=3
Activity=3
*/
--CREATING A OBJECT_TYPE
CREATE OR REPLACE TYPE social_media_type AS OBJECT(
media_name VARCHAR2(25),
contact VARCHAR2(50));
/
show error;

/*CREATING VRRAY TYPE OF name social_media_vrray_type*/

CREATE OR REPLACE TYPE social_media_varray_type AS VARRAY(50) OF social_media_type;
/
--Using vrray in relational tables
CREATE TABLE prospective_customers (
prospective_customer_id NUMBER(6),
company_name VARCHAR2(50),
contact_name VARCHAR2(25),
social_media_avaliable social_media_varray_type);

--creating a nested table type based on the social_media_type
CREATE OR REPLACE TYPE social_media_table_type AS TABLE OF social_media_type;
/

--creating table adverts
CREATE TABLE adverts (
advert_id NUMBER(6),
advert_title VARCHAR2(50),
description VARCHAR2(25),
social_media_used social_media_table_type)
NESTED TABLE social_media_used STORE AS social_media_table;

--Droping sequence
/*

DROP TABLE prospective_customers;
DROP TABLE adverts;
DROP TYPE social_media_table_type;
DROP TYPE social_media_varray_type;
DROP TYPE social_media_type;
*/