SQL转换:

Question

写一个存储过程吧，create or replace proc xxx
                       li_recnt    int
                   select count into li_recnt
                   from view_empcur
                   where empno=al_empno;
                     if li_recnt >0 then
                          return true
                      else                          return false
                      end if 
这样基本就ok了，提交试试吧！