Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> sql database problem
can anybody help with this problem
using a single insert into .... Select....command, create a hiring transaction for Mr f Curlew for the XJ6 4000 for October 10th 1997 at 10:00. do this without visually inspecting the tables to find out the relevant registration number and account number - get sql itself to look up the tables.
why does the below not work?
insert into hiring (regno, time_out,cust_acc)
values ((select regno from car where model = 'XJ6' and esize = 4000),
to_date ('10-OCT-97' 10:00:00,
'DD-MM-YY' H24:MI:SS'),
(select acc_no from customer where name = 'Mr F Curlew');
error message reads : missing expression @ values ((select
thanx in advance
mark Received on Sun Mar 19 2000 - 15:40:09 CST
![]() |
![]() |