1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| SQL> create table PASSENGER (
2 ID_PASSENGER INTEGER not null,
3 ID_FLIGHT VARCHAR2(20) not null,
4 ID_SEAT INTEGER not null,
5 ID_GROUP INTEGER not null,
6 CLASS VARCHAR2(1024) not null,
7 CATEGORY VARCHAR2(30),
8 VALIDITY SMALLINT not null,
9 STATUS VARCHAR2(12) not null,
10 FIRST_NAME_PASSENGER VARCHAR2(30) not null,
11 LAST_NAME_PASSENGER VARCHAR2(30) not null,
12 TEL VARCHAR2(30),
13 ADDRESS VARCHAR2(30),
14 ZIPCODE VARCHAR2(30),
15 CITY VARCHAR2(30),
16 PHOTOS VARCHAR2(30),
17 BIRTH_DATE DATE,
18 SEX VARCHAR2(30),
19 EXPIRATION_DATE DATE,
20 NATIONNALITY VARCHAR2(30),
21 WITHDRAWAL SMALLINT,
22 WITHDRAWAL_REASON VARCHAR2(30),
23 constraint PK_PASSENGER primary key (ID_PASSENGER)
24 );
Table created.
SQL>
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'dd.mm.yyyy hh24:mi:ss';
Session altered.
SQL>
SQL>
SQL> insert into PASSENGER (ID_PASSENGER, ID_FLIGHT, ID_SEAT, ID_GROUP, CLASS, CATEGORY, VALIDITY, S
TATUS, FIRST_NAME_PASSENGER, LAST_NAME_PASSENGER, TEL, ADDRESS, ZIPCODE, CITY, PHOTOS, BIRTH_DATE, S
EX, EXPIRATION_DATE, NATIONNALITY, WITHDRAWAL, WITHDRAWAL_REASON)
2 values (4, '883Z', 4, 4, '1', 'VIP', 1, '1', 'Michel ', 'Drucker', '0687689045', '223 RUE DE LA
SAUTERIE',
3 '75016', 'Paris', 'Chemin','17.02.2007 09:29:17','M', '03.10.2009 04:40:16','French',1,'Perte d
u passeport');
1 row created.
SQL> |
Partager