How to add strings in Oracle and create the text file with that string name

Question

Below is my requirement:

I want to generate a text file named as DBService_DateTimeStamp_UpgradeScipts.txt where
DBService=> is the oracle service name against which the script is executed(dit/fit etc.)
DateTimeStamp=>Current date time stamp upto seconds and
UpgradeScipts->static text

Below is my script part:

SET SERVEROUTPUT ON
DECLARE fileName VARCHAR2(100); 
  --Declare tStamp VARCHAR2(100);
BEGIN
  DECLARE fileName VARCHAR2(100); 
  Declare tStamp VARCHAR2(100);
  select sys_context('userenv','service_name') into fileName from dual;
  --SELECT SYSTIMESTAMP into tStamp FROM DUAL;
  --fileName:= fileName || '_' || tStamp; 
  --Dbms_Output.Put_Line('' || TIMESTAMP(3));
  --spool UpgradeClients.txt --here the desired file name should be like
  --  svc1_03-APR-17-12.51.12 AM.txt
END;
/

I think I am close to it, any help will be highly appretiated.

MT0 · Accepted Answer · 2017-04-04 01:25:55Z

3

SET SERVEROUTPUT ON

DECLARE
  fileName VARCHAR2(100) := SYS_CONTEXT('userenv','service_name')
                            || '_' || TO_CHAR( SYSDATE, 'DD-MON-YY-HH24.MI.SS' )
                            || '_UpgradeScripts.txt';
BEGIN
  DBMS_OUTPUT.PUT_LINE( fileName );
END;
/

answered Apr 4, 2017 at 1:25

MT0

173k12 gold badges70 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add strings in Oracle and create the text file with that string name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related