DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: spaces in code

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    spaces in code

    I have noticed sql statements with spaces in the v$sqlarea, e.g.
    SELECT * FROM EVENTS WHERE EVENTS_PROCESSED IS NULL ORDER BY EVENTS_ID
    SELECT * FROM DISPLAY_GROUP_NEW WHERE GROUP_ID = :b1 ORDER BY GROUP_SEQ

    I know a developer will use spaces in his procedures/packages so the code 'looks nice'. Should he be using tabs or CR instead? Does this take up extra space in the buffer cache? Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    (I presume that multiple spaces were stripped out of your post - use "code" tag = # in future).
    The cost of that extra memory must be negligible compared to the value of readable, maintainable code.

    (I had a tutor who called this kind of attention to detail "buggering flies"!)

Posting Permissions

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


Click Here to Expand Forum to Full Width