<div>
There are a lot of settings in sqlplus to allow for formatting and supressing header, alignment, SQL prompt and so on, but it isn't worth it to spend too much time on it. It's usually easier to filter e.g. for leading spaces to get the value.
</div>


There are a lot of settings in sqlplus to allow for formatting and supressing header, alignment, SQL prompt and so on, but it isn't worth it to spend too much time on it. It's usually easier to filter e.g. for leading spaces to get the value.

<div>
What makes you think that's not a numerical value? What is the relevant part of your query that produces that result?
</div>


What makes you think that's not a numerical value? What is the relevant part of your query that produces that result?

<div>
<div class="content wysiwyg-content">
Hi all!<br />
<br />
Executing a query on Oracle I get as output the table display.<br />
<br />
The output looks like this:<br />
PERCENT_SPACE_USED<br />
------------------<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; 20.05<br />
<br />
SQL&gt;<br />
<br />
<br />
I would like to obtain as result only the numeric value.<br />
<br />
I know I can fiddle with AWK or SED or other commands but I wanted to ask if there is any way in pure SQL to obtain the same result.<br />
<br />
Thanks!
</div>
</div>


Hi all!

Executing a query on Oracle I get as output the table display.

The output looks like this:
PERCENT_SPACE_USED
------------------
	     20.05

SQL>


I would like to obtain as result only the numeric value.

I know I can fiddle with AWK or SED or other commands but I wanted to ask if there is any way in pure SQL to obtain the same result.

Thanks!

Get a single value from sqlplus Oracle query

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.