Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Fetch table procedure

Vicky007Nov 30 2009 — edited Nov 30 2009
Hi ,
i have 22 tables of name format as 'GenAgile%' and 28 tables of name format as 'GenMicro%' .

table format ==> Name std quantity release


i have to write a procedure which will fetch these tables which are of above format (GenAgile% , GenMiccro% ) and PCT_FREE != 10 from db .

after retrieving table list i have to
alter PCT_FREE column of each retrieved table (set it to number which is input to procedure).

can anyone help me out to form procedure as i am new to this PL world.

i try to form query as

select table_name from user_tables where PCT_FREE <> 10 and table_name like 'GenAgile%' or table_name like 'GenMicro%'

but i dont know how to get all table names in loop and use it in alter command to update its std column by input ?

please help me out.

i have to update col PCT_FREE of user_tables table to user input

Question updated please read context......Edited by: user8713254 on Nov 30, 2009 8:12 AM

Edited by: user8713254 on Nov 30, 2009 8:18 AM
This post has been answered by BluShadow on Nov 30 2009
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 28 2009
Added on Nov 30 2009
#procedure
9 comments
449 views