Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table t1 (id number primary key, memo varchar2 (4000));
- create sequence seqt1 nocache;
- declare
- r t1%rowtype;
- begin
- r.id := seqt1.nextval;
- r.memo := 'first row';
- insert into t1 values r;
- end;
- /
- ID MEMO
- ---------- ----------
- 1 first row
- drop table t1;
- create table t1 (id number generated always as identity primary key, memo varchar2 (4000));
- create table t1 (id number generated always as identity primary key, memo varchar2 (4000))
- ;
- create or replace view viewt1 (id invisible, memo) as select * from t1
- ;
- <<my>> declare
- r viewt1%rowtype;
- id number;
- begin
- r.memo := 'first row';
- insert into viewt1 values r
- returning id into my.id
- ;
- dbms_output.put_line ('inserted '||sql%rowcount||' row(s) id='||id);
- end;
- /
Add Comment
Please, Sign In to add comment