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
Example 24.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.