A reader, March 14, 2020 - 3:46 pm UTC
I checked the query result it is not returning anything but when running select count(*) from table name i am getting the result. What code should i use
kuldeep, March 15, 2020 - 5:28 am UTC
Hi,
When I running the Sql query SELECT table_name FROM user_tables
not seeing my table name in the results but table exist in the DB. Could you help out?
Check the table name
A reader, March 16, 2020 - 5:57 am UTC
The table names should be in UPPER CASE unless these were created in the mixed case using double quotes.
Try querying using the table names in UPPER CASE.
SELECT table_name FROM user_tables WHERE table_name IN ('Detailed_REPORT_AGENT','Summary_REPORT_AGENT'
** If the above does not return any rows then:
SELECT table_name FROM user_tables WHERE UPPER(table_name) IN ('DETAILED_REPORT_AGENT','SUMMARY_REPORT_AGENT');
Cheers
kuldeep, March 16, 2020 - 7:50 am UTC
Thank you. By running the below query I can see the table name and procedure is also working.
SELECT table_name FROM user_tables WHERE UPPER(table_name)
IN ('DETAILED_REPORT_BGO_AGENT','SUMMARY_REPORT_BGO_AGENT')
March 16, 2020 - 10:19 am UTC
Glad you worked it out.
kuldeep, March 16, 2020 - 5:17 pm UTC
But I have created 5 tables, only showing 3 tables name. Still struggling why the other 2 tables' names are missing. Any idea?
March 17, 2020 - 10:01 am UTC
What exactly is the DDL for the missing tables and how are you searching for them in user_tables?
Asking for resolution
David Baldwin, October 21, 2021 - 2:18 pm UTC
Hello,
This is my first comment on asktom. I was just wondering if someone can comment to help us find the resolution to kuldeep's final comment on the thread here.
October 22, 2021 - 3:16 am UTC
Welcome!
Apologies
David Baldwin, October 21, 2021 - 2:19 pm UTC
I see now that kuldeep is the one who did not reply.