SPOOL « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. SPOOL
1.SPOOL query result to a file
2.spool to a file with text string concatenation
3.Spooling files on and off
4.spool to report.txt replace
5.Extracts data from the emp table and writes it to a text file in a comma-delimited format