How to write a SQL procedure to automatically create table in Oracle?
Posted on 2009-04-26
How to write a SQL procedure to automatically create a table in Oracle?
I want to
- create a table
- create synonym
- grant all the necessary rights
However, the name of the table need to be dynamic,
If I schedule to the server to run the SQL procedure in December, then the code need to get the SYSDATE then add 1 year, then the name of the table will be INVOICES_2010
How can I do it?