Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Posts
    11

    Unanswered: list procedures in oracle

    HI,
    i am a beginner in oracle and would like to know what is the command to list all the stored procedures. How can we edit an existing stored procedure.
    PLease advise

    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Select * From All|dba|user_objects
    Where .....
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Hi,
    EDITing a procedure means you want to modify some code etc. etc. This is best viewed in some tool so that you may get the complete details. The tool like PL/SQL developer or TOAD etc. which is free download from web.

    Also, you have entire details of a procedure in a system tables called USER_SOURCE. You may get details from here and may spool to some file, modify it and then replace it. etc. etc.

    Hope, it helps you.

    Thanks.

    Regards,
    Kamesh Rastogi
    - KR

  4. #4
    Join Date
    Mar 2007
    Posts
    2
    Asalam o alikum ..
    Your problem is simple just write the query..
    select * from user_objects where object_type = 'PROCEDURES';

    so that's it... you may also restrict column by name the column of table after select...
    Quiet sure it helps..

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Do you REALLY think that OP didn't get the answer since 2004?

  6. #6
    Join Date
    Mar 2007
    Posts
    2
    Ohh .. I did'nt see the date and post the reply
    this is because, It accidently come in front of me by google search and....
    you know what happened, any way.. thanks for reminding me about this mistake..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •