Admin Admin
Nombre de messages : 418 Date d'inscription : 27/09/2005
| Sujet: Dates Mar 4 Avr à 17:34 | |
| fichier ex_empl.sql - Code:
-
drop table Employe;
CREATE TABLE Employe( no NUMBER(3) PRIMARY KEY, nom VARCHAR2(25), age NUMBER(2), dateEmb DATE );
quit; fichier test_sur_empl.sql - Code:
-
SELECT * FROM Employe;
SELECT * FROM employe WHERE extract(month from dateemb)=11;
SELECT * FROM employe WHERE extract(year from dateemb)<2001;
SELECT sysdate -60 FROM employe;
INSERT INTO employe VALUES (6,'pabo',25,'25-FEB-05'); INSERT INTO employe VALUES (7,'tudor',30,'25-MAR-05'); INSERT INTO employe VALUES (8,'vero',21,'4-APR-05'); INSERT INTO employe VALUES (9,'louison',20,'25-JAN-05');
SELECT * FROM employe WHERE dateemb between sysdate-90 AND sysdate;
quit; | |
|