Prompts in SQL Plus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Prompts in SQL Plus

  1. #1
    Join Date
    Apr 2001
    Posts
    55

    Post

    Does anyone know how i can simply display some messages in SQLPlus? I'm not sure what the syntax is to put up a certain message after running a particular script.

    I believe that DOS has this function by simply putting an ECHO command when you want the promt to appear, it is a similar sort of function that i am looking for in SQLPlus.

    Thx

  2. #2
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Hi Hummy,

    You can use the PROMPT command for example the following script

    PROMPT LATCH: LOW LEVEL MECHANISMS USED TO PROTECT SHARED DATA STRUCTURES
    PROMPT
    PROMPT GETS: SUCESSFULL WILLING TO WAIT REQUESTS
    PROMPT MISSES: UNSUCESSFULL WILLING-TO-WAIT REQUEST
    PROMPT IMMEDIATE_GETS: SUCESSFULL IMMEDIATE REQUEST
    PROMPT IMMEDIATE_MISSES: UNSUCESSFULL IMMEDIATE REQUEST
    select
    c.name,
    a.gets,
    a.misses,
    a.immediate_gets,
    a.immediate_misses
    from v$latch a, v$latchname c
    where a.latch# = c.latch#
    and a.name = 'redo copy';

    will give the following output:-

    SQL> @latches
    LATCH: LOW LEVEL MECHANISMS USED TO PROTECT SHARED DATA STRUCTURES

    GETS: SUCESSFULL WILLING TO WAIT REQUESTS
    MISSES: UNSUCESSFULL WILLING-TO-WAIT REQUEST
    IMMEDIATE_GETS: SUCESSFULL IMMEDIATE REQUEST
    IMMEDIATE_MISSES: UNSUCESSFULL IMMEDIATE REQUEST

    NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES
    -------------------- ---------- ------- -------------- ----------------
    redo copy 196 0 5636 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width