Hi,
I want to capture output of sql command.
i know how to spool but problem is spooled file contains the sql command too.
I just want to capture the result of the command just like in linux redirecting process
for example... i want to capture the result of
select 'drop '||object_type||' '|| object_name||' purge;' from user_objects;
and than redirect it to a file so it will only contain the result of the sql query.