文章列表
1.ASCII
返回与指定的字符对应的十进制数;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
给出整数,返回对应的字符;
SQL> select chr(54740) zhao,chr(65) ...
CREATE OR REPLACE PACKAGE BODY test AS
PROCEDURE proc_01 IS
--自定义记录
TYPE emp_record_type IS RECORD(
NAME emp.ename%TYPE,
sal emp.sal%TYPE,
dno emp.empno%TYPE);
emp_record emp_record_type;
--表记录
dept_record dept%ROWTYPE;
--索引表,嵌套表
TYPE ename ...