/[cvs.andrew.net.au]/uni/COMP2400/q4.sql
ViewVC logotype

Diff of /uni/COMP2400/q4.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by apollock, Mon Aug 9 12:40:39 2004 UTC revision 1.3 by apollock, Tue Aug 10 01:28:52 2004 UTC
# Line 6  Line 6 
6    
7  ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';  ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';
8    
9    TTITLE "COMP2400: Assignment 1: Question 4"
10    
11  COLUMN Name HEADING 'Name'  COLUMN Name HEADING 'Name'
12  COLUMN BirthDate HEADING 'Birthdate'  COLUMN BirthDate HEADING 'Birthdate'
13  COLUMN AgeAtDeath HEADING 'Age at death'  COLUMN AgeAtDeath HEADING 'Age at death'
# Line 14  SELECT Firstname || ' ' || Surname AS NA Line 16  SELECT Firstname || ' ' || Surname AS NA
16  FROM Person  FROM Person
17  WHERE DeathDate IS NOT NULL  WHERE DeathDate IS NOT NULL
18  ORDER BY BirthDate;  ORDER BY BirthDate;
19    
20    EXIT;

Legend:
Removed from v.1.2  
changed lines
  Added in v.1.3

  ViewVC Help
Powered by ViewVC 1.1.22