| This article must adhere to the biographies of living persons (BLP) policy, even if it is not a biography, because it contains material about living persons. Contentious material about living persons that is unsourced or poorly sourced must be removed immediately from the article and its talk page, especially if potentially libellous. If such material is repeatedly inserted, or if you have other concerns, please report the issue to this noticeboard.If you are a subject of this article, or acting on behalf of one, and you need help, please see this help page. |
 | This article is rated Start-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects: | |||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||
Untitled
editcreate sequence sq_380311 start with 1 increment by 1 cache 4
create table Customer( Customer_ID number(5) primary key, Customer_Name varchar2(25) not null, Custoner_Address varchar2(25) not null, Customer_City varchar2(20), Zip varchar2(9) )
create table Order1(
Order_ID number(3) primary key,
Order_Date date not null,
Customer_ID number(5) not null,
constraint cust_id_fk foreign key(Customer_ID) references Customer(Customer_ID)
)
insert into customer values(sq_380311.nextval,'John Doe','392 Sunset Blvd.','New York','10059'); insert into customer values(sq_380311.nextval,'Mary Smith','6900 Main St.','San Francisco','94032'); insert into customer values(sq_380311.nextval,'Richard Newman','2040 Riverside Rd.','San Diego','92010'); insert into customer values(sq_380311.nextval,'Cathy Cook','4010 Speedway','New York','10059');
insert into order1 values(103,'03-OCT-09',2); insert into order1 values(104,'10-OCT-09',1); insert into order1 values(105,'10-OCT-09',4); insert into order1 values(106,'10-OCT-09',2); insert into order1 values(107,'10-OCT-09',1); —Preceding unsigned comment added by 111.93.37.34 (talk) 11:05, 7 December 2010 (UTC)