Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE numeinexistent( cod_c COMPANIE.cod_companie%TYPE )
- IS
- CURSOR mycursor1 IS SELECT STATIE.COD_STATIE,STATIE.DENUMIRE FROM STATIE JOIN ACHIZITIE ON STATIE.cod_statie = achizitie.cod_statie
- JOIN COMPANIE ON statie.cod_companie = COMPANIE.cod_companie
- WHERE COMPANIE.COD_COMPANIE = cod_c
- AND ( ACHIZITIE.data_achizitie < SYSDATE-10 );
- BEGIN
- FOR r_cursor1 IN mycursor1
- LOOP
- EXIT WHEN mycursor1%NOTFOUND;
- DBMS_OUTPUT.PUT_LINE(r_cursor1.cod_statie || ' ' || r_cursor1.denumire);
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement