how towrite sql in shell scripting - Shell Programming and Scripting

naveeng.81 · #1 (**permalink**) 03-20-2008

hi
iam new of scipiting.give me the some Material of regarding sql in scripting.
and i have no backup's in 3 severs.how to write script in dirctory.
please give me some usefull information

cheers
Naveen.g

raman1605 · #2 (**permalink**) 03-20-2008

Here is sm example code that you can use accordingly.

Code:

  diffdays=`sqlplus -s <username>/<password> <<END
  set pagesize 0
  set feedback off
  set heading off
  set echo off
  set verify off
  select to_date($sysdate, 'yyyymmdd') - to_date($currfile, 'yyyymmdd')   from dual;

diffdays will be having the output of the query in this case

curleb · #3 (**permalink**) 03-20-2008

Just make sure you note the heredoc in the example ... and that you make sure to close it:

Code:

  diffdays=`sqlplus -s <username>/<password> <<END
  set pagesize 0
  set feedback off
  set heading off
  set echo off
  set verify off
  select to_date($sysdate, 'yyyymmdd') - to_date($currfile, 'yyyymmdd')   from dual;

Code:

END `

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Hi Can any one help me out from this Iam new to shell scripting	kreddy2003	Shell Programming and Scripting	0	05-27-2008 11:54 PM
need some help on shell scripting..	hilofat	Shell Programming and Scripting	6	02-03-2008 08:23 AM
Help need in Shell Scripting	raghav1982	Shell Programming and Scripting	11	12-04-2007 02:05 AM
Shell scripting and SQL	sendhilmani123	Shell Programming and Scripting	5	04-22-2006 06:06 AM
difference between AIX shell scripting and Unix shell scripting.	haroonec	Shell Programming and Scripting	2	04-12-2006 05:12 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode