<

Executing a SQL Script from a Unix Shell Script and Passing Parameters

Posted on
9,243 Points
5,943 Views
3 Endorsements
Last Modified:
Published
Experience Level: Beginner
4:56
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.
3
Author:Steve Wales
2 Comments
LVL 6

Comment

by:magento
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.
0
LVL 23

Author Comment

by:Steve Wales
Not quite sure what you're looking for.  You want to call a stored procedure that returns a value and then that value is captured in the shell script instead of the return value from the query as shown in the video ?
0

Suggested Videos

The UNION ALL (or UNION) operator is used to combine different result sets. This article focuses on handling the UNION ALL operator in a better way.
In this article we will see what new features are been release by Oracle for making SQL much efficient .

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month