Searching the entire schema for a key

Page 1 of 1

2 Replies - 1367 Views - Last Post: 15 July 2006 - 05:20 PM Rate Topic: -----

#1 confusedprog  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 12-July 06

Searching the entire schema for a key

Posted 12 July 2006 - 03:03 AM

hi everybody,
please let me know how can i search for a particular key in the entire schema using a pl-sql script.
please help. its urgent.
Is This A Good Question/Topic? 0
  • +

Replies To: Searching the entire schema for a key

#2 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 247
  • View blog
  • Posts: 13,505
  • Joined: 12-July 02

Re: Searching the entire schema for a key

Posted 12 July 2006 - 05:37 AM

Are you referring to searching an entire databse (multiple tables) for a specific key, or searching one table? Do you need to find the field that is defined as the key, or are you searching for a specific value in one record? Is the key made of multiple fields, or a single field?
Was This Post Helpful? 0
  • +
  • -

#3 Wizzy  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 6
  • View blog
  • Posts: 408
  • Joined: 20-November 05

Re: Searching the entire schema for a key

Posted 15 July 2006 - 05:20 PM

View Postconfusedprog, on 12 Jul, 2006 - 09:55 AM, said:

hi everybody,
please let me know how can i search for a particular key in the entire schema using a pl-sql script.
please help. its urgent.


If you are trying to connect to tables that you don't know the names of, then give up; it hasn't been accomplished yet.
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1