<

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

Posted on
9,246 Points
5,946 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

Title Views Activity
SQL - The SELECT Statement 220
Query data with no SQL code (3) 29
Query data with no SQL code (6) 24
Query data with no SQL code (8) 21
When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass.   In this example a form flashes a message while the stored procedure executes, and then closes itself on…
In this article we will see to setup Oracle 23c free developer version using Vagrant project and the new features include on this version.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month