CREATE OR REPLACE PROCEDURE EMP_CSV AS CURSOR c_data IS SELECT empno, ename, job, mgr, TO_CHAR(hiredate,'DD-MON-YYYY') AS hiredate, sal, comm, deptno FROM emp ORDER BY ename; v_file UTL_FILE.FILE_TYPE; BEGIN v_file := UTL_FILE.FOPEN(location => 'EXTRACT_DIR', filename => 'emp_csv.txt', open_mode => 'w', max_linesize => 32767); FOR cur_rec IN c_data LOOP UTL_FILE.PUT_LINE(v_file, cur_rec.empno || ',' || cur_rec.ename || ',' || cur_rec.job || ',' || cur_rec.mgr || ',' || cur_rec.hiredate || ',' || cur_rec.empno || ',' || cur_rec....
BsWifit ad HOC SELECT '1' as orderby, 'BB' AS GROUP_NUMBER, PER.PERSON_NUMBER AS EMPLOYEE_ID, PER.PERSON_NUMBER AS USER_ID, 'E' AS RELATION, NAME.FIRST_NAME AS FIRST_NAME, UPPER(SUBSTR(NAME.MIDDLE_NAMES,1,1)) AS MIDDLE_INITIAL, NAME.LAST_NAME AS LAST_NAME, '' AS LAST_NAME_EFFECTIVE_DATE, '' AS NICKNAME, '' AS SOCIAL_SECURITY_NUMBER, '' AS DATE_OF_BIRTH, '' AS GENDER, '' AS Race_Ethnicity, --BEN.DISABILITY_STATUS AS DISABLED, --BEN.TOBACCO_TYPE_USAGE AS TOBACCO_USER, '' AS BENEFIT_CLASS_CODE, '' AS BENEFIT_CLASS_DATE, '' AS COMPENSATION_DATE, null AS SALARY, null AS HOURLY_RATE, null AS HOURS_PER_WEEK, null AS BENEFITS_BASE_SALARY, '' AS BONUS, '' AS COMMISSION, '' AS HIRE_DATE, '' AS REHIRE_DATE, '' AS Demographic_Field_1, '' AS DEPT_CODE, '' AS DEPARTMENT_EFF_DATE, '' AS LOCATION_CODE, '...