This has been around for a loooooong time.

But after a short chat with @oraclebase AKA Tim Hall yesterday, I thought I’d make sure we’re doing things right in the SQLDev tooling.

Tim uses it to make very nice, short, and sweet video demonstrations on his YouTube Channel. I highly recommend it. Anyways, back to PAUSE.

SET PAUSE ON [DOCS] in sql*plus allows a script to ‘pause’ until you hit ‘ENTER’ for it to continue.

We support this in SQLcl and SQL Developer now.

Nothing fancy, but it can be good for demo's or showing something to someone who can't read at the speed of light.
Nothing fancy, but it can be good for demo’s or showing something to someone who can’t read at the speed of light.

And in SQL Developer too.

Works best here if the lines don't wrap...not sure how useful it is in SQL Developer, but it's there.
Works best here if the lines don’t wrap…not sure how useful it is in SQL Developer, but it’s there.

SET PAUSE text works too!

SET PAUSE AreWeThereYet?

Don't make me turn this car around!
Don’t make me turn this car around!
The text is in the dialog/popup dialog...
The text is in the dialog/popup dialog…
thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

3 Comments

  1. There is one problem with it how to break it in sqldeveloper ? It looks it must fetch all data. Please add this functionality in next release.

    Regards
    Tomasz Lesinski

  2. Rajeshwaran, Jeyabal Reply

    Jeff, it seem to SQL Developer 4.1.2 build is out, but why no updates/notes on your blog about that yet ?

Write A Comment