[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

select column_name, data_type from all_tab_cols where table_name

Posted on 2009-05-05
4
Medium Priority
?
1,185 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
3 Comments
 
LVL 14

Expert Comment

by:ajexpert
ID: 24308119
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 2000 total points
ID: 24308193
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
ID: 24309990
thanks aj , I will try this and let you know.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

591 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