Re: INSERT with Sub-Query question! HELP, PLEASE!

Version 8.1 allows queries to be used as expressions:

create table xxx (v1 varchar2(20), v2 varchar2(20)); table created

insert into xxx values ('xxx',(select user from dual)); 1 row created

select * from xxxx;

    'xxx,'JPL'

Perhaps this original poster is using an older version which does not support this mechanism.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Peter Kallweit wrote in message <3A41B1F3.8C4EDF1A_at_iief.de>...


>Hallo Kian,

>

>Kian Lee wrote:

>>

>>

>> SQLWKS> insert into ter_expense_type

>>      2> (expense_code, created_by)

>>      3> values

>>      4> ( (select value from parameter where item

>> = 'EXPENSE_CODE'), 'user_name' );

>>

>> ( (select value from parameter where item

>> = 'EXPENSE_CODE'), 'user_name' )

>>    *

>> ORA-00936: missing expression

>>

>

>For a insert you must decide to use values or subquery.

>You tried to use a combination.