Use dynamic SQL, it is so simple now that there is
execute immediate instead of prepare, execute,
bind,...
--- Vikas Kawatra [EMAIL PROTECTED] a écrit :
can someone tell me a way to select all tables from
multiple schemas -
and then update records in each of these tables
based on a certain
can someone tell me a way to select all tables from multiple schemas -
and then update records in each of these tables based on a certain criterea.
I wrote a script below - which explains logically what I need to do - but I
don't think I can use a cursor output in the UPDATE as I have below.