You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
How to separate two functions in a query? Except this || ' -- '||.
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'