home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
EWSQDOCN.QRY
< prev
next >
Wrap
Text File
|
1997-09-12
|
574b
|
27 lines
#NAME#
DA_OracleTableColumnName
#DESCRIPTION#
The column name glossary query returns the names of Oracle tables which contain a column which matches the column name specified in the WHERE clause.
View type: DAQOracleTable
Modifications:
Change the search criteria of the ColumnName attribute in the SQL WHERE clause
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT
t.oracleTable,
td.tableDefinition,
td.columnName
FROM
DAQOracleTable t,
(t.usesTableDefinition) td
WHERE
td.columnName like '%'
ORDER BY
t.oracleTable,
td.columnName;