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'