Oracle how to get an object Id from the rowid

 Oracle how to get an object Id from the rowid

=================================


select dbms_rowid.rowid_object('<RowID>') from dual;


select data_object_id, object_name, object_type from dba_objects where data_object_id in ('<OBJECT_ID>');

By

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

View running queries in postgresql

 View running queries in postgreSQL： SELECT * FROM pg_stat_activity;