<div>
Yes, of course I can. &nbsp;That's what I was looking for. &nbsp;Specifically: SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA').<br />
<br />
Thanks!
</div>


Yes, of course I can.  That's what I was looking for.  Specifically: SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA').

Thanks!

<div>
<div class="content wysiwyg-content">
(Oracle 9)<br />
<br />
Within a trigger, I want to know what schema the trigger lives in. &nbsp;The thing is I have the same trigger living in several different schemas, all with the same name. &nbsp;So doing a select off of dba_objects won't get me anywhere b/c the &quot;object_name&quot; column isn't a unique identifier. &nbsp;I.e.:<br />
<br />
SCHEMA1.USR_TRG<br />
SCHEMA2.USR_TRG<br />
<br />
-- USR_TRG --<br />
...<br />
schemaName := ?<br />
-- do something with the schema name now<br />
<br />
Any ideas on how to uniquely identify the trigger and its owner?
</div>
</div>


(Oracle 9)

Within a trigger, I want to know what schema the trigger lives in.  The thing is I have the same trigger living in several different schemas, all with the same name.  So doing a select off of dba_objects won't get me anywhere b/c the "object_name" column isn't a unique identifier.  I.e.:

SCHEMA1.USR_TRG
SCHEMA2.USR_TRG

-- USR_TRG --
...
schemaName := ?
-- do something with the schema name now

Any ideas on how to uniquely identify the trigger and its owner?

Find object owner when more than one have same name

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.