Hello,

I am just starting with Oracle and I have a problem. See, I want to
create a Stored Procedure that will do the following:

1. Select * from an EmployeeTable
2. Then I will write the selected values in a file

I will only use SP and not using a Java program. Can someone show me a
code?

Thanks.

We don't do your work.
Please look up the UTL_FILE package in your PL/SQL documentation

--
Sybrand Bakker
Senior Oracle DBA