Home » Posts tagged 'APEX'
Tag Archives: APEX
Sending a SMS to a mobile phone from APEX and PL/SQL
Sending a SMS to a mobile phone
This article from Inside Oracle APEX by Patrick Wolf
The article direct link Sending a SMS to a mobile phone
Summary
this article explains how to sending a SMS from APEX and PL/SQL through a Web-Service. For example if you have a system failure or get a new order in your shop…
OraPedia Channel
Summary
OraPedia channel contain the following video series:
Oracle APEX Advanced Tutorials (English)
Oracle APEX Installation and Configuration (English)
Oracle Performance Tuning 1Z0-033 Video Tutorials (English)
Oracle SQL Course (Arabic)
Oracle PLSQL Course (Arabic)
Oracle SQL Online Course (Arabic)
Oracle PLSQL Online Course (Arabic)
Oracle Forms Developer Course (Arabic)
Oracle Forms Developer Online Course (Arabic)
Oracle Reports Developer Course (Arabic)
Oracle Apps HRMS Setups Course (English)
Oracle Inventory ABC and Cycle Counting (English)
Multiple File Upload with jQuery and APEX Listener
Multiple File Upload with jQuery and APEX Listener
This article from Monkey on Oracle
The article direct link Multiple File Upload with jQuery and APEX Listener
Summary
Envious of the fancy multiple image upload functionality I saw from Google+, I set out to do the same. This is more of a log of observations than a full recipe. There is no APEX involved but the listener. To follow this you have to have an APEX Listener v1.1 (or higher) up and running against an Oracle 10g (or higher) database. This will not work with Internet Explorer or Opera (not multiple files), I have only tested on Google Chrome.
Oracle APEX the server requires a username and password the server says XDB
Oracle APEX the server requires a username and password the server says XDB
This article from Mohammad Fawzy
The article direct link Oracle APEX the server requires a username and password the server says XDB
Summary
After install APEX on enterprise edition database you will get the following message if you try to connect to APEX “the server requires a username and password the server says XDB”
In a new installation, we must configure the embedded PL/SQL gateway by running the configuration script apex_epg_config.sql. Then, we must unlock the ANONYMOUS account.
Identifying Host Names and IP Addresses
Identifying Host Names and IP Addresses
This article from Oracle Base
The article direct link Identifying Host Names and IP Addresses
Summary
This article presents a mixed bag of Oracle functionality relating to the identification of host names and IP addresses for Oracle clients and servers.
UTL_INADDR
SYS_CONTEXT
V$INSTANCE
V$SESSION
Moving your APEX Application to the Oracle Cloud
Moving your APEX app to the Oracle Cloud
This article from Dimitri Gielis Blog (Oracle Application Express – APEX)
The article direct link Moving your APEX app to the Oracle Cloud
Summary
Now that the Oracle Cloud is publicly available, I want to show you what it takes to put your APEX application on there.
Oracle APEX Video Training Tutorials – Complete List
Oracle APEX Video Training Tutorials – Complete List
This article from M & S Consulting
The article direct link Oracle APEX Video Training Tutorials – Complete List
Summary
This is a consolidated list of all of the Oracle APEX installation and configuration training tutorials and APEX training advanced tutorials produced by M & S Consulting.
These videos cover the following topics:
Oracle XE 10g Windows Installation Tutorial.
Install Oracle APEX 3.2 on XE and Windows XP Professional Tutorial.
Resetting Oracle APEX Admin Password Tutorial.
APEX 3.2 Advanced Tutorial Preparation.
Installing APEX 4 on Windows Server 2003 64 bit edition with Oracle Database 11g.
Upgrading to APEX 4 on Oracle XE and Windows.
Creating a Tabular Form.
Parameterized Report.
Drilldown Report.
Form Layout.
Check Boxes.
Implementing Web Services.
Stacked Bar Chart.
Up and Downloading Files.
JavaScript.
Access Controls.
You can watch these videos at OraPedia channel:
OraPedia Channel
Oracle APEX Installation and Configuration
Oracle APEX Advanced Tutorials
Oracle APEX upload a text file and write into a table
Oracle APEX upload a text file and write into a table
This article from OraExplorer
The article direct link Oracle APEX upload a text file and write into a table
Summary
One of the web development projects using Oracle APEX I’m working on is to upload the content of a text file in csv format into database. This article guide you to do this step by step.
Oracle APEX Highlight a Record in Report – with Dynamic Action
Oracle APEX Highlight a Record in Report – with Dynamic Action
This article from Notes on Oracle
The article direct link APEX: Highlight a Record in Report – with Dynamic Action
Summary
In this article I want to show you how you can highlight a record in a report with a Dynamic Action. Why would you want to choose for a Dynamic Action? This is a more efficient way because you don’t need to refresh the page or the region.
Oracle APEX 4.0 Text Field with autocomplete
Oracle APEX 4.0 Text Field with autocomplete
This article from Whitehorses
The article direct link [Oracle APEX 4.0] Text Field with autocomplete
Summary
In previous APEX versions there is a lot of functionality you can add by simply incorporating some custom javascript. One example is a text field that shows an inline list of values for an item based on a query. Of course this is great functionality to provide to the user, but not that great for maintainability because of the custom code. APEX 4.0 now provides this functionality out of the box with the new item type Text Field with autocomplete.
OraPedia 