How to print a line using pl / sql without adding a new line character at the end

Question

If I use the DBMS_OUTPUT.PUT_LINE() method, it always adds a new line character at the end.

But what if I want to print, we can say that the Fibonacci series is on the same line.

I know the fibonacci logic ...

I just want to know which method I would use to print all the output on one line.

I am using PL / SQL

Answer 1

Use DBMS_OUTPUT.PUT instead of DBMS_OUTPUT.PUT_LINE

Answer 2

The entry point for the entire 11gR2 document is All Books for Oracle Database Online Documentation Library 11g Release 2 (11.2) .

For other versions of the Oracle database, you can start your research with the database documentation . Starting with version 12.1, URLs are simpler: http://docs.oracle.com/database/121/nav/portal_booklist.htm for 12.1 and http://docs.oracle.com/database/122/nav/portal_booklist.htm for 12.2.

You might want to check out the PL / SQL Package and Type Reference for these kinds of questions. In particular, DBMS_OUTPUT routine summary . The document is really useful as a reference when you have questions about the PL / SQL API.