pop up message

[coral09]

How to do pop up message using sqlplus in unix enviornment . When we do upgrades to databases we @upgrade.sql script.In the end of upgrade I want to pop up message after completion of upgrade script.
Like " database upgrade completion to patch 21
by checking version column value in my table version table.

Thanks in advance

 

[Dagon]

You can use a PROMPT command to display a message, but it won't pop up in the screen like a windows pop up box. SQL*Plus isn't really designed to be particularly visual - you would have to wrap something else around it.