You name tables and views in CREATE TABLE and CREATE VIEW
    statements. In those and other SQL statements, the names you
    give to tables and views in CREATE statements can be qualified by
    aliases and can themselves qualify column names.

    If your database has the multischema option enabled, you can
    also qualify table and view names by schema and catalog names,
    or by the alias. You must use double quotation marks to surround
    the alias and table name pair and have set your dialect to the
    ANSI/ISO SQL standard or use the ANSI/ISO SQL standard quoting
    rules. See the SET_DIALECT and the SET_QUOTING_RULES for more
    information about dialects and quoting rules. The following are
    valid names for the EMPLOYEES table in the database with alias
    CORP, catalog ADMINISTRATION, and schema PERSONNEL:

    o  "CORP.ADMINISTRATION".PERSONNEL.EMPLOYEES

    o  "CORP.EMPLOYEES"

                                   NOTE

       In syntax diagrams, the table-name and view-name syntax
       elements refer to either the qualified or unqualified
       form of the names given to the table or view in the CREATE
       statement. That is, in syntax diagrams, table-name and view-
       name are always defined as:

  (B)0table-name =                                      
                                                    
  qwqqqqqqqqqqqqqqqqqqqqqqqqqwq> <name-of-table> qq>
   mqwq> <schema-name> w> . qj                      
     mq> <alias> qqqqqqj                            
                                                    

  (B)0view-name =                                        
                                                     
  qwqqqqqqqqqqqqqqqqqqqqqqqqqwq> <name-of-view> qqq> 
   mqwq> <schema-name> w> . qj                       
     mq> <alias> qqqqqqj                             
                                                     

    You must qualify table names and view names with an alias if they
    are not in the default database. The following example shows the
    error that SQL generates if you try to use an unqualified table
    name to refer to a database previously declared with an alias:

    SQL> ATTACH 'ALIAS PERS PATHNAME personnel';
    SQL> SET QUOTING RULES 'SQL92';
    SQL> SELECT * FROM EMPLOYEES;
    %SQL-F-NODEFDB, There is no default database
    SQL> -- This statement will work:
    SQL> SELECT * FROM "PERS.EMPLOYEES";