Thread: Oracle 10g
View Single Post
Old Apr 1st, 2008, 4:35 AM   #1
A.K.Al Shamsi
Programmer
 
A.K.Al Shamsi's Avatar
 
Join Date: Mar 2008
Posts: 35
Rep Power: 0 A.K.Al Shamsi is on a distinguished road
Oracle 10g

hi....
could anybody help me???

oracle is driving me to maddness ...

for project i have to create tables and indetify their primary keys and foreign keys so i entered values for primary keys in this part everything went good...

but for other fields, i couldn't if i typed this code
 
INSERT INTO tbl_lease (lease_name, rental_amount, lease_signdate, begin_date, end_date)
VALUES ('Gardern1', '120 000', '1-Jan-2008', '10-Jan-2008', '10-Jan-2009');
it gave my error for missing comma


and for this code it gave me not enough values
 
INSERT INTO tbl_lease VALUES ('Gardern1', '120 000', '1-Jan-2008', '10-Jan-2008', '10-Jan-2009');


i am lost i have to finish this database soon
A.K.Al Shamsi is offline   Reply With Quote