Announcing the launch of Live Online Training in "Administering Oracle Application Express"

DBCON announces the launch of its new course "Administering Oracle Application Express". Starting right from understanding what is Oracle Application Express to installation, up gradation, configuration, monitoring and management - learn all the essential skills to manage Oracle Application Express Instance in the most effective and efficient way.

For this training, all participants will have their own dedicated linux server (accessible over Internet through secured shell like Putty) where they will practise to install, upgrade, configure, manage & administer Oracle Application Express Instance.

DBCON's Live Online Training - Probably the best and most convenient way to learn Oracle Application Express. Anyone from anywhere in the world can attend this live online training. All you need is a PC and Internet connection. Complete course details, batches and schedule available at http://www.dbcon.com/courses.html

First Oracle Application Express Workshop in Singapore

On Monday, 27th April 2009, Oracle Corporation Singapore organized the first ever Oracle Application Express workshop at its office in Singapore. DBCON assisted Oracle in organizing this workshop.

Despite the fact that Oracle Application Express is not yet popular in this part of the world, the response and the turnout in this workshop was very impressive. Out of a total of 49 people who signed up for the workshop, 29 participants turned up. And that too when the workshop was organized on a weekday (Monday) and after office hours (6:30 - 9:30 PM).

Pizzas, sandwiches, tea & coffee set the right environment to start the workshop after day's work at office.

Blair Layton from Oracle started with 45 minutes presentation on Oracle Application Express in which he introduced Oracle Application Express, discussed the architecture and covered some of the security aspects. Blair also demonstrated how to create an application in Oracle APEX directly from a spreadsheet - without writing even a single line of code.

This was followed by the two hands-on lab exercises from OBE (Oracle By Example) series so that participants could have a feel of creating applications in Oracle Application Express. In about an hour and a half, most of the participants had their first APEX application up and running. An impressive feat considering the fact that before the start of the workshop most of the participants had no idea about Oracle Application Express.

Also for the very first time, the lab environment that was given to the participants was setup on Amazon AWS cloud. Oracle Application Express with Amazon AWS cloud is a deadly combination as you can have your application up and running literally in just a couple of hours which includes setting up hardware, operating system, database & creating a fully functional application.

The workshop ended with a quiz round where participants were asked questions from the workshop and got a chance to win T-shirts.

Oracle Application Express - Easy to develop, easy to deploy, easy to manage.

With Oracle APEX focus on what needs to be done, not how it should be done !

How to find out what all database objects have been used in an APEX application

As your APEX application gets bigger and complex sometimes you may want to know what are the different database objects like tables, functions, procedures, sequences etc. that is being used by the application. You may want to have this information handy if you want to transfer your application from one environment to another (typically when you want to deploy application from test envrionment to production environment) or you may also want to have this information so that you can do a housekeeping of your database and remove all the unused objects.

"Database Object Dependencies" report in Oracle Application Express gives you exactly that information. Checkout in this less than 2 minutes video to see how you can extract this information.

(Don't forget to turn the volume up to listen to some nice music as you watch this)

If you are using highspeed broadband connection, click on "HD" icon to view the video in high definition ("HD" icon is visible once you play the video). Once in HD mode, click on "Full Screen" to view the video in crystal clear format.

Step by step guide to create "Aria Employee Directory Lookup" application in Oracle APEX

Oracle provides some pre-created applications in Oracle Application Express known as packaged applications. Packaged Applications are fully functional applications that you can view, use and customize. These packaged applications can be downloaded from Oracle's web site

Even if you download and use packaged application, sometimes and especially for beginners it becomes a challenge to really understand how these packages applications have been developed and decipher each and every component of it. This step-by-step guide is an attempt to address that problem, where you will recreate each any every component of the application yourself and have full understanding of it.

One of such packaged applications is “Aria Employee Directory Lookup”. Aria is used globally within Oracle to look up phone numbers, email addresses and other information about employees. Each employee can update his or her preferred contact information and upload an image for the employee profile page. Using this guide you will be able to create Aria Employee Directory Lookup application from scratch.

Once you have learnt Oracle Application Express, the next step is to put it to use. Training is necessary for getting the fundamentals right but there can be many challenges when you actually get down to create an application. Having a step-by-step guide that will walk to you through the different steps of how to create an actual application will give you an added advantage. It’s like taking an expressway to gain experience to develop real life applications.

Please do not forget to send your comments, feedback and suggestions to contact@dbcon.com . Please specify “Aria Employee Directory Lookup” in your subject line.

To use this guide effectively you must have the basic understanding of Oracle Application Express. If you are an absolute beginner in Oracle APEX we will highly recommend you to look at our training program “Developing Applications with Oracle Application Express” before you dive into this guide.

Aria Employee Directory Lookup Application - Step-By-Step Guide to create application in Oracle APEX

Publish at Scribd or explore others: How-to-Guides & Manu oracle application e oracle apex

Get Supporting Files

Like any other application, Aria Employee Directory Lookup is also dependent on other supporting objects. These support objects include

• Database Objects likes Tables, Indexes, Packages, Procedures, Functions, Sequences etc.
  
• Sample data in the tables
  
• Image Files
  
• Javascript Files
  
• CSS Files
  

In order to get started with the development of this application, you need to prepare your environment first. As our focus is just on creating the Aria Employee Directory Lookup application in Oracle APEX, a script has been provided to which will create all of the above mentioned supporting objects in your APEX workspace.

Click here to get the supporting files for Aria Employee Directory Lookup Application

Creating an Oracle APEX application from spreadsheet

One of the beautiful features in Oracle Application Exress is the ability to create an application straight from the spreadsheet. If you are wondering what is so great about it, well the beauty is that you don't have to write even a single line of code to do that. It is amazingly smooth and seamless. Check out the following step-by-step presentation to see how to do that.

Creating an Oracle APEX Application from spreadsheet

View SlideShare presentation or Upload your own. (tags: apex express)

In less than 5 minutes you can have a fully functional application from a spreadsheet. Isn't that cool ?

Commands to create schema for Oracle APEX Workspace

If you choose to create a schema while creating the workspace in Oracle Application Express administration service, APEX will create a brand new tablespace as well. This may not be an ideal situation. Having too many tablespaces, specially when it is not required, adds management and administrative overhead.

You can use the following script to create the schema and then just use this schema when you are creating the worksace. (Substitute your own values for values shown in blue color)

-- Connect as SYSTEM or DBA User
$ sqlplus system/password@XE

-- Create the new Schema/User
CREATE USER APEXAPPS IDENTIFIED BY APEXAPPS
DEFAULT TABLESPACE APEXAPPS_TS
TEMPORARY TABLESPACE TEMP;

-- Grant quota on assigned tablespace
ALTER USER APEXAPPS QUOTA 10M ON APEXAPPS_TS ;

-- Grant Role Priviledge
GRANT "CONNECT" TO APEXAPPS ;
ALTER USER APEXAPPS DEFAULT ROLE "CONNECT";

-- Grant system privileges
GRANT CREATE JOB TO APEXAPPS ;
GRANT CREATE INDEXTYPE TO APEXAPPS ;
GRANT CREATE SYNONYM TO APEXAPPS ;
GRANT CREATE DIMENSION TO APEXAPPS ;
GRANT CREATE VIEW TO APEXAPPS ;
GRANT CREATE CLUSTER TO APEXAPPS ;
GRANT CREATE MATERIALIZED VIEW TO APEXAPPS ;
GRANT CREATE PROCEDURE TO APEXAPPS ;
GRANT CREATE ANY CONTEXT TO APEXAPPS ;
GRANT CREATE TYPE TO APEXAPPS ;
GRANT CREATE SEQUENCE TO APEXAPPS ;
GRANT CREATE OPERATOR TO APEXAPPS ;
GRANT CREATE TRIGGER TO APEXAPPS ;
GRANT CREATE TABLE TO APEXAPPS ;

-- Grant Object Privileges
GRANT EXECUTE ON SYS.DBMS_RLS TO APEXAPPS ;
GRANT EXECUTE ON CTXSYS.CTX_DDL TO APEXAPPS ;
GRANT EXECUTE ON CTXSYS.CTX_DOC TO APEXAPPS ;

These commands will create the schema and assign the same privileges to that schema that gets assigned when you create a new schema while creating the APEX workspace (verified in Oracle APEX 3.1.2). Once the schema is created specify 'Yes' for Re-use existing schema and then specify the schema name as shown below.

Learn Oracle Application Express from anywhere in the world !

DBCON announces Live Online Training in "Developing Applications with Oracle Application Express". Forget traveling to learn the intricacies of APEX or waiting for the course to come to your city. Now anyone with a basic understanding of SQL, PL/SQL, HTML and database objects can start developing in APEX quickly and easily - with just as much live interaction with instructors and other students as they would have in an in-person course, but on a convenient online schedule. Moreover, the course is about one-fourth to one-half the price of courses offered by other institutions.

DBCON’s “Developing Applications with Oracle APEX” course, based on the firm’s progressive training methodology offers students an in-class environment with online convenience. Students can ask questions, participate in discussions and talk to instructors in real time and sketch ideas on a virtual whiteboard.

The class is not just a paraphrase of Oracle APEX training books. Our instructors have real-world experience working in Oracle and APEX, backed up by Oracle certification. Students get the benefit of speaking directly to Oracle professionals who can answer their questions in the context of working as a professional developer.

“Developing Applications with Oracle APEX” gives students a solid foundation in using the popular Rapid Web Application Development Tool. Classes include live demonstrations that allow participants to see exactly how the technology works, along with extensive hands-on lab exercises. Each student has a dedicated lab workspace available 24 hours for the duration of the class. Total training time is about 14 hours, not including individual lab time; students can attend part-time or full-time, weekdays or weekends - and classes are batch scheduled to cater to various time zones. All sessions are recorded, allowing students to revisit concepts as needed.

“Although it is simple to start using APEX, the breadth of the product can be a little overwhelming,” stated course participant Stuart Ellis of London. “This excellently structured and well-delivered course provides a solid grounding that should enable [students] to develop APEX applications with confidence. The online conferencing technology proved to be quick and unintrusive. I would not hesitate to take another course that is delivered in this way.”

Check out this audio video presentation on our Live Online Training. To view it in full screen please visit http://www.dbcon.com/video/oracle_apex_lot_video.html .

We also offer a free trial class as well as a 100% money-back guarantee on the course. To learn more, please visit http://www.dbcon.com/DevelopingWithOracleApex.html.