Oracle Fusion Middleware Java API Reference for Oracle Extension SDK
11g Release 2 (11.1.2.1.0)

E17493-02

oracle.javatools.db.sql
Interface SqlAliasExpander


public interface SqlAliasExpander

A utility to resolve table alaiases in SQL so that a list of Usages can be returned, each with a List<String> and int offsets. SQL reserved words are not guarenteed to be filtered.


Nested Class Summary
static interface SqlAliasExpander.Usage
           
 
Method Summary
 java.util.Collection<SqlAliasExpander.Usage> getUsages(PlSqlToken startToken, PlSqlToken endToken)
          Get Usages for the SQL found between the two given PlSqlTokens.
 java.util.Collection<SqlAliasExpander.Usage> getUsages(java.lang.String sql)
          Get Usages for the given SQL.
 

Method Detail

getUsages

java.util.Collection<SqlAliasExpander.Usage> getUsages(java.lang.String sql)
Get Usages for the given SQL. Offsets will be zero-based from the start of the String.

Parameters:
sql -
Returns:

getUsages

java.util.Collection<SqlAliasExpander.Usage> getUsages(PlSqlToken startToken,
                                                       PlSqlToken endToken)
Get Usages for the SQL found between the two given PlSqlTokens. Offsets will be zero-based from the start of the string that was tokenized to provide the tokens.

Parameters:
startToken - Token at the start of the sql
endToken - Token at the start of the sql
Returns:

Oracle Fusion Middleware Java API Reference for Oracle Extension SDK
11g Release 2 (11.1.2.1.0)

E17493-02

Copyright © 1997, 2011, Oracle. All rights reserved.