Creating Objects in ORACLE

				
--**************************************
-- Name: Creating Objects in ORACLE
-- Description:This code will teach you how you can create and use objects in ORACLE. First you have to create an object. After creating object put it into a table to use it. Then insert some data and query by the SELECT statement. See code for 100% clarification.
-- By: Md. Tanzim Saqib
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=981&lngWId=5--for details.--**************************************

drop type person_03_03666_1;
drop table stud_03_03666_1;
CREATE TYPE person_03_03666_1 AS OBJECT
	(
		first_name VARCHAR2(10),
		last_name VARCHAR2(10),
		age NUMBER(2),
		sex VARCHAR2(1),
		loc VARCHAR2(20)
	);
CREATE TABLE stud_03_03666_1
	(
		id VARCHAR2(10) PRIMARY KEY,
		stud person_03_03666_1,
		cgpa NUMBER(3,2)
	);
INSERT INTO stud_03_03666_1 (id, stud, cgpa)
VALUES ('03-03666-1', person_03_03666_1('Tanzim', 'Saqib', 20, 'M', 'Dhaka'), 3.90);
SELECT s.stud.cgpa FROM stud_03_03666_1 s WHERE s.id='03-03666-1';