Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checking Column Existence in all the Tables of Database

Status
Not open for further replies.
ksr

ksr

MIS
Jul 3, 2001
11
IN
Is it possible with a single SQL Statement to know the names of all the tables having column "MemberID" and check the existence of "MemberId - 2365NRM" is all the scanned tables.
 
Sort by date Sort by votes
This is not possible with single statement, but you may write quite simple pl/sql procedure looping throu the list of those tables (query from USER_TAB_COLUMNS) and making dynamic requests (using REF CURSOR or EXECUTE IMMEDIATE).

Regards, Dima
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
813
carp
carp
rk68
  • Question
Data encryption in Oracle 19c
Replies
0
Views
104
rk68
rk68
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
361
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
903
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Modify columns - parts of virtual column 2
Replies
8
Views
1K
carp
carp

Part and Inventory Search

Sponsor

Back
Top