sqltables

Syntax

sqltables[[owner_name_pattern.]table_name_pattern]

Description

Prints results of a call to SQLTables. The pattern is a string containing an underscore ( _ ) to match any single character or a percent sign (%) to match zero or more characters.

Examples

Command> sqltables;
< <NULL>, SYS, ACCESS$, SYSTEM TABLE,  >
< <NULL>, SYS, ARGUMENT$, SYSTEM TABLE,  >
< <NULL>, SYS, CACHE_GROUP, SYSTEM TABLE,  >
< <NULL>, SYS, CACHE_GROUP_INTERVAL_STATS, SYSTEM TABLE,  >
< <NULL>, SYS, CACHE_GROUP_STATS, SYSTEM TABLE,  >
< <NULL>, SYS, COLUMNS, SYSTEM TABLE,  >
< <NULL>, SYS, COLUMN_HISTORY, SYSTEM TABLE,  >
< <NULL>, SYS, COL_STATS, SYSTEM TABLE,  >
< <NULL>, SYS, DEADLOCKCYCLES, SYSTEM TABLE,  >
< <NULL>, SYS, DEADLOCKS, SYSTEM TABLE,  >
< <NULL>, SYS, DEPENDENCY$, SYSTEM TABLE,  >
< <NULL>, SYS, DIR$, SYSTEM TABLE,  >
….….….….….….….….….….
331 rows found.

Command> sqltables SCOTT.T1;
0 rows found.

Command> sqltables SYS.DUAL;
< <NULL>, SYS, DUAL, SYSTEM TABLE,  >
1 row found.