I'm learning PL-SQL. I want to know how to extract data from a table(s) and write it to a file.
Do I use DBMS_OUTPUT or UTL_FILE? What is the difference here?
Can anyone give me a simple example to work with (eg, emp table with emp_id and emp_name columns)?
Thanks for your time,