Hi all,
I have the following PLSQL block where I need to print the tags as per the expected output, where I need to generate the HTML tags through a query as an output.
DECLARE
CURSOR c_emp IS
SELECT EMPLOYEE_ID, FIRST_NAME, EMAIL
FROM hr.EMPLOYEES;
BEGIN
FOR a IN c_emp LOOP
htp.p('<b>Employee '||a.EMPLOYEE_ID||' ('||a.FIRST_NAME||') has been ticked.</b><br/>');
END LOOP;
END;
Can anyone let me know how the output be generated? Where can I view the output? Can I get the output through a query?
Thanks!