Skip to Main Content
Oracle PL/SQL Programming: A Developer's Workbook
book

Oracle PL/SQL Programming: A Developer's Workbook

by Steven Feuerstein, Andrew Odewahn
May 2000
Intermediate to advanced content levelIntermediate to advanced
594 pages
11h 32m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL Programming: A Developer's Workbook

Expert

Q:

7-33.

Here is the script to create the necessary objects:


/* Filename on web page: manage_orders.sql */
/*
   Drop existing objects
*/
DROP TABLE orders;
DROP TYPE order_detail_t;
DROP TYPE detail_t;
DROP TYPE tax_code_t;
DROP TYPE tax_code_detail_t;

/*
   Create a tax code object and table
*/
CREATE TYPE tax_code_detail_t AS OBJECT(
   tax_code VARCHAR2 (10)
);
/

CREATE TYPE tax_code_t AS TABLE OF tax_code_detail_t;
/

/*
   Create a detail type and table
*/
CREATE TYPE detail_t AS OBJECT(
   detail_no NUMBER,
   detail_desc VARCHAR2 (30),
   detail_price NUMBER
);
/

CREATE TYPE order_detail_t AS TABLE OF detail_t;
/
/*
   Create an orders table with a nested table of details
   and tax codes
*/
CREATE TABLE orders
   (order_no   NUMBER NOT NULL PRIMARY KEY USING INDEX,
    order_desc VARCHAR2(30),
    order_detail   order_detail_t,
    tax_codes   tax_code_t)
  NESTED TABLE order_detail STORE AS order_detail,
  NESTED TABLE tax_codes STORE AS order_tax_codes
/

Q:

7-34.

The code for the create_order function is in the manage_orders.sql file on the book’s web page.

Q:

7-35.

The code for the update_order procedure is in the manage_orders.sql file on the book’s web page.

Q:

7-36.

The code for the add_details procedure is in the manage_orders.sql ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 9781449324070Supplemental ContentErrata Page