|
Is it possible to use some kind of Oracle NVL
functionality in castor OQL?
i trying to execute the query:
"SELECT section FROM dbo_test.Domain.Section
section WHERE site.id = $1 ORDER BY parentSection.id"
but it returns me less number of records then it
should, becouse some parentSection.id's are null. so, how can i provide a query
like this:
"SELECT section FROM dbo_test.Domain.Section
section WHERE site.id = $1 ORDER BY NVL(parentSection.id, 0)" ?
Thanks. |
