基本数据类型和特殊数据类型
基本数据类型:NUMBER;VARCHAR2;CHAR;LONG;NVARCHAR2;NCHAR;DATE;BOOLEAN
特殊数据类型:%TYPE类型;RECORD类型;%ROWTYPE类型
注意:没有nvarchar类型
几个简单的例子
1、%TYPE类型
set serveroutput on
declare var_firstname EMPLOYEES.first_name%type;
var_job EMPLOYEES.job_id%type;
begin
select first_name,job_id into var_firstname,var_job from EMPLOYEES where employee_id=100;
SYS.dbms_output.put_line(var_firstname||'的工作是'||var_job);
end;
2、RECORD类型
set serveroutput on
declare
type emp_type is record
(
var_a1 EMPLOYEES.first_name%type,
var_a2 EMPLOYEES.job_id%type,
var_a3 EMPLOYEES.salary%type
);
empinfo emp_type;
begin
select first_name,job_id,salary into empinfo from EMPLOYEES where employee_id=100;
dbms_output.put_line(empinfo.var_a1||'的工作是'||empinfo.var_a2||',并且工资是'||empinfo.var_a3);
end;
3、%ROWTYPE类型
set serveroutput on
declare
var_row EMPLOYEES%rowtype;
begin
select * into var_row from EMPLOYEES where employee_id=100;
dbms_output.put_line(var_row.first_name||'的工作是'||var_row.job_id||',并且工资是'||var_row.salary);
end;
博文仅供参考,欢迎大家来访。如有错误之处,希望批评指正。