INSERT with Sub-Query question! HELP, PLEASE!

From: Kian Lee <ooiklnews_at_yahoo.com>
Date: Thu, 21 Dec 2000 03:42:36 GMT
Message-ID: <91ru7b$9j1$1@nnrp1.deja.com>

Hi all,

I am new to Oracle SQL I have run a SQL below and get the result like below.

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

The "expense_code" and "value" datatypes are same, NUMBER. I could't get help from the documentation.

Please help.

Thanks.

Regards,
Kian Lee

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 21:42:36 CST