OraFAQ Forum: Server Administration

Fri, 16 February 2001 09:13

alles
Messages: 2
Registered: February 2001

Junior Member

Can I use the next SQL?

insert into table1 (q, w, e) values
(:1,
:2,
select id from table2 where s like :s_name)

Fri, 16 February 2001 12:21

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

Have you tried
insert into table1 (q, w, e) values
( select :1,:2, id from table2 where s like :s_name)

Previous Topic:	help required in optimizing a query
Next Topic:	Query regarding ORDER BY clause

Goto Forum:

]

Current Time: Sat May 18 04:26:45 CDT 2024