Re: sqlplus

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Mon, 7 Jan 2013 10:35:33 -0800 (PST)
Message-ID: <1357583733.312.YahooMailNeo_at_web121605.mail.ne1.yahoo.com>

 

Silent mode does not display the banner or any prompt once logged in.  It will, however, display query text as it's typed in and the results of that query, even 'no rows selected':
 

C:\Oracle_stuff\examples>sqlplus -s / as sysdba select * from dual;
 

D
-
X
 

select * from dba_tablespaces;
 

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS

------------------------------ ---------- -------------- ----------- -----------

MAX_EXTENTS   MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS    CONTENTS  LOGGING   FOR ----------- ---------- ------------ ---------- --------- --------- --------- --- EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION   BIG PREDICA ENC ---------- --------- --- ------ -------- ----------- --- ------- --- COMPRESS_FOR

---

SYSTEM                               8192          65536                       1


 2147483645 2147483645                   65536 ONLINE    PERMANENT LOGGING   NO

LOCAL      SYSTEM    NO  MANUAL DISABLED NOT APPLY   NO  HOST    NO
 

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS

------------------------------ ---------- -------------- ----------- -----------

MAX_EXTENTS   MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS    CONTENTS  LOGGING   FOR ----------- ---------- ------------ ---------- --------- --------- --------- --- EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION   BIG PREDICA ENC ---------- --------- --- ------ -------- ----------- --- ------- --- COMPRESS_FOR

---

SYSAUX                               8192          65536                       1


 2147483645 2147483645                   65536 ONLINE    PERMANENT LOGGING   NO

LOCAL      SYSTEM    NO  AUTO   DISABLED NOT APPLY   NO  HOST    NO
 

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS

------------------------------ ---------- -------------- ----------- -----------

MAX_EXTENTS   MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS    CONTENTS  LOGGING   FOR ----------- ---------- ------------ ---------- --------- --------- --------- --- EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION   BIG PREDICA ENC ---------- --------- --- ------ -------- ----------- --- ------- --- COMPRESS_FOR

---

UNDOTBS1                             8192          65536                       1


 2147483645 2147483645                   65536 ONLINE    UNDO      LOGGING   NO

LOCAL      SYSTEM    NO  MANUAL DISABLED NOGUARANTEE NO  HOST    NO
 

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS

------------------------------ ---------- -------------- ----------- -----------

MAX_EXTENTS   MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS    CONTENTS  LOGGING   FOR ----------- ---------- ------------ ---------- --------- --------- --------- --- EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION   BIG PREDICA ENC ---------- --------- --- ------ -------- ----------- --- ------- --- COMPRESS_FOR

---

TEMP                                 8192        1048576     1048576           1

            2147483645            0    1048576 ONLINE    TEMPORARY NOLOGGING NO
LOCAL      UNIFORM   NO  MANUAL DISABLED NOT APPLY   NO  HOST    NO
 

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS

------------------------------ ---------- -------------- ----------- -----------

MAX_EXTENTS   MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS    CONTENTS  LOGGING   FOR ----------- ---------- ------------ ---------- --------- --------- --------- --- EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION   BIG PREDICA ENC ---------- --------- --- ------ -------- ----------- --- ------- --- COMPRESS_FOR

---

USERS                                8192          65536                       1


 2147483645 2147483645                   65536 ONLINE    PERMANENT LOGGING   NO

LOCAL      SYSTEM    NO  AUTO   DISABLED NOT APPLY   NO  HOST    NO
 

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS

------------------------------ ---------- -------------- ----------- -----------

MAX_EXTENTS   MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS    CONTENTS  LOGGING   FOR ----------- ---------- ------------ ---------- --------- --------- --------- --- EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION   BIG PREDICA ENC ---------- --------- --- ------ -------- ----------- --- ------- --- COMPRESS_FOR

---

INDX                                 8192          65536                       1


 2147483645 2147483645                   65536 ONLINE    PERMANENT LOGGING   NO

LOCAL      SYSTEM    NO  AUTO   DISABLED NOT APPLY   NO  HOST    NO
 

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS

------------------------------ ---------- -------------- ----------- -----------

MAX_EXTENTS   MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS    CONTENTS  LOGGING   FOR ----------- ---------- ------------ ---------- --------- --------- --------- --- EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION   BIG PREDICA ENC ---------- --------- --- ------ -------- ----------- --- ------- --- COMPRESS_FOR

---

SMORF                                8192          65536                       1


 2147483645 2147483645                   65536 ONLINE    PERMANENT LOGGING   NO

LOCAL      SYSTEM    NO  AUTO   DISABLED NOT APPLY   NO  HOST    NO
 

7 rows selected.
 

select * from dual where 0=1;
 

no rows selected
 

I hope this is helpful.
 
 

David Fitzjarrell

---

From: Bobby Curtis <curtisbl_at_gmail.com> To: oracle-l_at_freelists.org
Sent: Monday, January 7, 2013 11:21 AM
Subject: Re: sqlplus

The -s is for silent mode.  sqlplus -h is the help menu and can explain more about the -s options.

Bobby L. Curtis
(e): curtisbl_at_gmail.com | (t): @curtisbl294 http://dbasolved.com

On 1/7/2013 1:19 PM, Zelli, Brian wrote:

> I am entering:
> sqlplus -s "/as sysdba"
> it just sits there.
>
> But when I enter:
> sqlplus "/as sysdba"
>
> I get the cursor  >.
>
> What does the -s actually do?
>
> ciao,
> Brian
>
>
>
>
> This email message may contain legally privileged and/or confidential information.  If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited.  If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 07 2013 - 19:35:33 CET