emp表是雇员信息表,以下哪个变量可以存放emp表中的一条记录()
A、v_record emp%type;
B、v_record emp%recordtype;
C、v_record emp%record_type;
D、v_record emp%rowtype;
E、v_record emp%row_type;
A、v_record emp%type;
B、v_record emp%recordtype;
C、v_record emp%record_type;
D、v_record emp%rowtype;
E、v_record emp%row_type;
A、v_sal emp%rowtype; B、v_sal emp.sal%type; C、v_sal emp.sal.%type; D、v_sal %type(emp.sal); E、v_sal (emp.sal)%type;
A、Select * From Emp B、Select * From Emp Where EmpNO Like '%%' C、Select * From Emp Where Name = '%%' D、Select * From Emp Where Name Like '%%'
A、Select *From Emp Where Job>="办事员" B、Select* From Emp Where Job==’办事员’ C、Select* From Emp Where Job<>’办事员’ D、Select* From Emp Where Job!=’办事员’
A、A.Select * From Emp Where EmpNO In('791','792','793') B、B.Select * From Emp Where EmpNO ='791' Or EmpNO='792' OR EmpNO='793' C、C.Select * From Emp Where EmpNO >='791' And EmpNO<='793' D、D.Select * From Emp Where EmpNO >'791' And EmpNO<'793'
A、在引用列变量的单变量模拟运算表中,计算公式一定位于变量列的右上角单元 B、在引用行变量的单变量模拟运算表中,计算公式一定位于变量列的左下角单元 C、在双边量模拟运算表中,计算公式一定位于模拟运算表左上角行变量和列变量交叉单元格 D、模拟运算表是整体运算出来的,不能删除其中某个格的值,必须整体删除
A、Select * From Emp Where EmpNO Not In('791','792','793') B、Select * From Emp Where EmpNO !='791' AND EmpNO!='792' And EmpNO='793' C、Select * From Emp Where EmpNO <>'791' AND EmpNO<>792' And EmpNO=<>793' D、Select * From Emp Where EmpNO =!'791' AND EmpNO =!'792' And EmpNO =!'793'
A、elect * From Emp Where HirDate>='1981-1-1' And HirDate <='1981-12-31' B、Select * From Emp Where Between In '1981-1-1' And <'1981-12-31' C、Select * From Emp Where Between In '1981-12-31' And <'1981-1-1' D、Select * From Emp Where HirDate>='1981-1-1' NOT HirDate <='1981-12-31'
A、A.type array arr_type[emp.ename%type] index by binary_integer; B、B.type table arr_type[emp.ename%type] index by binary_integer; C、C.type arr_type is table of emp.ename%type index by binary_integer; D、D.type arr_type is pl_sql table of emp.ename%type index by binary_integer;