Within PL/SQL script create table based on Oracle Edition
Usually I create Oracle tables by means of a script and then run that script from the SQL*Plus command line by means of SQL> @script_name.
Now we have a table that needs to be partitioned if we’re using the Oracle Enterprise Edition. Within our development environment we have the Standard Edtion and the table can therefore not be partitioned.
I therefore created 2 different scripts:
Within PL/SQL script create table based on Oracle Edition
Usually I create Oracle tables by means of a script and then run that script from the SQL*Plus command line by means of SQL> @script_name.
Now we have a table that needs to be partitioned if we’re using the Oracle Enterprise Edition. Within our development environment we have the Standard Edtion and the table can therefore not be partitioned.
I therefore created 2 different scripts: