How to add new line character in DBMS_OUTPUT.put_line in LINUX

Question

In UNIX, in a SQL script, i have following code:

LOOP    
  DBMS_OUTPUT.put_line (p_key||'|'||p_loc||'\n');    
END LOOP

Output is:

5482004|Dir/3-30-2017/file:47923.xml

5482009|Dir/3-30-2017/file:49288.xml

However in Linux, since "\n" doesn't work, i am replacing the above code with following code:

LOOP    
  DBMS_OUTPUT.put_line (p_key||'|'||p_loc);    
  DBMS_OUTPUT.new_line;    
END LOOP

Output is:

20 5482004|Dir/3-30-2017/file:447923.xml 5482009|Dir/3-30-2017/file:449288.xml 5482010|Dir/3-30-2017/file:449739.xml 5482012|Dir/3-30-2017/file:45015.xml

The output in this format is without the new line after each line. Please suggest what is in correct in the loop.

P.S. I have also tried DBMS_OUTPUT.put_line (p_key||'|'||p_loc||chr(10)) but the output is still without the new line.

Possible duplicate of How to enter newline character in Oracle? — J. Chomel
– J. Chomel, Commented Apr 3, 2017 at 11:44

Community · Accepted Answer · 2017-05-23 12:09:42Z

1

Please refer below SO answer for this question.

New Line Character in dbms_output

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Apr 3, 2017 at 11:24

Avrajit Roy

3,3131 gold badge16 silver badges25 bronze badges

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

3 Comments

gopajit malakar Over a year ago

I did use DBMS_OUTPUT.put_line (p_key||'|'||p_loc||chr(10)); but the output is still 5482004|Dir/3-30-2017/file:447923.xml 5482009|Dir/3-30-2017/file:449288.xml 5482010|Dir/3-30-2017/file:449739.xml 5482012|Dir/3-30-2017/file:45015.xml format and not in new line one

Avrajit Roy Over a year ago

LOOP DBMS_OUTPUT.put_line (p_key||'|'||p_loc); DBMS_OUTPUT.put_line(chr(10)); END LOOP

gopajit malakar Over a year ago

i tried the same, but didn't make any difference to the output format

Harsh Kumar · Accepted Answer · 2021-02-02 06:18:06Z

You can use chr(10) My code in which i was trying to swap numbers ,where i need new line so i used chr(10)

DECLARE 
    A NUMBER;
    B NUMBER;
    TEMP NUMBER;
BEGIN
    A:=&A;
    B:=&B;
    DBMS_OUTPUT.PUT_LINE(chr(10)||'BEFORE SWAP A is : '||A||' AND B is : '||B);
    TEMP:=B;
    B:=A;
    A:=TEMP;
    DBMS_OUTPUT.PUT_LINE(' AFTER  SWAP A is : '||A||' AND B is : '||B);
END;
/

Output:

Enter value for a: 1
old   6:   A:=&A;
new   6:   A:=1;
Enter value for b: 2
old   7:   B:=&B;
new   7:   B:=2;
                                 -- here i got new line
BEFORE SWAP A is : 1 AND B is : 2
AFTER  SWAP A is : 2 AND B is : 1

PL/SQL procedure successfully completed.

So before line(i.e BEFORE SWAP A is : 1 AND B is : 2) in output i got new line.

Collectives™ on Stack Overflow

How to add new line character in DBMS_OUTPUT.put_line in LINUX

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related