CODEWITHSUNDEEP
oracle-databaseplsqloracle10goracle11g
Tarun
Tarun

Reputation: 537

How to print string using pl/sql without appending the new line character at end

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

But what if I want to print lets say Fibonacci series in same line.

I know the logic of fibonacci...

I just want to know which method would I use to put whole output in same line.

I am using PL/SQL

Upvotes: 10

Views: 18652

Answers (2)

Ludovic Kuty
Ludovic Kuty

Reputation: 4954

The entry point for all the doc of version 11gR2 is All Books for Oracle Database Online Documentation Library 11g Release 2 (11.2).

For other Oracle database versions you might want to start your exploration from Database Documentation. Since version 12.1 the URLs are easier : 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 PL/SQL Packages and Types Reference for that kind of question. In particular the Summary of DBMS_OUTPUT Subprograms. The doc is really handy as a reference when you have questions about the PL/SQL API.

Upvotes: 5

cagcowboy
cagcowboy

Reputation: 30828

Use DBMS_OUTPUT.PUT instead of DBMS_OUTPUT.PUT_LINE

Upvotes: 16

Related Questions