SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to write select query for all the user tables in database

874247Jul 8 2011 — edited Jul 14 2011

Can any one tell me how to select the columns from all the user tables in a database

Here I had 3columns as input...
1.phone no
2.memberid
3.sub no.

I have to select call time,record,agn from all the tables in a database...all database tables have the same column names but some may have additional columns..

Eg: select call time, record,agn from ah_t_table where phone no= 6186759765,memberid=j34563298

Query has to execute not only for this table but for all user tables in the database..all tables will start with ah_t

I am trying for this query since 30days...
Help me please....any kind of help is appreciated.....

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2011

Added on Jul 8 2011

#database, #pl, #query, #select, #sql

6 comments

377 views