#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    3
    Rep Power
    0

    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. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    68
    Rep Power
    11
    There is an SQL*Plus command called PAUSE.
    Please have a look at:
    http://download-west.oracle.com/docs...h8.htm#1001342

    Cheers,
    Dan

IMN logo majestic logo threadwatch logo seochat tools logo