1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Nested table example in Oracle

CREATE TYPE item_type AS OBJECT (
prodid NUMBER (5),
price NUMBER (7, 2)
);

CREATE TYPE item_nst_type AS TABLE OF item_type;

CREATE TABLE porder1
(ordid NUMBER(5),
supplier NUMBER(5),
requester NUMBER(4),
ordered DATE,
items item_nst_type )
NESTED TABLE items STORE AS item_stor_tab1;


--Dictionary table USER_COLL_TYPES

--UNIQUE system generated NESTED TABLE IDENTIFIER for each outer row generated

--Operations on nested table performed IMPLICITLY by the system

CREATE TYPE project AS OBJECT (
proj_no NUMBER (2),
title VARCHAR2 (35),
COST NUMBER (7, 2)
);

CREATE TYPE projectlist AS VARRAY (50) OF project;

CREATE TABLE deptt
(dept_id NUMBER(2),
NAME VARCHAR2(15),
budget NUMBER (11,2),
projects projectlist);

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy