Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> indirect SQL execution - kind of 'backquoting'
I must admit, I'm not very familar with SQL. I was trying to empty
a database instance from all tables that were created by a
specific creator using
select ' drop table' || name || ';' from sys.systables where creator='SOMEONE' ;
The output of that command, when executed, produces the desired result.
Is there a way to "backquote" this commans, i.e. like in a Unix shell, as you are doing something like rm `cat file` and file contains a list of files.
By now I'm redirecting this to another file and grep through it to fish out the drop commands.
I'm sure there are more elegant methods.
-- Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.deReceived on Thu Jul 22 2004 - 03:52:11 CDT