Solved

SQL Global

Posted on 2009-05-13
3
165 Views
Last Modified: 2013-12-07
Hello,
I am searching the database to find out where the tags I am working with are located.  For example;  with         <VoltageType>AC</VoltageType>
I search to see where the "VoltageType" element is at.
My question is; Is there SQL command that would find the VoltageType regardless where it is at?  The SQL script I have needs to know in which table the element is at.
select   

          nd.device_name, 

from 

         HIGH_VOLTAGE.network_device nd,

Open in new window

0
Comment
Question by:chima
3 Comments
 
LVL 22

Assisted Solution

by:Ivo Stoykov
Ivo Stoykov earned 200 total points
ID: 24382177
no, but you could use user_tables dictionary to get all avaiable tables for logged user.
HTH
Ivo Stoykov

select table_name from user_tables

Open in new window

0
 
LVL 40

Accepted Solution

by:
Sharath earned 300 total points
ID: 24382332
I think you need this.
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
 If not explain with an example.
0
 

Author Closing Comment

by:chima
ID: 31581298
I do apologize for the wait, I had other crisis to take care of.
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

Suggested Solutions

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

757 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

23 Experts available now in Live!

Get 1:1 Help Now