Enhancements to the command window

[greg.mccarty]

I'm a relative newbee to Oracle. So, following the lead of some in the know, I buy one of Tom Kytes (asktom) books - Expert Oracle Programming Techniques...

In the setting up chapter, it has a great little script for login.sql that configures the session and sets the prompt. Unfortunately, it seems that plsql dev's command window doesn't support the same capabilities as sqlplus.

The plsql dev docs talk about using a bind variable in the 'set prompt' command. I figured out to use the 'variable' command to create what I think is a bind variable, but how do I populate it?

Thanks.

 

[Marco Kalter]

To populate a bind variable, you need to execute a PL/SQL Block. The following example declares the variable :var1, assigns the current username, and sets the prompt accordingly:

variable var1 varchar2(30)
begin
  :var1 := user;
end;
/
set prompt :var1