Remove last character from string in sql plus

sql oracle sqlplus
Ali Anwar picture Ali Anwar · Oct 20, 2014 · Viewed 65.4k times · Source

I'm trying to remove the last character from a column output in sql plus. The length of the column entries is not fixed

For e.g XYZA should output as XYZ

I've tried using the substr() function but it doesn't seem to work.

SUBSTR(ooo.CO_NAME,1,LENGTH(ooo.CO_NAME-1))

Answer

Troy Gizzi picture Troy Gizzi · Oct 20, 2014

A closing parenthesis is in the wrong place. It should be:

SUBSTR(ooo.CO_NAME, 1, LENGTH(ooo.CO_NAME) - 1)

Related questions

How do I spool to a CSV formatted file using SQLPLUS?

I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or any language to do it. I must use SQLPLUS. How do I do it?

Read More
Escaping ampersand character in SQL string

I am trying to query a certain row by name in my sql database and it has an ampersand. I tried to set an escape character and then escape the ampersand, but for some reason this isn't working and I'm …

Read More
how to increase sqlplus column output length?

I have some queries to find out the ddl of some objects from a schema. The result columns I am getting are truncated in the middle of the queries. How can I increase the width of the column? I tried …

Read More