Bind Variable as Column name...

Hi!

I have been trying to do the following but I don't think you can do it...

Make the column name a bind variable.

I.e.
update table test set :COLUMN_NAME=:COLUMN_VALUE;

is this not possible????

The reason is I want all my SQL Statements to be identical so they will be found in the shared pool....

Thanks!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 02 1999 - 03:49:29 CDT