达梦数据库应用基础（第二版）课件 2-DMSQL数据类型.pdf

()

-

declaredeclare

v_agev_ageintint:=20:=20;;

v_namev_namevarcharvarchar((5050););

v_sexv_sexbitbit;;

v_pricev_pricenumbernumber((1010,,22););

v_logtimev_logtimedatetimedatetime:=:=sysdatesysdate;;

declare

v_empnoint:=1001;

v_empnamevarchar(20);

v_salaryint;

v_empinfovarchar(50);

begin

selectemployee_name,salary

intov_empname,v_salary

fromdmhr.employee

whereemployee_id=v_empno;

v_empinfo:=v_empname||:||v_salary;

printv_empinfo;

end;

DECLARE

--用%TYPE类型定义与表相配的字段

TYPEt_RecordISRECORD(

T_noemployee.employee_id%TYPE,

T_nameemployee.employee_name%TYPE,

T_salemployee.salary%TYPE);

--声明接收数据的变量

v_empt_Record;

,

DECLARE

v_empnodmhr.employee.employee_id%TYPE:=1001;

recdmhr.employee%ROWTYPE;

BEGIN

SELECT*INTOrec

FROMdmhr.employee

WHEREemployee_id=v_empno;

print(姓名:||rec.employee_name||--工资:||rec.salary||--工作时间:||rec.hire_date);

END;

--普通标量类型变量使用案例--%type类型变量使用案例

declaredeclare

v_empnoint:=1001;v_empnoint:=1001;

v_empnamevarchar(20);v_empnamedmhr.employee.employee_name%type;

v_salaryint;v_salarydmhr.employee.salary%type;

v_empinfovarchar(50);v_empinfovarchar(50);

beginbegin

selectemployee_name,salaryselectemployee_name,salary

intov_empname,v_salaryintov_empname,v_salary

fromdmhr.employee