Hello!
How I can create a SPOOL file (e.g test.txt) in pl/sql on server. I know in SQL*PLUS, but I have no idea in pl/sql.

Can some one write a simple pl/sql example in which using sql query and then generate spool file.

Thanks in advance.