PL/SQL Newbie Questions

[Michael42]

Hello,

In Oracle 9i:

1. How can I display environment variables?
Without using !echo $ORACLE_HOME etc. I am looking for PL/SQL native methods.

2. How can I deisplay a simple text string.
Example: My Report

Thanks,

Michael42

 

[sem]

1. There's no "native" method as pl/sql is executed on server and it's environment settings are not the same as yours. Even if you run sql*plus on the same box.

2. Where? If you mean sql*plus then use prompt command. Of course this is not the only way but probably the simpliest one.

Regards, Dima

http://seminihin.narod.ru