[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

Posted on 2014-08-14

7,132 Points

2 Comments

3,832 Views

3 Endorsements

Last Modified: 2014-08-26

Experience Level: Beginner

4:58

Steve Wales

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.

Comment

Author:Steve Wales

2 Comments

LVL 5

Expert Comment

by:magento2015-02-21

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.

LVL 23

Author Comment

by:Steve Wales2015-02-21

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 ?

Join & Write a Comment Already a member? Login.

Suggested Videos

Title	Views	Activity
Using the Original Oracle Export and Import Utilities	533	5h
Restoring a Database from User Managed Backups with Oracle	397	2018-10-14
Set Up Backup with Maintenance Plans (SQL Server)	459	2018-11-07
Dealing with Dates: Data Types and String Conversions (SQL Server)	311	1d