Name
att_local_name — Compose a fully qualified table name based on DSN and remote table name.
Synopsis
varchar att_local_name ( |
in dsn varchar , |
in table varchar
) ; |
Description
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.
Parameters
dsn
The name of remote data source.
table
The name of remote table.
Return Types
A string will be returned containing the fully qualified table name.
Examples
Example24.19.Using the att_local_name() function
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.