Is it possible to get the table name for a given rowid ?
if it is possible then how ?
Please help .
Thanks in advance .
Difference between ROWNUM and ROWID
ROWNUM vs ROWID ROWID tROWID is a pseudo column in a table which store and return row address in HEXADECIMAL format with database tables.ROWID is the permanent unique identifiers...
Naming Conventions given for lock object
1. Object Name start with EZ OR EY . Go to SE11 2. Give the lock object name EZDUSH(lock object name start with EZ) and click 'Create' Button. 3. Enter the short description, Table...
Dynamic Table Names and Moving Table
I'm fairly new to PL/SQL and I could use some help. I'm trying to create a cursor and build the tablename based on an input parameter. Currently I'm using DBMS.SQL statements, which I find cumbersome...
Oracle TNS Name Interview Questions
ORA-12154: TNS:could not resolve service name R3trans or work processes terminate with the following errors: C *** ERROR => OCI-call 'olog' failed: rc = 12154 C *** ERROR...