best way to "parameterize" a tablename?
Date: Thu, 21 Aug 2008 21:58:03 GMT
I have need to do something like this:
if tablename = 'FOO'
insert into foo ...
else if tablename = 'BAR'
insert into bar ... (exact same stuff) etc...
I hesitate to use an execute immediate, due to the troublesome quoting issues, but is there a good way to do something like this?
insert into $TABLENAME ...
-- Mark Harrison Pixar Animation StudiosReceived on Thu Aug 21 2008 - 16:58:03 CDT