How to execute the following query without using tempselect * from temp;

Interview Candidate
Mar 13th, 2006
2
1686

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

hs_kashyap
Profile Answers by hs_kashyap

Apr 25th, 2006

SELECT * FROM (SELECT TABLENAME FROM USER_TABLES WHERE TABLENAME LIKE 'TEM_')
Please make check the column name is TABLENAME or TABLE_NAME.

Vamseek
Profile Answers by Vamseek Questions by Vamseek

Nov 10th, 2006

SELECT * FROM (SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME LIKE 'TEST');
Above query will give the result as
TEST.
If you dont want to use the table name directly in the query, you can create synonym for that table and can use that synonym in your query.
-Vamsee