select column_name, data_type from all_tab_cols where table_name

Hi all,
         I ran this query " select column_name, data_type from all_tab_cols where table_name = 'DIF_OWNER.DIF_SEC_IMPORT_CREDIT' " inorder to get the column name of the particular table, but i am getting empty result. am I missing something.
balatrueAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ajexpertConnect With a Mentor Commented:
This will also work


SELECT COLUMN_NAME, DATA_TYPE
FROM ALL_TAB_COLS
WHERE TABLE_NAME = 'DIF_SEC_IMPORT_CREDIT'
AND OWNER = 'DIF_OWNER'

Open in new window

0
 
ajexpertCommented:
You should try


SELECT COLUMN_NAME, DATA_TYPE
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'DIF_SEC_IMPORT_CREDIT'
AND OWNER = 'DIF_OWNER'

Open in new window

0
 
balatrueAuthor Commented:
thanks aj , I will try this and let you know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.