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

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.
Your correct statement should be:

insert into ter_expense_type (expense_code, created_by) select (value, 'user_name' from parameter where item='EXPENSE_CODE');

hth,
peter Received on Thu Dec 21 2000 - 01:32:03 CST