I will explain my total requirement:-
We are developed script in PL/SQL. In the PL/SQL script i was got the fallout report(no. of rows records not extracted well).
Now client he was asking us like we want to execute the script in unix mechine. He was asking like while executing the PL/SQL script in unix the fallouts should be automatically store in Fallout table.Is it possible.
give me your mail id i will send my PL/SQL that will easy for both to understand.
Quote:
Originally Posted by thana
Code:
#!/bin/bash
sqlplus -s /nolog << EOF
CONNECT $DB_USER/$DB_PASSWORD
Your sql query here
................
.............
end;
/
EOF
|
