Advanced Search

Return to Snippet

Revision: 68885
at March 10, 2015 21:57 by Igeco
Initial Code 
select procedure_name
 from all_procedures
 where owner = 'YOU'
 and object_name = 'YOUR_PACKAGE'
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This only shows public procedures, not the privates one declares only in packages body.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Get all procedures from Oracle packages

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL