一家公司招聘考试题，oracle存储过程问题请教

rollingpig

我会create一个function ,

1. 
   
2. Create or replace function pos(a number , b number , c number ,
   
3. d number , e number , pos number)
   
4. return number
   
5. as
   
6. ret number ;
   
7. begin
   
8. select v into ret from
   
9. (select v , rownum as r from
   
10. (select a as v from dual
    
11. union all
    
12. select b from dual
    
13. union all
    
14. select c from dual
    
15. union all
    
16. select d from dual
    
17. union all
    
18. select e from dual
    
19. order by 1
    
20. )
    
21. )where r = pos ;
    
22. return ret;
    
23. end;
    
24. /
    

复制代码