November 23, 2008 01:31am pst

1. sdstuber 676,421
2. schwertner 384,978
3. angelIII 265,501
4. sujith80 201,114
5. dvz 144,471
6. shajukg 116,625
7. sonicefu 97,070
8. jinesh_ka... 89,814
9. MikeOM_... 85,874
10. johnsone 82,780
11. DrSQL 75,518
12. nav_kum_v 73,582
13. Tolomir 59,593
14. rolutola 56,619
15. markgeer 51,059
16. awking00 48,726
17. dbmullen 43,205
18. rbrooker 39,899
19. ajexpert 38,374
20. aiklamha 36,990
21. joebednarz 33,210
22. slightwv 32,399
23. sventhan 32,053
24. Milleniuma... 31,725
25. grzessio 29,350

1. sdstuber 734,321
2. schwertner 513,482
3. angelIII 425,452
4. sujith80 362,620
5. dvz 148,846
6. jinesh_ka... 145,734
7. johnsone 137,805
8. nav_kum_v 137,387
9. sonicefu 128,345
10. shajukg 116,625
11. MikeOM_... 111,542
12. Tolomir 106,221
13. slightwv 98,954
14. markgeer 97,986
15. DrSQL 75,518
16. jwahl 65,068
17. rolutola 63,612
18. awking00 63,265
19. rbrooker 61,374
20. joebednarz 59,624
21. YANN0S 57,625
22. oleggold 52,551
23. anand_2... 52,469
24. paquicuba 48,075
25. dbmullen 43,205

12.28.2007 at 09:00AM PST, ID: 23047456

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.2

Exexute sql statements using stored procedure

Asked by jagadeesh_motamarri in Oracle 10.x, Oracle Database, PL / SQL

Tags: deleting, procedure, statements, stored

Hi Experts -

I need to execute some series of sql statements using a stored procedure. I guess i can obviously do that using a EXEC but the issue i have is output of one sql statement is input for many other statements.

here is something i'm trying to do -

update table1 set flag = null where id_num =100 ( id_num is the input to the stored procedure )

SELECT area_id FROM area WHERE prop_id=100

SELECT subarea_id FROM subarea WHERE area_id = (the output values from the previous select statement - i would also need to use them somewhere else down the statemetns so i need to store them some how)

SELECT facility_id FROM facility WHERE subarea_id IN ( output from the previous statement - i need to store the output of the previous statement as well because i will need to use them later )

and then i've some delete statements

DELETE FROM attraction WHERE attra_id IN
( SELECT attra_id FROM prop.facility WHERE subarea_id IN (Output of the second sql again comes here) )

How to I accomplish this ? Please let me know if you need further clarification.

Thanks

Start Free Trial

Keywords: Exexute sql statements using stored pr…

	Title
1	SQL: Max Messages per User, Retai…
2	Need Help with a SQL Update Statement
3	How to execute a list of SQL statement…
4	distributed query t-sql update stateme…
5	T-SQL Select Statement
6	How do I get the 284 to show that ar…

Loading Advertisement...

20081112-EE-VQP-43 / EE_QW_2_20070628

Exexute sql statements using stored procedure

Asked by jagadeesh_motamarri in Oracle 10.x, Oracle Database, PL / SQL

Tags: deleting, procedure, statements, stored

About this solution