CASE Statement Question -- Can this be done?

Hi All,

I need to create a script that can be run on different databases to create some objects. Problem is, the databases have different layouts, ie: the tablespaces are different.

Can I use the CASE statement to select a tablespace name from dba_tablespaces, and if the tablespace exists, create the objects in that tablespace, else create them in another?

So, the CASE statement would also have DDL statements..........

If I cannot do it this way, I'm open to other suggestions.

Thank you in advance. Received on Mon May 08 2006 - 09:25:35 CDT