Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Stored Procedure

Garry123Garry123 Member Posts: 1
What table does oracle use to store Stored Procedure? is there a way to find out what stored procedures are created on a table.

Comments

  • nneomanneoma Member Posts: 61
    : What table does oracle use to store Stored Procedure? is there a way to find out what stored procedures are created on a table.
    :

    to find out information on your stored procedures, query the user_objects, all_objects or dba_objects table
    e.g select * from user_objects where upper(object_type) = 'PROCEDURE'
  • FrenchBartmanFrenchBartman Member Posts: 2
    : : What table does oracle use to store Stored Procedure? is there a way to find out what stored procedures are created on a table.
    : :
    :
    : to find out information on your stored procedures, query the user_objects, all_objects or dba_objects table
    : e.g select * from user_objects where upper(object_type) = 'PROCEDURE'
    :

    You can also find those lines into the "user_source" view.
    It contains PROCEDURE, FUNCTION, PACKAGE and PACKAGE BODY data.

    Regards.
  • infidelinfidel Member Posts: 2,900
    : What table does oracle use to store Stored Procedure? is there a way to find out what stored procedures are created on a table.

    Stored procedures are not created on tables. They may depend on tables, but are otherwise unrelated.

    user_objects and user_procedures will list the names
    user_source lists the source code
    user_dependencies lists which objects each object depends on


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

Sign In or Register to comment.