Category Shell Script

Oracle Database 11gR2, Oracle Database 12cR1, Shell Script

Variables: Shell Variables in SQL*PLUS

This is the second part of my blog about Shell scripting with focus on Oracle database. Here is an example of how you can use shell variables in sqlplus to create dynamic sql. Shell to SQLPLUS Here I am using…

Aamir
March 16, 2016

Oracle Database 11gR2, Oracle Database 12cR1, Shell Script

Variables: Shell, SQL*PLUS and PL/SQL

I am going to start blogging about shell scripting tips and technique focusing on database and how they can be used to make DBA life easier. Here is an example of how to save result from SQL query into Shell variable. Commands…

Aamir
March 11, 2016