<

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

Posted on
8,720 Points
5,421 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
In this article, we will see how we can automate the process of moving Oracle metadata to version control system, in my case I am using GIT using a simple shell script to avoid manual intervention.
One of my friends recently asked me how to do an AutoComplete feature. I thought it was easy and there are already a lot of examples online. But I wish to provide him with a working solution instead of providing links. And in this article, I will ex…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month