Prompts in SQL Plus

[hummy]

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

[alison]

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