Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Time:2019-3-9

This article is one of the Oracle APEX series articles of Gongge. The complete Oracle APEX series articles are as follows:

  • Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds
  • Oracle APEX Series 2: Create your own APEX development environment on Aliyun (Preparations)
  • Oracle APEX Series 3: Create your own APEX development environment on Aliyun (install CentOS, Tomcat, Nginx)
  • Oracle APEX Series 4: Create your own APEX development environment on Aliyun (install XE, ORDS, APEX)
  • Oracle APEX Series 5: Create your own APEX development environment on Aliyun (further optimization)
  • Oracle APEX Series 6: Is Oracle APEX Suitable for Enterprise Environment?

Introduction

It has been 13 years in the field of Oracle ERP unconsciously. From the basic SQL, PL/SQL, Linux Shell script, Oracle Form, Oracle Report, Workflow, Discovery, Middleware (BPEL), OBIEE, BI (XML), Publisher, OAF, ADF, to the later work of applying DBA in environment construction and cloning, we can say that we want to be a qualified Oracle ERP technology. Consultants, there are so many things to master that the skills of an ordinary Internet developer are far from comparable.

However, with the rise of Internet technology, new development frameworks and technologies emerge in endlessly. The emergence of a mature Internet architecture, the separation of front-end and back-end technologies, the massive use of caches, the rise of micro-services, and the instant introduction of full stack development, etc., have all caused today’s Oracle technology practitioners to suffer a considerable blow in terms of both technology and treatment (think about the treatment of an Oracle ERP technical consultant 10 years ago, which is absolutely better than that of Java developers with the same experience). Salaries more than doubled. Many former colleagues engaged in Oracle ERP development are now either looking for another job or maintaining some antique projects, occasionally talking about the future is also a sigh, lament the timing.

Is the way out for Oracle development bound to be narrower and narrower? The answer is definitely No. Oracle’s database is still the largest market share database up to now, and Oracle ERP field is not simply comparable to Internet technology, its complex business logic and industry experience is your most valuable capital. How to make rational use of their existing knowledge and skills and break out a new world in the current era of the Internet is probably the confusion faced by most Oracle technicians.

Admittedly, Oracle’s product line is very rich, but the problem is that the technology stack is also very complex. In addition, its main Oracle ERP product: Oracle Fusion Application technology selection and design has a hard injury. When I first learned about Oracle Fusion Application that year (2009), I had predicted that Oracle ERP would go downhill. Although Java is very good, Oracle opens it in a wrong way. It chooses ADF as its development framework. Its performance and scalability are greatly discounted. Very poor user experience makes Oracle have to give up developing Oracle Fusion Application after many years and investing huge resources. Instead, Oracle purchases cloud ERP vendor (NetSuite) as its main ERP product, which wastes a lot of time. Time and human and material resources are regrettable.

But one of Oracle’s many products is very good. (Actually, the product is not very appropriate, because it is not only a product, but also a development tool, and can be understood as a framework.) Since I used it 10 years ago, Oracle has accelerated its development in the last two years, making this product ushered in a new spring, which is today’s protagonist:Oracle Application Express(abbreviation)Oracle APEX)。

Purpose of this paper

This series of articles seeks to precipitate my experience in using Oracle APEX over the years and facilitate my own inquiries. At the same time, I hope to bring a little inspiration and ideas for the majority of Oracle technology practitioners, to learn with you and make progress together! __________
If you satisfy any of the following:

  • Oracle Developer
  • Oracle DBA
  • Oracle ERP Technology Development Consultant

And want to change the whole stack development in seconds, one person to complete the front end and back end, just follow me!

A Brief History of Oracle APEX

Oracle APEX is a web application rapid development tool based on Oracle database produced by Oracle Company. It aims to facilitate Oracle database developers to build web application system quickly. Its history can be traced back to 2004 at the earliest.HTML DBIn 2009, it was renamedOracle APEX

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

But Oracle APEX is really getting people’s attention, starting with APEX version 4.0. Starting with this version, Oracle has greatly enhanced the development efficiency of APEX, and has also enhanced many new functions, making Web development easier.

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

APEX 5.0 can be said to be a milestone for Oracle APEX. Since version 5.0, Oracle APEX has added a series of new components and features (especiallyDynamic ActionsDynamic behavior, which allows users to embed custom JavaScript code, also makes Ajax easier to be applied to development, including the enhancement of development tools and the improvement of visualization effect, pushing Oracle’s speed and quality of Web application development to a new level, which can be said to be a very important version.

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

APEX 5.1 increasedInteractive GridControl can add, delete and check database tables in zero code, and has many very easy-to-use functions, which greatly improves the efficiency of development. It also integrates Oracle’s latest Javascript Icon LibraryOracle JetTo make data visualization more convenient and efficient.

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

What is Oracle APEX Suitable for

Now the concept of the Internet has been deeply rooted in the hearts of the people, often out of a new technology or tools, we like to put in the scope of the Internet for comparison. Indeed, Internet technology has many good things to learn from, including many ideas can be applied to the traditional ERP field. However, in many cases, we still have to look at cost-effective, not for the “Internet” and “Internet”. For individuals, they should consider their existing skills, maximize the use of existing skills, while retaining technical sensitivity, recognize their existing skills and conscious learning. For enterprises, we should consider comprehensively the development of the future period of time, the current technology stack and personnel technology level, what can not be new, but what is suitable for their own. It’s also the hardest thing to do “fit”. There’s no discussion here.

Gang Ge’s Perception: Oracle APEX Suitable for DoingTo B classEnterprise Application(Enterprise ApplicationThat is ERP, CRM application products. The characteristic of this kind of product is that the requirement of UI and concurrency is not as high as to C Internet product, but the business logic is relatively more complex, which is more suitable for internal use of enterprises. The advantage is also quite obvious, often a junior programmer with Oracle development experience, through Oracle APEX can be completed.Front end + back endAll the work, and basically belongs to zero code development, no matter from the development efficiency, or the development quality, is not comparable to the traditional enterprise development tools or technologies, which will be deeply appreciated in the later use process.

Let’s put some pictures and feel APEX intuitively.

Developer PortalOverall APEX development portal entrance, including: application builder, SQL studio, team development and packaged application modules.
Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Application Development InterfaceMost of the time is done here.
Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

SQL studioIt’s a familiar scenario that can replace SQL tools.
Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Group developmentOracle APEX naturally supports cloud development and deployment, and remote collaboration is certainly taken into account.
Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Packaged applicationsWeb application is the best way to learn APEX.
Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Interactive Grid ControlIt is the most NB control I have ever seen. Zero code realizes the functions of data adding, deleting, checking, searching, sorting and cascading. It is also a new function launched after APEX 5.1. It is strongly recommended.
Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

More icons
Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

It is worth mentioning that the Oracle APEX development tool itself is developed with APEX, which is in the true sense.“APEX on APEXIt is also an important criterion for our study and reference.

Advantages of Oracle APEX

  • The design and development of Web application can be accomplished by using native browser only.
  • It can easily expand and customize the standard components, UI, etc.
  • Complete development and deployment, naturally adapt to cloud deployment;
  • Zero code can also quickly develop complex business systems.
  • Efficient and convenient IDE makes the development of Web applications never so simple.
  • With its rich control and visual gallery, you don’t worry about wheels and materials.
  • Adaptive UI skin allows you to fix PC and mobile terminals at one time.
  • Bring a variety of scenario demonstration examples, let you start quickly;
  • Oracle officially supports the development of enterprise applications without worrying about additional costs.

Current Situation of Oracle APEX

At present, Oracle APEX has more than 400,000 developers all over the world, but few companies or developers actually use Oracle APEX in China. In view of the limited latest technical information about Oracle APEX in China, it is necessary for me to collate my own learning so that more people can understand and learn.

  • Oracle APEX official website
  • Oracle APEX Community
  • Oracle APEX Official Forum
  • Oracle APEX Active Blog

Oracle APEX Download Address

Up to now, the latest version of Oracle APEX 5.1.4.00.08 released on December 17, 2017

summary

The only requirement for using Oracle APEX is to have an Oracle database (because Oracle APEX must rely on Oracle Database). In the next article, I will take you step by step to install and deploy an Oracle APEX development environment, so that you can get a closer understanding of the strength of Oracle APEX.

Following the step of Gang Ge, Bao you quickly grasp the whole stack development, in order to make the road wider under your feet, we work together!!

Appendix: Selected Oracle APEX Blog Website

Pro-test is available, some websites need to turn over the wall.

  • http://vmorneau.me
  • http://rimblas.com/blog
  • http://apexbyg.blogspot.sg
  • http://lschilde.blogspot.sg
  • https://dickdral.blogspot.jp
  • http://max-tremblay.blogspot.jp
  • https://blogs.oracle.com/apex
  • https://thtechnology.com
  • http://dgielis.blogspot.sg
  • https://emoracle.wordpress.com
  • http://www.grassroots-oracle.com
  • http://hardlikesoftware.com/weblog
  • http://www.explorer.uk.com/blog
  • https://ruepprich.wordpress.com
  • http://davidsgale.com
  • http://joelkallman.blogspot.hk
  • https://www.talkapex.com
  • http://nuijten.blogspot.nl
  • https://www.odtug.com/apex
  • https://ora-00001.blogspot.sg
  • https://apextips.blogspot.sg
  • https://oracle-base.com
  • http://spendolini.blogspot.sg

Oracle APEX Series Articles 1: Oracle APEX, let you change the whole stack of black technology development in seconds

Recommended Today

ASP.NET Example of core MVC getting the parameters of the request

preface An HTTP request is a standard IO operation. The request is I, which is the input; the responsive o is the output. Any web development framework is actually doing these two things Accept the request and parse to get the parameters Render according to the parameters and output the response content So let’s learn […]