Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Posts
    173
    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.

    tia

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    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
    Location
    Liverpool, NY USA
    Posts
    2,509
    Except if one of the unused columns is a BLOB or CLOB object, why worry about it?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    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
  •