(no subject)

i KNOW I know how to do this. what missing comma? where? that sql commans is as right as I can possibly make it, at least as far as i can see. anyone have any suggestions??

(no subject)

Oh, here's what I'm trying to do:

insert into customer values
(12345, Alan Metz, 123 Sesame St Apt 5, Anytown, ST,
00000, 999-457-2362, 999-856-2233, metza@aol.com,
14000, A, 12-Feb-1987, '');


and here's the creation code for the table:

create table customer
(cust# varchar2(5), name varchar2(50), addr varchar2(50),
city varchar2(20), state varchar2(2), zip varchar2(5),
home_phone varchar2(12), work_phone varchar2(12), email varchar2(25),
credit_lim number, status varchar2(1), open date, close date);

(no subject)

after several tries with both beanalby and dymaxion helping me, we figured out that this is what Oracle wants me to do:

insert into customer (cust#, name, addr, city, state, zip, home_phone,
work_phone, email, credit_lim, status, open) values
('12345', 'Alan Metz', '123 Sesame St Apt 5', 'Anytown', 'ST',
'00000', '999-457-2362', '999-856-2233', 'metza@aol.com',
'14000', 'A', '12-Feb-1987');

gah!

Thank you dym, bean, and curgoth, and mercury_chan for your help :)

(no subject)

DUDE! I have an icon now! YAY!!! Thanks neeuqdrazil!!!!!