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

chimaAsked:
Who is Participating?
 
SharathConnect With a Mentor Data EngineerCommented:
I think you need this.
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
 If not explain with an example.
0
 
Ivo StoykovConnect With a Mentor Commented:
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
 
chimaAuthor Commented:
I do apologize for the wait, I had other crisis to take care of.
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.