Question

plsql不弹出查询结果窗口

如图, 按F8执行语句, 显示编译成功,但是不弹出查询结果窗口, 请大神看看~~~语句如下(语句应该没有问题)SELECT F1.USER_NAME , substrb(f1.description,1,instrb(f1.description,'-')-1) dept, f2.description dept_hr, f1.description username , to_char(f1.last_logon_date,'yyyy/mm/dd') last_logon_date, to_char(f1.start_date,'yyyy/mm/dd') rest_start_date, f3.responsibility_name,''"deletion_confirm(Y/N)" from apps.fnd_user f1, apps.fnd_user_resp_groups f2, apps.fnd_responsibility_vl f3 where f1.user_id=f2.user_id and f2.responsibility_id=f3.responsibility_id(+) and f1.creation_date>to_date('20040101','yyyy/mm/dd') and f2.end_date is null and f1.end_date is null and f3.end_date is null --and f1.user_name like '0%' -- and f3.responsibility_name like 'PRé_?????T' ---and substrb(f1.description,1,instrb(f1.description,'-')-1) in('SZCS') and user_name in ('070557') order by dept,f1.user_name,f3.responsibility_name

Answer 1

你得选中要执行语句后按

eg:

第一步：

第二步：

Answer 2

你是不是把搜索到的窗口给拉下去了 SQL窗口上半部分是语句，下半部分是数据，你这，，是不是把数据窗口给拉下去了。。