Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sql database problem

sql database problem

From: Mark Thomas <mark.thomas5_at_dtn.ntl>
Date: Sun, 19 Mar 2000 21:40:09 -0000
Message-ID: <6PbB4.2398$5b5.85410@news2-win.server.ntlworld.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US