Gestion des Views

Création :

CREATE OR REPLACE VIEW EMPRUNTS (DK_UNIMARC,CODE_BARRE,BIBLIOTHEQUE,FONDS)
AS SELECT AUTOR_2,TEXT1,COUNT2,COUNT4 from DSTAT
WHERE SYSDATE - TO_DATE(DSTAT.SDATE,'YYYYMMDDHHMISS') < 366
AND TYPE = 1
WITH READ ONLY;

Lister ses views :

SELECT VIEW_NAME from USER_VIEWS; 

Détruire une view :

DROP VIEW EMPRUNTS;