Executing a SQL Script from a Unix Shell Script and Passing Parameters
Posted on
8,364 Points
4:58
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
2 Comments
Hi Steve,
Thanks for information very useful.
In the sameway can you please create a simple video which runs a procedure and store the output of the procedure in shell script to proceed further.
Thanks in advance.
Thanks for information very useful.
In the sameway can you please create a simple video which runs a procedure and store the output of the procedure in shell script to proceed further.
Thanks in advance.
Suggested Videos
| Title | Views | Activity |
|---|---|---|
| Restore Database from RMAN Backup (Oracle) | 936 | |
| SQL - The SELECT Statement | 211 | |
| SQL - Updating and Deleting Data | 281 | |
| Importing a DynamoDB Table From an S3 Export | 1,342 |
Are you ready for a Linked Table Manager (LTM):
- with a sizable form
- which identifies which connections are valid and how many tables are associated with the connection
- which doesn't ask you to select the BE multiple times when you've ident…
ORA-12547: TNS:lost contact, "sqlplus / as sysdba"
