How to Make SQLPLUS Script in UNIX Shell Produce Output on Same Line (Doc ID 778846.1)

Last updated on MARCH 03, 2025

Applies to:

Goal

A Simple Select statement is executed from within a shell environment.
The value returned by the select query is transferred back to the shell.
However the result produced will have an empty line in it.
For example:

will produce the result as:

RESULT=
X 

Result expected is:

RESULT=X

This is expected behavior and hence the value will be returned on a new line.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.