advanced code snippet search

Posted By

geekzspot on 12/04/12


Tagged

sql


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

geekzspot


Oracle Get the Schema Name in a Script

 / Published in: PL/SQL
 

Get the Schema Name into a Script Bind Variable

Expand | Embed | Plain Text 
  1. VARIABLE schema_name VARCHAR2(30)
  2. BEGIN
  3.   SELECT USER INTO :schema_name FROM DUAl;
  4. END;
  5. /
  6. SELECT :schema_name FROM DUAL;

Report this snippet  

You need to login to post a comment.