�ݺ�ߣ

Document2

•Download as TXT, PDF•

0 likes•129 views

Shiv Dutt Bhardwaj

This SQL query selects employee data including a formatted social security number, employee ID number, and name fields from the per_all_people_f and per_jobs_definitions tables where the effective start and end dates for the employees include the current date.

SELECT TO_CHAR(REPLACE(papf.national_identifier,'-'),'999999999') SSN,
papf.employee_number Emplid,
papf.first_name "First Name",
papf.middle_names "Middle Name",
papf.last_name "Last Name",
FROM per_all_people_f papf,
per_jobs_definitions pjd
WHERE TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND
papf.effective_end_date

More Related Content

Document2

1. SELECT TO_CHAR(REPLACE(papf.national_identifier,'-'),'999999999') SSN, papf.employee_number Emplid, papf.first_name "First Name", papf.middle_names "Middle Name", papf.last_name "Last Name", FROM per_all_people_f papf, per_jobs_definitions pjd WHERE TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date