Hi folks,
I want to write a job which executed sql scripts.
Do you know an way to execute sql plus script about a job and deliver the database password to this?
I dont know the database password and need a way to read it out from the datastore.
The second way whom I thought was to format the sql commands each line and then execute them in a sql function.
The problem is how I can convert the following format comfortable.
BEGIN
db_package.drop_table ('test');
END;
CREATE TABLE mytable
(
Column VARCHAR2 (1 CHAR)
);
...This is my goal formatted statement.
BEGIN db_package.drop_table ('test');END;
CREATE TABLE mytable( Column VARCHAR2 (1 CHAR));
...So I want to format the statements so that I get every statement in one row to execute it with a job.
aser (BOB member since 2017-05-09)