Solved

select column_name, data_type from all_tab_cols where table_name

Posted on 2009-05-05
4
1,142 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:balatrue
  • 2
4 Comments
 
LVL 14

Expert Comment

by:ajexpert
Comment Utility
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
 
LVL 14

Accepted Solution

by:
ajexpert earned 500 total points
Comment Utility
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
 

Author Comment

by:balatrue
Comment Utility
thanks aj , I will try this and let you know.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now