exp2 - Sheet1 Page 1 SQL> CLIENT NAME ADDRESS1------...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sheet1 Page 1 SQL> CLIENT NAME ADDRESS1------ -------------------- ------------------------------ ADDRESS2 CITY PINCODE STATE------------------------------ --------------- ---------- --------------- BAL_DUE---------- C00005 Ravi Sreedharan Concord Thakur Village Delhi 100001 Delhi 2000 C00006 Kukmini Oberoi Towers CLIENT NAME ADDRESS1------ -------------------- ------------------------------ ADDRESS2 CITY PINCODE STATE------------------------------ --------------- ---------- --------------- BAL_DUE---------- Walkeshwar Bombay 400050 Maharastra 6 rows selected. SQL> create table productMaster create table productMaster * ERROR at line 1: ORA-00906: missing left parenthesis SQL> create table productMaster(product_no varchar2(6),description varchar2(15),profit_percent varc har2(4,2),Unit_measure varchar2(10),Qty_on_hand number(8),Reorder number(8),Sell_price number(8,2) create table productMaster(product_no varchar2(6),description varchar2(15),profit_percent varchar2( ERROR at line 1: ORA-00905: missing keyword SQL> create table productMaster(product_no varchar2(6),description varchar2(15),profit_percent varch ar2(4,2),Unit_measure varchar2(10),Qty_on_hand number(8),Reorder number(8),Sell_price number(8,2), SQL> create table productMaster(product_no varchar2(6),description varchar2(15),profit_percent varch ar2(4,2),Unit_measure varchar2(10),Qty_on_hand number(8),Reorder number(8),Sell_price number(8,2),Co st_price number(8,2)) create table productMaster(product_no varchar2(6),description varchar2(15),profit_percent varchar2(4 ERROR at line 1: ORA-00905: missing keyword Sheet1 Page 2 SQL> create table productMaster(product_no varchar2(6),description varchar2(15),profit_percent numbe r(4,2),Unit_measure varchar2(10),Qty_on_hand number(8),Reorder number(8),Sell_price number(8,2),Cost _price number(8,2)) Table created. SQL> insert into productMaster values('S00001','Manager',1200,'Liter',1500,39,48,41) insert into productMaster values('S00001','Manager',1200,'Liter',1500,39,48,41) * ERROR at line 1: ORA-01438: value larger than specified precision allows for this column SQL> insert into productMaster values('S00001','Manager',120,'Liter',1500,39,48,41) insert into productMaster values('S00001','Manager',120,'Liter',1500,39,48,41) * ERROR at line 1: ORA-01438: value larger than specified precision allows for this column SQL> insert into productMaster values('S00001','Manager',12,'Liter',1500,39,48,41) 1 row created. SQL> insert into productMaster values('S00002','Manager',15,'Liter',1100,49,38,21) 1 row created. SQL> insert into productMaster values('S00003','Clerk',14,'Milliters',1700,79,48,41) 1 row created. SQL> insert into productMaster values('S00003','HeadofDept',14,'Milliters',170,69,38,32) 1 row created....
View Full Document

This note was uploaded on 10/25/2010 for the course CMPN SEM4 taught by Professor Thakur during the Spring '07 term at University of Mumbai.

Page1 / 17

exp2 - Sheet1 Page 1 SQL> CLIENT NAME ADDRESS1------...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online