Use schema in stored procedure : schema « User Previliege « Oracle PL / SQL

1. Oracle PL / SQL
2. User Previliege
3. schema

Use schema in stored procedure

 

create table sprockets (
        id number,
        description varchar2(200),
        quantity    number )
    /
    
create or replace procedure add_sprocket
    as
    begin
    insert into george.sprockets values( 6, 'Aluminum', 10 );
    end;
    /

drop table sprockets;

 

Related examples in the same category