Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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?
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

select
TABLE_NAME
from user_tables where TABLE_NAME like 'BAL%'

View solution in original post

1 Reply
Anonymous
Not applicable
Author

select
TABLE_NAME
from user_tables where TABLE_NAME like 'BAL%'