SQL Query using user_tab_columns and user_col_comments

[deeps3012]

Hi,
I am using user_tab_columns and user_col_comments to get details about the table.

Here is my code:
select * from user_tab_columns where table_name='sample_table';

After running this query in TOAD/Oracle SQL plus, i get "no rows selected".

Sample table:

NAME AGE CUST_ID
---------- ---------- ----------
deepali 22 68162
hrishikesh 23 69876
prashant 25 78162

Please help me out.

Thanks,
Deepali

[amitpatel66]

Hi,
I am using user_tab_columns and user_col_comments to get details about the table.

Here is my code:
select * from user_tab_columns where table_name='sample_table';

After running this query in TOAD/Oracle SQL plus, i get "no rows selected".

Sample table:

NAME AGE CUST_ID
---------- ---------- ----------
deepali 22 68162
hrishikesh 23 69876
prashant 25 78162

Please help me out.

Thanks,
Deepali

Hi Deepali,

Try using below Query:

SELECT * from all_tab_columns WHERE UPPER(table_name) = 'SAMPLE_TABLE';
 

[OracleStudent]

Try putting 'sample_table' in upper case, like this:

select *
from user_tab_columns
where table_name='SAMPLE_TABLE';