-------------------------------------------------------------------------------
-- shopstraight.sql
-------------------------------------------------------------------------------

drop table product cascade constraint;
create table product (
    nom varchar2(20),
    prix int,
    qte int
);
insert into produit values ('cours Java', 10, 7);
insert into produit values ('cours BD', 50, 3);
insert into produit values ('cours baby-sitting', 70, 50);
insert into produit values ('cours tango argentin', 100, 3);
insert into produit values ('cours sieste', 200, 1);
select * from produit;

create or replace procedure p(
    x int,
    y out int)
is 
begin
    y:=x+1;
end;
/
create or replace function f(
    x int)
    return integer
is
begin
    return x+1;
end;
/
create or replace procedure q(
    x varchar2,
    y out varchar2)
is    
begin
    y:=x||' : OK ';
end;
/

--------------------------------------------------------------------------------
