Programming Forums > Application Development > Other Programming Languages

A.K.Al Shamsi · Apr 1st, 2008, 4:35 AM

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

(Toggle Plain Text)

 
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

(Toggle Plain Text)

 
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

Apr 1st, 2008, 4:35 AM	#1
A.K.Al Shamsi Programmer Join Date: Mar 2008 Posts: 35 Rep Power: 0	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 (Toggle Plain Text) 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'); 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 (Toggle Plain Text) INSERT INTO tbl_lease VALUES ('Gardern1', '120 000', '1-Jan-2008', '10-Jan-2008', '10-Jan-2009'); 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Other Programming Languages

Oracle 10g