Pages

Oracle example table

Here is my example Oracle tables. I will refer to these tables at my example SQLs.

Table: students
ID NAME SURNAME BIRTHDAY STARTYEAR GPA COUNTRYCODE
1
John Smart 1/1/1987 9/1/2002
3.43
UK
2
Kamil Vəliyev 8/13/1984 9/1/2003
3.23
AZ
3
David Brown 3/2/1980 9/1/2004
2.33
US
4
Fad Hown 4/12/1985 9/1/2003
3.44
UA
5
Sam Jackson 4/5/1988 9/1/0207
3.12
ZW
6
Dawn Dane 2/3/1988 9/1/2004
3.2
TN
7
Emre Yüce 8/15/1987 9/1/2010
2.3
TR
8
Arif Salamov 12/11/1983 9/1/2008
3.2
AZ
9
Sad Matten 2/13/1988 9/1/2005
4.3
TT
10
Zeynal Zeynalov 6/9/1984 9/1/2001
3.5
AZ

CREATE TABLE  "STUDENTS" 
   ( "ID" NUMBER, 
 "NAME" NVARCHAR2(30) NOT NULL ENABLE, 
 "SURNAME" NVARCHAR2(30) NOT NULL ENABLE, 
 "BIRTHDAY" DATE, 
 "STARTYEAR" DATE, 
 "GPA" NUMBER, 
 "COUNTRYCODE" CHAR(2), 
  CONSTRAINT "STUDENTS_PK" PRIMARY KEY ("ID") ENABLE
   )
/

Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(1, 'John', 'Smart', TO_DATE('01/01/1987 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/2002 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3.43, 'UK');
Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(2, 'Kamil', 'Vəliyev', TO_DATE('08/13/1984 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/2003 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3.23, 'AZ');
Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(3, 'David', 'Brown', TO_DATE('03/02/1980 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/2004 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2.33, 'US');
Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(4, 'Fad', 'Hown', TO_DATE('04/12/1985 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/2003 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3.44, 'UA');
Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(5, 'Sam', 'Jackson', TO_DATE('04/05/1988 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/0207 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3.12, 'ZW');
Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(6, 'Dawn', 'Dane', TO_DATE('02/03/1988 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/2004 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3.2, 'TN');
Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(7, 'Emre', 'Yüce', TO_DATE('08/15/1987 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2.3, 'TR');
Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(8, 'Arif', 'Salamov', TO_DATE('12/11/1983 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3.2, 'AZ');
Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(9, 'Sad', 'Matten', TO_DATE('02/13/1988 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/2005 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4.3, 'TT');
Insert into STUDENTS
(ID, NAME, SURNAME, BIRTHDAY, STARTYEAR, GPA, COUNTRYCODE)
Values
(10, 'Zeynal', 'Zeynalov', TO_DATE('06/09/1984 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
TO_DATE('09/01/2001 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3.5, 'AZ');
COMMIT;

No comments:

Post a Comment