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;
更多“emp表是雇员信息表，sal字段存放是的雇员的月薪，以下哪个变量可以存放sal类型的值（）”相关的问题
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、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 sal,decode(sal>3000,'A',sal>2000,'B','C') grade from emp; B、select sal,decode(sal,3000,'A',2000,'B','C') grade from emp; C、select sal,(case when sal>3000 then 'A' when sal>2000 then 'B' else 'C' end) grade from emp; D、select sal,(if sal>3000 then 'A' elsif sal>2000 then 'B' else 'C' end if) grade from emp;
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、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.GRANT CHANGE ON SCOTT.EMP TO SA B、B.GRANT UPDATE ON SCOTT.EMP（SAL） TO SA C、C.GRANT UPDATE （SAL） ON SCOTT.EMP TO SA D、D.GRANT MODIFY ON SCOTT.EMP（SAL） TO SA
A、select * from emp wher sal in (2000,3000); B、select * from emp wher sal like (2000,3000); C、select * from emp wher sal = (2000,3000); D、select * from emp wher sal between 2000 and 3000;
客服
TOP
查看正确答案
