create or REPLACE procedure modelzz( VAR_MODEL IN MODELS.NAME_MODEL%TYPE, VAR_PRICE OUT AUTOMOBILES.A_PRICE%TYPE ) as begin SELECT a.A_PRICE INTO VAR_PRICE FROM AUTOMOBILES a join MODELS m on a.MODELS_ID_MODEL=m.ID_MODEL where m.NAME_MODEL=VAR_MODEl; dbms_output.put_line(VAR_MODEL||'''s price is : '||VAR_PRICE);end;
var v_modelzz varchar2; exec modelzz('&model_name',:v_modelzz);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)