CodeListing 1: Creating the example tables and data

create table CUSTOMERS
(
   CUST_ID    NUMBER       NOT NULL,
   CUST_NAME  VARCHAR2(20) NOT NULL
);
create table ACCOUNTS
(
   ACCT_ID    NUMBER       NOT NULL,
   CUST_ID    NUMBER       NOT NULL,
   BALANCE    NUMBER(15,2)
);
insert into CUSTOMERS values (123,'Jay Kulkarni');
insert into CUSTOMERS values (456,'Wim Patel');
insert into ACCOUNTS values (101,123,10000000);
insert into ACCOUNTS values (102,123,15000000);
insert into ACCOUNTS values (201,456,10000000);
insert into ACCOUNTS values (202,456,20000000);
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy