-
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.
-
(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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|