Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE student
(
idnumber VARCHAR2(8),
firstname VARCHAR2(20),
lastname VARCHAR2(20),
dateofbirth DATE,
address VARCHAR2(20),
email VARCHAR2(20),
programme VARCHAR2(5),
points number(3),
PRIMARY KEY (idnumber)
);
INSERT INTO student VALUES
(  
'D1234567',
'Student ONE',
'TWO THREE',
DATE '2000-05-10',
'Thetown,thedress',
'd1234567@mydit.ie',
'DT228',
'380'
);
1 rows affected

INSERT INTO student VALUES 
(
'D2345678',
'Student TWO',
'FOUR FIVE',
DATE '2000-04-10',
'Thetown,the adress',
'd2345678@mydit.ie',
'DT228',
'280'
);
1 rows affected

SELECT firstname, lastname
FROM student
WHERE points > 300;


FIRSTNAME
LASTNAME


Student ONE
TWO THREE