Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

QBE does not work in SQL based VO

Okan SutcuogluMay 16 2019 — edited May 17 2019

Hello I use JDeveloper 12.2.1.3. I have a Query Based VO . In the SQL code i give order by to some columns. But when i try to filter a column by using QBE it gives me error.

When i look to the error message i saw it adds where condition after order by and it couses the SQLSyntaxErrorException. I dont want to remove order by so how can i do that? Thank you.

Comments
Post Details
Added on May 16 2019
2 comments
161 views