Forum Stats

  • 3,851,373 Users
  • 2,263,968 Discussions
  • 7,904,689 Comments

Discussions

How to avoid the blank file generation in spool function

Hi,

I am using the spool function to create the text files which are extracting data from the select statement. Sometimes the select no returning the value, the spool function is creating the blank file. Please advise how to avoid this blank file generation