Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: value function in SQL does not work
"Tom Xu" <tom_xu_at_msn.com> wrote in message
news:d938f4e5.0107050833.19fea061_at_posting.google.com...
> Hello All,
> I refer to the Oracle 8.1.7 SQL Reference documentation. There is
> a sample showing how to using SET VALUE in update: ( on page 1106)
>
> update table1 p set value(p) = (select value(q) from table2 q where
> p.id = q.id) where p.id = 10;
>
> I accormendated this syntax to my real table name in sql*plus, but it
> complains that p and q are invalid column name. (in my case, the id is
> the primary key of both table, and table1 and table2 have the same
> structure)
>
> I put the SQL into a stored procedure , but the stored procedure
> compiled with error.
>
> How can I use this sytax? Is there any standard SQL can do the same
> thing?(the difficult part is that I need to update all the columns in
> table1)
>
> thanks for any help!
>
> Tom
This might be a silly question, but your tables are object tables aren't they? VALUE only works against object tables, not against "traditional" ones.
John. Received on Sat Jul 21 2001 - 16:29:05 CDT