Questions tagged as 'spool'

I'm trying to generate a spool but it marks me wrong syntax when I insert in the variable COL Nombre_emp new_value Nombre_emp; SELECT TO_CHAR(TO_DATE(TRUNC(MAX(ID_MES)),'YYYYMM'),'YYYYMM')||'.txt' Nombre_emp FROM estudiante WHERE ID_MES >...

I use the spool to capture the result of a simple query and pass it to a TXT that I place on my local machine in C: \ TXT. But I need to deposit that file in a remote directory using ssh. How could it be done? I was researching to see if from...