TP1 S3 S3
On boucle dans les données et on insère dans la nouvelle table.**Copier votre script PL/SQL ou JAVA et imprime écran de votre table remplis**CREATE TABLE meilleure_vendeur ( id NUMBER(12, 0)GENERATED BY DEFAULT AS IDENTITY START WITH 1 PRIMARY KEY, nom VARCHAR2(255), annee NUMBER(4, 0), total NUMBER(10, 2), moyenne NUMBER(10, 2));DECLARE nomPL VARCHAR2(255); totalPL NUMBER; moyennePL NUMBER;BEGIN FOR annee IN ( SELECT EXTRACT(YEAR FROM order_date) annee FROM orders GROUP BY EXTRACT(YEAR FROM order_date) ) LOOP --dbms_output.put_line(annee.annee); SELECT to_char((first_name || ' ' || last_name)), to_number( SUM(quantity * unit_price) ) INTO nomPL, totalPL FROM orders JOIN …afficher plus de contenu…
JOIN INVENTORIES i ON w.warehouse_id = i.warehouse_id
JOIN PRODUCTS p ON i.product_id = p.product_id
(GROUP BY
W.warehouse_name,
Leaddress 11", ' I] Lecity Il", ' 11 Lepostal_code 11‘, ' II Lestate 11", * 11 c.country_name
ORDER BY SUM(i.quantity * p.standard_cost) DESC
FETCH FIRST 1 ROW ONLY:
|sortie de scipt x P>Résultatde requéte <
PB BW B 501 | Toutesles ines extraites : 1 en 0,043 secondes
‘J WAREHOUSE_NANE |) ADRESSE_ VERSION PROF [fp valeur inventare
15en Francisco 2011 Interiors Blvd, South Sen Francisco, 99236, California, United States of Anerica 10743492,54
{}INDICATEUR |{} NOMBRE
4 1e4
491 53
PHB- BA BR Bear
[Si seuect regexp_substr(c-phone, '\#\d*\s") indicateur, cour (e.phone) NOMBRE
FROM
contacts ©
GROUP BY regexp_substr(c-phone,