当对Report进行排序时,有时候报出错误ORA-00933,原因是Report的SQL Query (PL/SQL function body returning SQL query)中含有Order By语句。网上说这个APEX bug在4.0.2中已经fix啦,但是,我们在4.1.0中仍然会遇到。原因不清楚。一种折中解决方法是删掉SQL
Query中的Order By语句,只是用column sort。
ORA-00933: SQL command not properly ended
SQL> desc apex_release;
Name Null? Type
----------------------------------------- -------- ----------------------------
VERSION_NO VARCHAR2(4000)
API_COMPATIBILITY VARCHAR2(4000)
PATCH_APPLIED VARCHAR2(4000)
SQL> select version_no from apex_release;
VERSION_NO
--------------------------------------------------------------------------------
4.1.0.00.32
参考:
【1】https://forums.oracle.com/forums/thread.jspa?threadID=2124510
【2】https://forums.oracle.com/forums/thread.jspa?threadID=2387116
分享到:
相关推荐
[Packt Publishing] Oracle APEX 4.2 报表开发 (英文版) [Packt Publishing] Oracle APEX 4.2 Reporting (E-Book) ☆ 图书概要:☆ Learn how to build complex reporting solutions using Oracle APEX Overview...
包括内容有:oracle apex20.1,jdk-13.0.2_windows-x64_bin,apache-tomcat-9.0.34.exe,ords-19.4.0.352.1226,基本上都是最新版本,省去到处下载的麻烦。 Oracle Application Express (APEX) 是低代码开发平台。借助该...
Oracle APEX 18.2 新版本终于发布了,这个版本增加了许多新的功能
OracleAPEX学习心得.doc
Oracle APEX 4.0 Cookbook .pdf 下载
Oracle Application Express APEX is a powerful productive tool that helps you create modern web applications The goal is to make everything declarative so the developer can reduce the amount of coding ...
Latest version of Oracle APEX5.0 Application builder
Oracle APEX——数据应用开发的利器.pdf
Oracle_APEX
This 2nd edition of Understanding Oracle APEX 5 Application Development shows APEX developers how to build practical, non-trivial web applications. The book introduces the world of APEX properties, ...
全面,深入,有图有例,从oracle安装Apex到精通
Oracle APEX Best Practices
ORACLE根据某一列的值修改另一列的值
Oracle APEX 4.0 Cookbook
oracle_apex_4.0_cookbook
里面有apex安装包,和我写的教程=================================================================================================
详细介绍Oracle APEX 20版应用程序开发。Oracle APEX是一个快速的低代码开发平台,只要掌握SQL只是就可以快速开发业务应用。
Oracle Application Express: Build Powerful Data-Centric Web Apps with APEX (Oracle Press) by Arie Geller English | 5 May 2017 | ASIN: B07259XHLF | 497 Pages | AZW3 | 36.45 MB This Oracle Press guide ...
Linux下Oracle Apex Ords安装包资源
前几时帮朋友安装了一个APEX 3.2环境,参照网上的文档和官方文档进行安装,顺利完成。