Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    12

    Unanswered: Commenting Conventions in Views / SQL

    I'm working on creating views in SQL. So I have a file which creates multiples views and populates the database with these.

    I'm quite new to this whole Oracle / database thing, and was wondering is, are there standards for commenting such a file. Like I'm using something like
    /*
    @AUTHOR Joe Bloggs
    @DECRIPTION What this view does
    */

    Is something like this recommended / normal?

  2. #2
    Join Date
    Oct 2003
    Posts
    87
    /*
    FILEopulateXXX.SQL

    CREATED BY: John Smith, XYZ SYSTEMS INC.
    CREATED ON: 21 OCT 2003
    DESCRIPTION: First delete all rows in the XXX.YYY table, then re-populate it.
    REQUIREMENTS:
    Before running this script you MUST always run script ABC.
    Must be ran when the there is no activity running against the XXX, YYY, and ZZZ tables. The XXX table name contains the most current
    name, so BBB table can be ignored.

    MODIFIED BY: John Smith, XYZ SYSTEMS INC.
    MODIFIED ON: 29 OCT 2003
    MODIFICATION DESCRIPTION: Added code to first delete all rows in XXX table and get the max issue date for AAA'.

    MODIFIED BY:
    MODIFIED ON:
    MODIFICATION DESCRIPTION:

    */

    set echo on
    SPOOL populateXXX.LOG
    set serveroutput on size 999999
    Oracle - DB2 - MS Access -

  3. #3
    Join Date
    Oct 2003
    Posts
    12

    makes sense!

    Grand so, will try something along those lines, cheers!

Posting Permissions

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