The complete_table_name() can be used to make a fully qualified table name from non-qualified one, i.e. the qualifier and owner will be added if they are missing.
A string will be returned containing the fully qualified table name.
This simple example shows retrieval of a fully qualified table name using the complete_table_name() function from ISQL. In the first case the table name supplied is a system table, in the second case the table does not exist and the result is generated based on the users details:
SQL> use WS; Done. -- 4 msec. SQL> select complete_table_name('SYS_DAV_RES', 1); callret VARCHAR _______________________________________________________________________________ WS.WS.SYS_DAV_RES 1 Rows. -- 1 msec. SQL> select complete_table_name('SYS_DAV_RES__', 1); callret VARCHAR _______________________________________________________________________________ WS.DBA.SYS_DAV_RES__ 1 Rows. -- 1 msec.