apex
文章平均质量分 63
普通网友
这个作者很懒,什么都没留下…
展开
-
APEX不能访问
有时候APEX运行一段时间后,不能访问啦。此时,可以重启一下DB和DB listener:重启DB:SQL> shutdown immediate;SQL> startup重启DB listenercd $ORACLE_HOMEcd binview the current listener status [weiywang@slc00bjg bin]$原创 2012-02-01 11:49:44 · 1628 阅读 · 0 评论 -
Oracle APEX创建参数化可以搜索的表单
In an Oracle Application Express application, a report is the formatted result of a SQL query. You can generate reports in three ways:Running a built-in wizardDefining a report region based转载 2012-07-31 16:47:26 · 4963 阅读 · 0 评论 -
APEX: Assign Multiple Schemas To A Single Workspace
1. Create a schema:create user test identified by Welcome1default tablespace userstemporary tablespace tempquota 1024m on users;2. Assign it to existed workspaceSQL> conn system/Welcome1;SQL原创 2012-08-29 16:19:24 · 688 阅读 · 0 评论 -
APEX中使用AJAX及其调试方法
1.APEX中AJAX的原理此处的AJAX,其原理与其他语言中使用的一样,We can define it for each region in the Region Source area, or in the HTML Header area of a page’s attributes.如下所示[参考资料:1]:var ajaxRequest = new htmldb_Get(n原创 2012-02-21 15:19:13 · 2383 阅读 · 0 评论 -
Oracle APEX 一些参看文献
1. html_PopUp的用途及使用http://oracle-apex-book.blogspot.jp/2012/06/using-javascript-in-oracle-application.html2.如何使用htmldb_Gethttp://www.dba-oracle.com/t_apex_ajax_html_db.htm原创 2012-08-12 18:00:13 · 1144 阅读 · 0 评论 -
在APEX中调用Java方法
在APEX中调用Java方法1.为什么我们需要在APEX中调用Java.一方面,PL/SQL是一门可以做复杂业务逻辑处理的语言。另一方面,我们很多人已经习惯并且喜欢Java编程,并且也已经有很多现成的代码和第三方的API供使用,例如图形处理中将GIF转化为JPEG,将用户从PDF输入的数据清洗转换到XML中。2.如何使用使用步骤如下:(1)编写Java classes翻译 2012-08-24 13:54:35 · 2227 阅读 · 0 评论 -
APEX HTMLDB_APPLICATION与checkbox
The APEX HTMLDB_APPLICATIONThe HTMLDB_APPLICATION package exposes several global variables used internally by the APEX engine.g_user: This is the ID of the currently logged in user.g_fl转载 2012-09-19 18:00:57 · 805 阅读 · 0 评论 -
APEX checkbox
参考1:How to Work with Check Boxeshttp://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25310/check_box.htm参考2:Oracle Application Express APIshttp://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25原创 2012-09-19 18:06:02 · 1060 阅读 · 0 评论 -
APEX_APPLICATION
The APEX_APPLICATION package is a PL/SQL package that implements the Oracle Application Express rendering engine. You can use this package to take advantage of a number of global variables. Table 1-转载 2012-10-30 15:46:02 · 1701 阅读 · 0 评论 -
APEX session保持登陆状态
During session setup, at the beginning of Apex' request processing, it approximately runs this code:1. Write session id from the request (URL or POST parameter) into a global variable2. Load app转载 2012-11-20 14:06:51 · 1571 阅读 · 0 评论 -
apex 自动导出application
可以采用以下命令行自动导出或者备份apex应用程序:java -classpath ojdbc14.jar:$ORACLE_HOME/apex/utilities oracle.apex.APEXExport -db localhost:1521:orcl -user scott -password 123456 -applicationid 100Note:1. APEXExport原创 2013-01-05 15:10:39 · 1343 阅读 · 0 评论 -
将APEX安装在Oracle RAC上
APEX could be installed on Oracle RAC. Some of the advantages are as follows:1. To ensure maximum uptime. For a 2 nodes RAC env, individual nodes can be shutdown for maintenance while APEX applicati原创 2013-07-22 15:27:15 · 1287 阅读 · 0 评论 -
如何卸载APEX
To remove Oracle Application Express from the database:Change your working directory to the apex directory where you unzipped the Oracle Application Express software.Start SQL*Plus and conne转载 2013-07-25 14:59:30 · 9430 阅读 · 1 评论 -
APEX 捕捉页面或者应用程序异常并进行处理
The Early Adopter release of Oracle APEX 4.1 contains five new enhancements in the Error Handling area. In the next few blog postings I will highlight those. This first article features “Error Handlin转载 2013-09-06 15:01:26 · 4932 阅读 · 0 评论 -
APEX 调用外部的RESTful Service
You always read that it is so easy to consume RESTful or SOAP web services in Apex. Well, yes, when you know how it works. It took me some time to figure it out, googling for bits of information on ev转载 2013-10-14 15:38:02 · 2851 阅读 · 0 评论 -
提升Oracle APEX应用程序的性能
提升Oracle APEX的性能1. 将Embedded PL/SQL Gateway替换为Oracle HTTP Server(Apache),与Oracle数据库分开,在单独一个机器上运行参考http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#BHAGICFJEPG的缺点:(1)EP原创 2013-11-15 15:27:36 · 1697 阅读 · 0 评论 -
APEX 发送邮件
APEX在Oracle数据库UTL_SMTP包基础上提供了自己的发送邮件的API APEX_MAIL.使用方法如下:APEX_MAIL.SEND( p_to IN VARCHAR2, p_from IN VARCHAR2, p_body原创 2013-01-18 17:27:13 · 4662 阅读 · 1 评论 -
Oracle APEX 如何在APEX中使用CSS
In order to keep the practice momentum of this practical Oracle APEX book (Create Rapid Web Applications Using Oracle Application Express) and to leave something for users to think over, I intentional转载 2012-08-12 14:06:49 · 4074 阅读 · 1 评论 -
Using CSS in APEX pages and regions
If you want to use your own style sheets in your application here an example how to do it:Go Edit Page Attributes --> HTML Header --> Add css text and Apply ChangesGo Edit Region --> Title:转载 2012-02-21 17:21:25 · 1465 阅读 · 0 评论 -
Oracle APEX级联LOV:Cascading LOVs/Select Lists
原文地址:http://www.inside-oracle-apex.com/oracle-apex-4-0-cascading-lovsselect-lists/One of the new features of Early Adopter 2 are Cascading LOVs/Select Lists. I’m pretty sure that almost every AP转载 2012-02-17 21:10:27 · 2285 阅读 · 0 评论 -
Page refresh button
文章1:http://www.apex-at-work.com/2009/11/page-refresh-button.htmlIf you want to create a page refresh button inside your APEX page you need to add the following things:1. Upload a button picture转载 2012-02-18 00:15:18 · 1396 阅读 · 0 评论 -
How to add help to Apex pages
This article describes the way help can be added to APEX pages. This is very important to inform the users of the application about the functionalities that are available in each of the pages. When转载 2012-02-19 00:37:15 · 691 阅读 · 0 评论 -
Building Applications with APEX
1. 创建Workspace:http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21679/setup_env.htm#CCHDIFAJworkspace:2DayPlus Username:ADMINPassword:Welcome_1和workspace:hrUsername:ADMINPassword:We原创 2011-12-16 17:34:07 · 1345 阅读 · 0 评论 -
APEX文件上传下载
APEX文件上传下载按照如下步骤创建上传下载文件的应用程序,文件的内容即可以存放于默认的视图APEX_APPLICATION_FILES或者自己定制的表格中,例如oehr_file_subject,如果自己定义的表格,需要有一个列是BLOB类型http://docs.oracle.com/cd/E14373_01/appdev.32/e13363/up_dn_files.htm原创 2012-02-29 15:46:44 · 876 阅读 · 0 评论 -
APEX文件上传下载
APEX文件上传下载按照文档http://docs.oracle.com/cd/B31036_01/doc/appdev.22/b28839/up_dn_files.htm的步骤创建上传下载文件的应用程序,文件的内容即可以存放于默认的视图APEX_APPLICATION_FILES或者自己定制的表格中,例如oehr_file_subject,如果自己定义的表格,需要有一个列是BLOB类原创 2012-03-01 16:21:31 · 2238 阅读 · 0 评论 -
Oracle APEX 点击按钮出发事件执行PL/SQL
1. Create a button named, Submit.2. Create a Page Process(1)Category PL/SQL(2)Give your Page Process a Name(3)Sequence Determines when the process is fired(4)Point On Submit - After Computat原创 2012-08-02 14:34:30 · 2286 阅读 · 0 评论 -
Oracle APEX使用PL/SQL function返回select语句进行动态查询
How to create a report that's based on a dynamic query Table of ContentIntroductionSoftware RequirementsCreate a dynamic query reportAdd Item and ButtonAdditional ResourcesIntrod转载 2012-08-02 18:19:39 · 2495 阅读 · 0 评论 -
Oracle APEX支持基于云计算的网络开发
Oracle创始人兼CEO拉里·埃里森曾表示“云计算完全是胡扯。”,但在上周举行的Oracle开发者大会上,Oracle透露其APEX产品完全支持基于云计算的互联网和内联网开发。记者就此专访了Oracle服务器技术软件开发副总裁Michael Hichwa。 在9月份的Oracle OpenWorld大会上,Oracle的创始人兼CEO拉里·埃里森曾公开表示云计算已经成为广告词,认为“云计算转载 2012-08-05 00:46:30 · 1815 阅读 · 0 评论 -
Oracle APEX 在页面直接传递参数值
例子一:It's easy to understand the contents of a APEX URL. The APEX documentation shows an example of passing values between screens:Passing a single item in APEXIt clears existing information a转载 2012-08-05 21:26:34 · 3390 阅读 · 0 评论 -
Oracle APEX Open a new window/tab page and navigate to a URL
Please see screenshot below:URL为:javascript:window:open('#My_REPORT#');void(0);For more:https://forums.oracle.com/forums/thread.jspa?threadID=1049327原创 2012-07-31 18:01:10 · 1573 阅读 · 0 评论 -
Oracle APEX Report根据列排序
当对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语句,只是用colu原创 2012-08-07 16:08:44 · 1100 阅读 · 0 评论 -
Oracle APEX Report的某一个列根据条件显示不同的颜色
Query:select empno,ename,sal, case when sal < 1000 then 'color:red;font-weight:bold;' when sal between 1000 and 2000 then 'color:purple;font-weight:bold;' when sal > 2000 then 'color:green;font原创 2012-08-09 16:42:50 · 1788 阅读 · 1 评论 -
Oracle APEX Classical Report的列根据条件判断显示为Link
方法如下:select decode(TEST_RESULT,null,'N/A','Test Result') as "Result"from TestTablewhere Test_ID=123456如果TEST_RESULT的值非空,则显示为一个link。注意,在Result还需要做以下设置:将column attribute的Display As属性设置为Sta原创 2012-08-09 20:02:18 · 967 阅读 · 0 评论 -
Steps to install Apex 4 on linux
Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy pr原创 2011-12-14 23:15:53 · 1450 阅读 · 0 评论 -
Oracle APEX 使用htp包动态生成HTML源码
Using APEX it’s very easy to display information using forms and reports regions, you could even throw in a chart or dial for a bit of something different. However, it’s also simple to generate HTML p转载 2012-08-10 17:54:48 · 1868 阅读 · 0 评论 -
Oracle APEX 使用htp和htf生成html源码(含css和javascript)和处理业务逻辑
WHAT IS PL/SQL?PL/SQL stands for Procedural Language/Structured Query Language. It is a programming language that uses detailed sequential instructions to process data. A PL/SQL program combines转载 2012-08-11 00:05:01 · 5198 阅读 · 0 评论 -
Oracle APEX Web开发入门
目录一、导读1.APEX支持基于云计算的网络开发Oracle APEX支持基于云计算的网络开发 二、安装与维护1. 安装APEX Steps to install Apex 4 on linux 2.安装Sample,创建一个人力资源应用程序Building Applications w原创 2012-08-10 18:03:05 · 2738 阅读 · 0 评论