Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Provided Answers: 1

    Unanswered: UNused columns on cursor in oracle package procedure

    I want to clean up some cursors in a procdure in a oracle package.
    I want to remove the unused columns that are on the select statement in the cursors, Is there a Oracle tool or a system view( i.e. sys. ) that can be used to list the unused columns?

    Or will somebody reccommend a tool or script that can be used to produce a cross reference of the code so I can use the cross reference listing to determine unused/used columns/variables in a procedure.


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >I want to remove the unused columns that are on the select statement in the cursors,
    WHY? WHY? WHY?
    Data is read by data blocks.
    What measurable gain will result from your efforts?
    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
    Jun 2004
    Liverpool, NY USA
    Except if one of the unused columns is a BLOB or CLOB object, why worry about it?
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    May 2004
    Dominican Republic
    anacedent, how about if the cursor could be satisfied *touching* only, for example, an index structure ?

    Yes, Data is read by data blocks, but if *could* improve it to read the lesser data blocks, then you will see some "measurable gain".

    But I agree with you somehow, why change it if its not broken.

Posting Permissions

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