|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Pausing a pl/sql statement
hi all,
is it possible to pause a pl/sql statement, then hit enter to continue. For example, a pl/sql statement returns a number of results, you only want to display one then pause for the user to read, then they press enter to continue, then the next result is displayed, then pause, and so on until the end on the results. i tried set pause on, but that doesn't work. any suggestions? cheers, waz. |
|
#2
|
|||
|
|||
|
There is an SQL*Plus command called PAUSE.
Please have a look at: http://download-west.oracle.com/doc...ch8.htm#1001342 Cheers, Dan |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Pausing a pl/sql statement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|