Is it possible to get the table name for a given rowid ?
if it is possible then how ?
Please help .
Thanks in advance .
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 Index Organized Tables (IOTs)
1. What is an Index Organized Table (IOT)?An Index Organized Table (IOT) is a table that is sorted internally as an index.Other database systems such as MAXDB or DB2 use IOTs by default, whereas on...
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...