SQL Query using user_tab_columns and user_col_comments

[deeps3012]

Hi,
I am using user_tab_column s and user_col_commen ts to get details about the table.

Here is my code:
select * from user_tab_column s where table_name='sam ple_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_column s and user_col_commen ts to get details about the table.

Here is my code:
select * from user_tab_column s where table_name='sam ple_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:
[code=oracle]
SELECT * from all_tab_columns WHERE UPPER(table_nam e) = 'SAMPLE_TABLE';
[/code]

[OracleStudent]

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

select *
from user_tab_column s
where table_name='SAM PLE_TABLE';