Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

convert function/procedures to SQL

RobeenAug 9 2021

Oracle DB 12.1.0.2
Hello Team,
how can I convert the functions below to SQL?

...HR_SECURITY.SHOW_PERSON (pap.person_id, pap.current_applicant_flag ,pap.current_employee_Flag, pap.current_npw_flag ,pap.employee_number, pap.applicant_number, pap.npw_number)) = 'TRUE' 
HR_SECURITY.SHOW_PERSON:
  FUNCTION show_person
   (p_person_id       IN NUMBER
   ,p_current_applicant_flag IN VARCHAR2
   ,p_current_employee_flag IN VARCHAR2
   ,p_current_npw_flag    IN VARCHAR2
   ,p_employee_number    IN VARCHAR2
   ,p_applicant_number    IN VARCHAR2
   ,p_npw_number       IN VARCHAR2)
  Return VARCHAR2;

SQL:
...decode(hr_general.get_xbg_profile,'Y',pap.business_group_id , hr_general.get_business_group_id)
hr_general.get_xbg_profile:

function get_xbg_profile return varchar2;

hr_general.get_business_group_id

function GET_BUSINESS_GROUP_ID return number;

Thanks,
Roshan

Comments
Post Details
Added on Aug 9 2021
7 comments
335 views