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

arbab · March 14th, 2011, 07:47 AM

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(ACC_ID) || ' -- '|| length (acc_id) from tbla;
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(ACC_ID) length (acc_id) from tbla;
Gives ERROR:'FROM keyword not found where expected'

Thanks in Advance.

joefawcett · March 14th, 2011, 08:13 AM

I'd have thought a comma:

Code:

arbab · March 15th, 2011, 03:34 AM

Thank you, I was trying 'Comma' with a wrong column name, that's why I was having error.

Thanks for your guidance.