Wednesday, May 25, 2016

What's Oracle APEX all about?

Oracle Application Express (Oracle APEX), formerly called HTML DB, 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 professional applications that are both fast and secure. 
Oracle application express combines the qualities of a personal database, productivity, ease of use, and flexibility with the qualities of an enterprise database, security, integrity, scalability, availability and built for the web. 
Application Express is a tool to build web-based applications and the application development environment is also conveniently web-based. 
We can try Application Express simply by signing up for an account at apex.oracle.com.

What types of applications can we build with Application Express?

Application Express is a productive tool to build applications that report on database data. 
Reports are typically hyper text linked with other reports allowing users to navigate through database data in the same way they navigate web sites. 
Columns in reports can be easily linked to other reports, charts, and data entry forms and it is all done declaratively. 
An extensive charting engine allows SQL queries to be represented graphically and that allows data to be more effectively communicated. 
Application Express is also very adept at editing database data and supports a large number of declarative form controls including radio groups, checkboxes, select lists, shuttles, text editors, and date pickers.

When to use Application Express?

Due to its ease of use, Application Express is designed to build opportunistic and departmental applications quickly. 
These application are deployed on the web with superior performance. Historically, departments, prototypes, and small projects have relied on desktop databases to provide an agile development tool for these smaller scale SMB or departmental application development needs. 
Desktop databases can become very fragmented because they keep data in too many places, they can be vulnerable or inappropriate for use with sensitive information, and they are typically not web friendly. 
The browser based design time interface, the declarative programming framework, and simple wizards make Application Express a natural replacement for other multi-user desktop databases applications .
We don't need to learn scripting languages or complex deployment frameworks, you simply write a few queries and choose from ready built user interface themes and form controls to create highly professional, secure, and scalable applications.

No comments:

Post a Comment