How to separate two functions in a query? Except this || ' -- '||.

Syed Arbab Ahmed

How to separate two functions in a Oracle query?

What else can be used other than || ' -- '|| to use more than one function in a query?

For e.g.: SELECT RTRIM(ACCOUNT_ID) || ' -- '|| length (account_id) from tblaccount;

as RTRIM and LENGTH are functions so there has to be something in between like || ' -- '||

for this query in order to run.

As below query which has nothing between RTRIM and LENGTH

SELECT RTRIM(ACCOUNT_ID) length (account_id) from tblaccount;

Gives ERROR: 'FROM keyword not found where expected'

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
I believe you can also use the CONCAT() function in Oracle to concatenate strings.

See if the following will work:

SELECT CONCAT(RTRIM(account_id), CONCAT('--', TO_CHAR(LENGTH(account_id))) from tblaccount
Syed Arbab Ahmed15y ago
Thank you 'Comma' did work, I was trying 'Comma' with a wrong column name, that's why I was having error.

Thanks for your guidance.