Posted By

geekzspot on 12/04/12

Tagged

1 person have marked this snippet as a favorite

/ Published in: PL/SQL

Get the Database Name in a Script Bind Variable

VARIABLE database_name VARCHAR2(30)
BEGIN
  SELECT GLOBAL_NAME INTO :database_name FROM GLOBAL_NAME;
END;
/
SELECT :database_name FROM DUAL;

Comment:

You need to login to post a comment.