• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

SQL Global

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
chima
Asked:
chima
2 Solutions
 
Ivo StoykovCommented:
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
 
SharathData EngineerCommented:
I think you need this.
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
 If not explain with an example.
0
 
chimaAuthor Commented:
I do apologize for the wait, I had other crisis to take care of.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now