tache 4

CREATE OR REPLACE VIEW LongWait
AS
SELECT IdO, IdClient, OrderDate, OrderState, OrderDateECT, DENSE_RANK() OVER(ORDER BY OrderDateECT) AS Rang
FROM Oorder
WHERE OrderState = 'ECT';
/

select * from LongWait;

Comments

[abc]

CREATE OR REPLACE VIEW LongWait
AS
SELECT IdO, IdClient, OrderDateECT, OrderState, DENSE_RANK() OVER(ORDER BY OrderDateECT) AS Rang
FROM Oorder where orderstate = 'ECT'
/


rem pour executer la view il faut utiliser select * from LongWait;