Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Retrieving Database Name in PL/SQL

522396Jul 10 2006 — edited Jul 10 2006
I want to declare a variable whose value needs to be set to the database name. I don't want to pass it in as a parameter as it's an anonymous block in a unix script. Is there anyway other than assigning the variable "select * from global_name" within the executable section!?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2006
Added on Jul 10 2006
3 comments
232 views