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.