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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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%'