Oracle常用命令

1、查询oracle版本：select * from v$version

2、查询oracle当前SCN：select current_scn from v$database

3、oracle存储过程：

declare
  m integer;
begin
  dbms_output.put_line('start:'||sysdate);
  m:=0;
  for i in 1..10 loop
  m:=m+1;
    UPDATE "ORACLEDBA"."FIVETEST" SET "ALLNUMBER20" = '998' WHERE ALLNUMBER=i;
--   INSERT INTO "FIVETEST"("ALLNUMBER3", "ALLNUMBER5", "ALLINTEGER", "ALLNUMBER20", "ALLNUMBER", "ALLNUMBERPS", "ALLBINARY_DOUBLE", "ALLCHAR", "ALLVARCHAR", "ALLVARCHAR2", "ALLNVARCHAR2", "ALLTIMESTAMP", "ALLTIMESTAMPTZ", "ALLDATE") VALUES ('123', '456', '456789123456789', '23456789012', i, '66666', '12.119999999999999', 'allchar', 'allvarchar', 'allvarchar2', 'allnvarchar2', TO_TIMESTAMP('2022-09-24 16:00:13.000000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), TO_TIMESTAMP_TZ('2022-09-24 16:00:16.586000 +08:00', 'SYYYY-MM-DD HH24:MI:SS:FF6 TZR'), TO_DATE('2022-09-24 16:00:20', 'SYYYY-MM-DD HH24:MI:SS'));
-- commit;
-- DBMS_LOCK.Sleep(1);
end loop;
commit;
dbms_output.put_line('end:'||sysdate);
end;