Overview
Recent Reviews
Reviewer Sentiment
Awards



Popular Features
View all 6 featuresReusability (21)
Platform Security (21)
Platform User Management (21)
Drag-and-drop Interfaces (21)
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Oracle APEX, and make your voice heard!
Pricing
View all pricingOracle APEX Application Development
$0.32
Oracle Autonomous Transaction Processing - Exadata Storage
$118.40
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Features Scorecard
Low-Code Development
Product Details
What is Oracle APEX?
Oracle APEX Competitors
- PostgreSQL
- Microsoft
- Salesforce
Oracle APEX Technical Details
Deployment Types | SaaS |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Comparisons
View all alternativesCompare with
Frequently Asked Questions
What are Oracle APEX's top competitors?
What is Oracle APEX's best feature?
Who uses Oracle APEX?
Reviews and Ratings
Reviews
(1-25 of 38)- Popular Filters
Business Intelligence in Oracle APEX
I want to share my experience in one app we did. We are maintaining a relatively large data warehouse, design in star schema. This was used as a source for few BI tools and standard reports presenting some parts of Data Warehouse, but there was always a need for people with no SQL knowledge to get look in some part of data warehouse not presented in existing reports and tools to explore new possibilities or just to verify data. So we need some kind of simple presentation layer that quickly and easily can expose the data model and provide access to end user where they can review data in form of tables or charts. APEX look like is the perfect environment for that.
https://simplebimple.com
Login with :
user: demo
pass: demo
- Easily create web application
- Rich , ready to use web interface components
- Easy deploy and maintain application
- Simple and powerful security configuration out of the box
- Some of the configuration options are a bit hidden, probably a bit better organization of workspace and application settings would benefit development process
- Fast. Nothing beats Oracle Application Express in terms of speed of development. Almost all common and must-have features for most application has been built into Oracle Application Express, and we only need to focus to the specific requirements.
- Quality. Luckily, fast doesn't always translate to low quality. Even using basic wizard, within five minutes, we can build a quality application that has good security, a good user interface and good features, and this can be a very good standard for a company. It's not the best, but it's easy to tweak to achieve higher than standard quality.
- Customization. The apps created are very customizable. You only need to understand Oracle SQL and PL/SQL, Javascript, and JQuery. Then, you can create nearly any application you have in mind.
- Prototyping. When we are working for a client, sometimes it's hard to be on the same page when at first we only talk about the application concept. Using Oracle Application Express helps to create a prototype application and adjust it according to the client's input within minutes. This greatly helps bringing IT and non-IT clients on the same page faster.
- It's tied up to Oracle Database only. If you don't have Oracle Database, forget Oracle Application Express.
- I wish it has offline mode so it could be used in no-internet areas and sync it when it's back online.
- It's not critical, but it would be nice if there were more choices of themes. I know Oracle Application Express has couple of themes, but in my opinion, currently only Universal Theme is the theme for Oracle Application Express.
- Easy to use.
- Easy to configure.
- Easy for building reports.
- Easy for building forms.
Quick development and deployment for simple apps!
- The UI is very easy to use, and you can choose from a number of templates for each "screen" you design.
- You can design basic CRUD screens without knowing the "details" (technology) under the hood.
- It's easy to test. Just one click, and the page you are working on is executed.
- Deployment on an OnPremise DB is not so simple. You need to follow many steps (that's why I used the Cloud version!).
Awesome APEX
- Very rapid development of forms and reports.
- Awesome GUI look and feel.
- HTML 5 and CSS 3 compliant. The new version 19.2 now supports rest endpoints for forms and reports.
- Integration with other databases like My SQL, etc.
Fast, cheap, and easy application development
- Easy set-up.
- Plugins.
- Lot of configurable options.
- Hard to use version control.
Snap! The future is here
- Manages security well
- Provides a responsive environment to build apps in
- Easy connection to database services
- Manages sessions very well
- Javascript functionality
- Mobile app development- more versatility required especially with the display of reports
- More documentation that is easy to understand
- More sample apps on configuration of services and authentication schemes
- Make it easy to customize templates
- More themes required
I get the ability to gain a lot of experience from the great minds and also provide help to upcoming developers.
Oracle APEX, build with love
- Easy to learn and to understand.
- Low code. You can create really fast reports with just " SELECT * FROM TABLE".
- People can work on reports simultaneously.
- In Excel, you have to send the file via mail to other people and only one person can work it. Sometimes there are more than one version of this file. With Oracle, this does not happen.
- Sorry but there are still no cons!
Exhilarating Trip to the Apex World
- Creating screens for capturing the data takes less time.
- Moving only few changes from 1 instance to another.
Be a Rock Star Developer with Oracle RAD Stack
- Oracle Application Express is tightly integrated with and thus leverages all the richness and power of the Oracle database - best RDBMS on the planet
- Promotes declarative Rapid Application Development and thus provides tremendous business value by shortening development cycles
- Can't think of any - the Application Express development team does a fantastic job adopting and supporting emerging trends with each new release.
- Requires Oracle RDBMS; i.e., is not portable to other RDBMS platforms. On the surface this may seem like a con but it is as it should be - Oracle database is best RDBMS available and tight integration with Oracle RDBMS promotes creation of reliable performant apps.
Worldwide Oracle APEX user community is a fantastic group of people, enthusiastic, passionate believers in this technology because it gets the job done and is a joy to work with!APEX community is active routinely sharing valuable knowledge to do with basic and advanced techniques, best practices and secrets for success.I've never found myself stumped unable to find some great help/assistance/example for even the most esoteric objective I might need to address.
Oracle APEX or Oracle Climax?
- Extreme fast application build and production.
- Single sign-on via multiple authentication sources.
- Easy to maintain.
- Easy to administer users.
- Easy to administer authorizations.
- Debugging on several layers.
- Virtually everything is customizable.
- Better CSS editing (WYSIWYG).
- integrated URL masking or better integration via ORDS to make URL masking.
- out-of-the-box ORDS load-balancing.
- APEX is incorporated in the database, which gives it better performance then other tools.
- Fast in implementing changes.
- Out-of-the-box responsive applications thanks to the universal theme.
- When you have an highly customized application upgrading can be a pain.
- Single page applications are hard to build.
- Easy upgrade path from Forms, allowing reuse of code and a low learning curve for Forms developers.
- Very quick to develop in. Ideal for prototyping or iterative development which is how we usually work.
- Comes with cross browser and mobile compatibility out of the box.
- Easy to incorporate other web technologies.
- Development environment runs straight from a browser. This has proved to be a life saver when issues crop up on a weekend.
- No built in printing solution for reports.
- While being low code for many tasks, some web development skill is helpful for anything complex. I frequently need to use Javascript/CSS/HTML.
tennisapp.bfw-design.de (Oracle APEX 4.2/5.2/18.2)
BIB-Lueneburg APP (Oracle APEX-Mobile)
BIB-Lüneburg - Fairground Booking system (Oracle APEX)
ESFA - Clubmember Administration and Bookkeeping (Oracle APEX 5.2/18.2)
Facility Management with Financial Acconting (Oracle APEX 18.2)
KIS - Kundeninformationssystem (CRM + ERP + Controlling + HR) für Gutachterbüro - 200+ Mitarbeiter (Oracle APEX 5.2/18.2)
Module: Enter Order (ERP), Sales (CRM), Controlling, Management/Reports, Training Planing, Complaint Management,
Vacation/Absence Administration with approval process and calendar visualisation
73 Tables, 309 pages, Accounting: hostet (cloud) application
In production sind August 2017 - daily entering of about 900-1000 orders by 200 employees, daily settlement.
Printing (PDF) based on Jasper-Reports.
Construction Company: Working hours collection/monitoring with Tablet/Smartphone inkcl. Interface to DATEV und external Salary calculation provider (Oracle APEX 18.2)
- Ideal for quick prototyping
- Ideal for quick amendments and enlargements
- Numerous types of pages/regions (forms, lists, reports, diagrams)
- Oracle JET integration
- REST
- Optional Jasper Reports integration (not OOTB)
- Printing in good shape not so easy.
- Diagrams, charts need more detailed explanation concerning the SQL queries needed (examples).
- No more cons.
Very satisfied with APEX
- Charts
- Loading Excel files
- Interactive reports and interactive grid
- Automate email sending
- Improve LOV features so that it could be more flexible
Honest, enthusiastic and right on the point!
- Rapid prototyping enables us to develop very fast.
- Low code allows us to create applications in a declarative way without too much code written.
- It's free!
- You need to find ways to fulfill special customer requests that are not built in and a little bit more complex.
- You need to have a running Oracle Database (possibly licensed if not XE).
The APEX user groups around the world are more than just 'there'. I'm actively contributing to ODTUG and DOAG and so are many many other people! If you need help - you get help from the community. This is by far the best community I've been involved in during my career.
With low code high productivity
- Low code.
- Runs on all devices.
- Good charting and representation of data.
- I can prepare some nice chart in seconds instead of using reports.
- Trend and performance is visible in a scale from employees to organization.
- Great productivity.
- The interactive grid has great potential, but there's a lot of work to be done.
- The interactive reports and interactive grid should share the same jet charts.
- Easier integration of JET into APEX.
- Tree grid.
- The interactive grid would have easier navigation using the same principles as in interactive reports (filtering) when you navigate from page to page.
- It would benefit from the possibility to print nice charts from IR or IG.
- Needs a better choice of tool-tips.
Oracle Apex - You need to try it
- Develop solutions faster
- Everything can be done in a browser
- Immediate Results
- Version control
- Oracle Dependency
The group is great, people help each other, and even give ready solutions.
The business problems are totally diverse, ranging from HR, CRM, ERP, mobile apps and portals.
APEX is mostly used in an environment where an Oracle database is already present -- that could be for developing in-house applications, or hosting Oracle's own ERP systems like Oracle E-Business Suite or any other Fusion product. APEX is the tool of choice if you want to build extensions or customizations to these standard applications.
And APEX is by design "cloud ready" -- it always has been and will always be.
- Fast development due to the low code approach.
- Responsive out of the box due to the built-in Universal Theme.
- Cloud enabled by design. You can build applications only using a web browser.
- Scalable: if it runs inside the Oracle database, it uses the full power of that database.
- Free: it is a no-cost option for the Oracle database.
- It runs everywhere where Oracle runs, from a small (free) XE database on your laptop, to an Exadata machine.
- The only languages you need to know are SQL and PL/SQL. Some JavaScript and CSS knowledge might be handy but not strictly necessary.
- Version control. As all metadata is stored in the database, there are no files to store in a GIT or Subversion repository (unless you export from the database).
- Lock in: you are locked in into the Oracle database, and that's why it is mostly used in an environment where that database is already present.
- Oracle is not "popular" at the moment, so the average developer is somewhat older than the regular (JavaScript) developer.
NL Oracle User Group organises a yearly two-day event: APEX World. This is (still) the largest APEX-only event in the world with around 350 attendees. ODTUG offers webinars around APEX, and has around 45 APEX related sessions at its yearly conference in the USA. Both user groups do an excellent job in building the community.
Oracle Express
- Eliminates the complexity involved with multi-faceted web applications.
- Oracle Express supports enhanced productivity in low code apps.
- It requires no complex build scripts to operate.
- The software supports effortless customization and design.
- Lack of a native app.
- Installation time can be improved, it takes a while to download.
I am not a member of other user groups but have talked to some people who are. They enjoy how this product combines easily with theirs to make work easier on them.
Using Oracle APEX is the way to go
- Development is done quickly. Any change to the application can be seen immediately. No generation time needed.
- Compared to Oracle Forms/Designer this saves a lot of time.
- The use of CSS and javascript to beautify the layout is easy.
- There is a large community where you can ask questions or read about how other developerS solved certain issues.
- Also the Oracle APEX team itself can be reached quite easily.
- They listen carefully to the suggestions of their users.
- As you have a lot of freedom where to put your code or how you code it, it is important to think well about standarisation.
- Version control must be done in a separate tool like Subversion.
The usergroup organises every year a huge two days conference about Oracle in The Netherlands. The best place to meet your fellow developers and the APEX team members.
Oracle - Recommended for Professionals Like You
- Organization - it helps streamline employee information.
- User-friendly - very simple to use once you are trained on it.
- Timely - system works quickly and efficiently.
- Reporting - you have to use a certain code to run reports, and the reports will fail if you don't use the proper coding when requesting them.
- System crashes - our server goes down once or twice a week.
- Searching for employees - we can only search by last name, and sometimes it does not recognize the name the first time you enter it.
Oracle APEX: off the shelf extensibility
- Lightweight
- Flexible in it capabilities and uses.
- Quick to learn with any Oracle or database background.
- Easy to develop in.
- Some specific utilities are not well documented.
- Plugins could be expanded.
Oracle APEX: A quick tool for building responsive Web pages
- Oracle APEX can be used as good replacement for Excel data entry sheets.
- It provides high level of security about their personal information.
- It is very easy to install.
- As it is Oracle-specific, it is not suitable for other databases.
- Everything is stored online, if there is no internet we can't access the tool.
APEX: A versatile development platform, ideal for developing or improving applications at low cost
- It is an easy tool to adopt, which allowed us to replace developments in Oracle Forms in many cases.
- It is very simple to develop different kinds of analysis, in a faster and more friendly way than running Oracle Reports.
- It helped us to extend our approval workflow, in order to cope with difficult branches that were hard to solve with the standard workflow.
- It was possible to develop web applications, to share information and transactions with our commercial partners.
- Perhaps is our problem, since we haven’t explored it deeply, but I think that a better portability to mobile devices would help the adoption of APEX.
- Applications weren’t as light as we thought, and we had to move the APEX server to the same data center where our data base was running, due to performance issues. When we started, we supposed that that situation would not be an issue.
- At least in Argentina and Brazil, you can not find as many programmers with experience in APEX as you can find with other technologies.