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