Oracle中的sql%rowcount在瀚高資料庫中的相容方案

create table t1(id numeric,sname varchar(10),primary key(id));

create or replace function testfnc return number

as

  n number;

begin

  insert into t1 values(1,'zhao');

  n:=sql%rowcount;

  commit;

  dbms_output.put_line(n);

  return 0;

end;

create table t1(id numeric,sname varchar(10),primary key(id));

create or replace function testfnc() returns numeric

language plpgsql

as

$body$

declare

  n numeric;

begin

  insert into t1 values(1,'zhao');

  --n:=sql%rowcount;

  get diagnostics n := row_count;

  raise notice '%',n;

  return 0;

end;

$body$