One Star

[resolved] What columns beside "TNAME" can be used in Retrieve Schema/Sql Filter?

Default Query is:
SELECT TNAME FROM TAB WHERE TNAME LIKE 'BAL%'

I guess, for oracle "TAB", is converted internally to something like: "( select object_name TNAME, ... from all_objects ) TAB".
Does it have other columns, I could use to filter?
1 ACCEPTED SOLUTION

Accepted Solutions
Seventeen Stars

Re: [resolved] What columns beside "TNAME" can be used in Retrieve Schema/Sql Filter?

select
TABLE_NAME
from user_tables where TABLE_NAME like 'BAL%'
1 REPLY
Seventeen Stars

Re: [resolved] What columns beside "TNAME" can be used in Retrieve Schema/Sql Filter?

select
TABLE_NAME
from user_tables where TABLE_NAME like 'BAL%'