uni/COMP2400/q3.sql

-- I have read the ANU Code on "Academic Honesty in Learning and Teaching",
-- and I declare that, except where appropriately attributed, the content
-- of the file I have submitted for this assignment is entirely my own
-- work. It has not been produced, in whole or in part, by another person.
-- (signed) Andrew Pollock 4137129

ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';

SET PAGESIZE 25

TTITLE "COMP2400: Assignment 1: Question 3|Andrew Pollock (4137129)"

COLUMN Name HEADING 'Name'
COLUMN Birthdate HEADING 'Birthdate'

SELECT INITCAP(Firstname || ' ' || Surname) AS Name, Birthdate
FROM Person
WHERE PersonId NOT IN (SELECT PersonId
                        FROM Parents);

EXIT;
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
7	ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';
8
9	SET PAGESIZE 25
10
11	TTITLE "COMP2400: Assignment 1: Question 3\|Andrew Pollock (4137129)"
12
13	COLUMN Name HEADING 'Name'
14	COLUMN Birthdate HEADING 'Birthdate'
15
16	SELECT INITCAP(Firstname \|\| ' ' \|\| Surname) AS Name, Birthdate
17	FROM Person
18	WHERE PersonId NOT IN (SELECT PersonId
19	FROM Parents);
20
21	EXIT;