mar
10
2016

PL/SQL -String para nome de arquivo TXT

select
‘Empresa_’|| ‘VAR’||’_’|| to_char(sysdate, ‘yyyy’)||to_char(sysdate, ‘mm’)||to_char(sysdate, ‘dd’)
||to_char(sysdate, ‘HH24’)||to_char(sysdate, ‘MI’)||to_char(sysdate, ‘SS’)
||’.txt’
from dual

About the Author:

Leave a comment

. .