The utility function, att_local_name(), can be used to make a fully qualified table name from non-qualified or qualified one, i.e. the qualifier and owner will be added if they are missing. The schema name will be replaced with current qualifier on execution, owner will be replaced or added with name of supplied DSN name. All non-alphanumeric characters in the name will be replaced with underscore symbol.
A string will be returned containing the fully qualified table name.
This simple example shows retrieval of fully qualified table name. using the att_local_name() function from ISQL.
SQL> select att_local_name ('Oracle', 'DEMO.EMP'); callret VARCHAR _______________________________________________________________________________ DB.ORACLE.EMP 1 Rows. -- 9 msec.