The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
meaning of .& in shell scorpio UNIX for Dummies Questions & Answers 1 06-04-2008 10:10 PM
meaning of sintaxis: var=$'value' ? alex_5161 Shell Programming and Scripting 2 05-30-2008 12:02 PM
if [ ! -r ${1} ] meaning in ksh naveeng.81 Shell Programming and Scripting 1 04-09-2008 10:47 AM
what is the meaning of ppid 1? darkrainbow UNIX for Dummies Questions & Answers 2 08-02-2007 06:56 AM
Meaning of % sign sokash Shell Programming and Scripting 2 06-09-2006 08:30 AM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 09-28-2005
Registered User
 

Join Date: Sep 2005
Posts: 74
what is the meaning here?

#!/bin/sh

$ORACLE_HOME/bin/sqlplus -S $orauserid/$orapasswd@$oradb << _TMP
alter session set nls_date_format = 'YYYYMMDD HH24:MI';
set linesize 100
set pagesize 400

ok the above is part of a script..i just wanna know what does sqlplus -S means?? as in why we need to insert the -S behind?
Reply With Quote
Forum Sponsor
  #2  
Old 09-29-2005
Registered User
 

Join Date: Sep 2005
Location: Chennai,India
Posts: 12
Smile

-S is to login to the sqlplus with SILENT option.

This suppresses all SQL*Plus information and prompt messages, including the command prompt, the echoing of commands, and the banner normally displayed when you start SQL*Plus.

If you omit username or password, SQL*Plus prompts for them, but the prompts are not visible.
Reply With Quote
  #3  
Old 09-29-2005
Registered User
 

Join Date: Sep 2005
Posts: 74
thanks

thanks a miilion!
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 11:58 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0