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

Annotation of /uni/COMP2400/q9.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.6 - (hide annotations)
Wed Aug 11 22:48:11 2004 UTC (18 years, 5 months ago) by apollock
Branch: MAIN
CVS Tags: HEAD
Changes since 1.5: +1 -1 lines
Base questions ready for submission

1 apollock 1.1 -- I have read the ANU Code on "Academic Honesty in Learning and Teaching",
2     -- and I declare that, except where appropriately attributed, the content
3     -- of the file I have submitted for this assignment is entirely my own
4     -- work. It has not been produced, in whole or in part, by another person.
5     -- (signed) Andrew Pollock 4137129
6 apollock 1.2
7     -- List persons whose parents were not married (to each other) at the time of
8     -- the person's birth.
9 apollock 1.3
10 apollock 1.4 ALTER SESSION SET NLS_DATE_FORMAT = 'dd/mm/yyyy';
11    
12 apollock 1.6 TTITLE "COMP2400: Assignment 1: Question 9|Andrew Pollock (4137129)"
13 apollock 1.4 COLUMN NAME HEADING "Name"
14     COLUMN BIRTHDATE HEADING "Birthdate"
15     COLUMN MARRIAGEDATE FORMAT A15 HEADING "Parent's|marriage date"
16    
17 apollock 1.5 --SELECT INITCAP(pe.firstname || ' ' || pe.surname) AS Name, pe.birthdate, m.marriagedate
18     SELECT INITCAP(pe.firstname || ' ' || pe.surname) AS Name
19 apollock 1.4 FROM parents pa
20     JOIN marriage m ON (pa.motherid = m.wifeid)
21     JOIN person pe ON (pe.personid = pa.personid)
22     WHERE pe.birthdate NOT BETWEEN m.marriagedate AND m.terminationdate;
23    
24     EXIT

  ViewVC Help
Powered by ViewVC 1.1.22