what is the meaning here?

forevercalz · #1 (**permalink**) 09-29-2005

#!/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?

monsanbu · #2 (**permalink**) 09-29-2005

-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.

forevercalz · #3 (**permalink**) 09-29-2005

thanks a miilion!

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-05-2008 02:10 AM
meaning of sintaxis: var=$'value' ?	alex_5161	Shell Programming and Scripting	2	05-30-2008 04:02 PM
if [ ! -r ${1} ] meaning in ksh	naveeng.81	Shell Programming and Scripting	1	04-09-2008 02:47 PM
what is the meaning of ppid 1?	darkrainbow	UNIX for Dummies Questions & Answers	2	08-02-2007 10:56 AM
Meaning of % sign	sokash	Shell Programming and Scripting	2	06-09-2006 12:30 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by