ITPub博客

PL/SQL实现 declare type t_matrix is table of number index by binary_integer; v_helix t_matrix; i number; j number; direction pls_integer; -- right:0, up:1, left:2, down:3 M number; N number; -- 模拟2维数组 begin function new_matrix (rows integer, cols integer) return t_matrix is v_result t_matrix; begin v_result(0):=cols; for i in 1 .. rows*cols loop v_result(i) := null; end loop; return v_result; end; procedure set_val(p_matr

oracle分析函数--SQL*PLUS环境--1、GROUP BY子句 --CREATE TEST TABLE AND INSERT TEST DATA.create table students(id number(15,0),area varchar2(10),stu_type varchar2(2),score number(20,2));insert into students values(1, '111', 'g', 80 );insert into students values(1, '111', 'j', 80 );insert into students values(1, '222', 'g', 89 );insert into students values(1, '222', 'g', 68 );insert into students values(2, '111', 'g', 80 );insert into students values(2, '111', 'j', 70 );insert into students values(

1)set directory utl_file_dir in init.ora2)restartup来显示ult_fileSQL> show parameter utl_fileNAME TYPE VALUE------------------------------------ ----------- ----------------------------utl_file_dir string D:oracleadminfun1cdumpSQL> update scott.emp set comm=999 where empno='7566';已更新 1 個資料列.SQL> update scott.dept set dname='LJG.ERIC' where dname='DDA';已更新 1 個資料列.SQL> commit;確認完成.SQL> select * from v$log;GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHAN