I have a DDL script that contains creation of tables & sequences. I want to create a job for it. Plz let me know what components can I use for the same
"begin execute immediate 'CREATE TABLE customers ( customer_id number(10) NOT NULL, customer_name varchar2(50) NOT NULL, city varchar2(50) )'; execute immediate 'CREATE TABLE address ( address_id number(10) NOT NULL, address_line_1 varchar2(50) NOT NULL, city varchar2(50) )'; commit; end;"
The code I gave was an example of how you should code your tOracleRow component. The "Begin" and "End" keywords are standard Oracle functionality to allow multiple statements to fired together. Here is a description of the "Execute immediate" statemement (https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/executeimmediate_statement.htm).