oracle – SQL小提琴输出错误

我在SQL Fiddle中使用oracle pl / sql创建了下表

create table Employee(name varchar2(100),id integer,salary integer,PRIMARY KEY(id));
insert into Employee(name,id,salary) values('sa',94,100);
insert into Employee(name,salary) values('pr',88,150);
insert into Employee(name,salary) values('ji',33,900);
insert into Employee(name,salary) values('na',24,880);
insert into Employee(name,salary) values('po',65,770);
insert into Employee(name,salary) values('ri',69,910);
insert into Employee(name,salary) values('uj',12,650);
insert into Employee(name,salary) values('ad',43,440);
insert into Employee(name,salary) values('sam',40,550);

我执行了以下查询

DECLARE
 employee_record Employee%ROWTYPE;
 BEGIN
 select * into employee_record from Employee where id>90;
 dbms_output.put_line(employee_record.name||' '||employee_record.id||' '||employee_record.salary);
 END;
 /

我得到以下输出

Record Count: 0; Execution Time: 2ms

它应该打印员工记录中的值,对吧？我的SQL查询中有什么问题或sql小提琴无法显示dbms_output的一些问题？

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!