Thursday, 10 September 2020

Oracle APEX 20 Full Stack Set For Beginners

A three-book set for absolute beginners who want to become dynamic web developers

This three-book set combines the titles No-Code Oracle APEX For Thirteen To Ninety, SQL and PL/SQL For Everyone, and Oracle APEX 20 For Beginners. Together these three books will provide a solid foundation to anyone who has the desire to develop dynamic data-driven web applications quickly with no/low code features of Oracle APEX.

Oracle APEX is a low-code application development framework. Low-code is a software development approach that enables the delivery of applications faster and with minimal hand-coding. Low-code framework helps you create complete applications visually with the help of drag-and-drop interface and wizards. Rather than writing thousands of lines of complex code and syntax, low-code platforms allow you to build complete applications with modern user interfaces, integrations, data and logic quickly and visually. Oracle APEX is one such area.

You can use Oracle APEX free of charge – either as part of an existing Oracle Database license or running in the free Oracle Database 18c XE product. Oracle APEX empowers you to build incredible apps and solve real problems. And you won't need to become an expert in a vast array of web technologies, such as HTML, CSS, JavaScript and more. Oracle APEX is capable to do the heavy lifting for you. You just need to focus on the problem to be solved.

The book No-Code Oracle APEX For Thirteen To Ninety - Build Your First Web App without Writing a Single Line of Code is for anyone who wants to become a web developer but is scared of writing tons of code and is looking for the easiest track to start with. I compiled this book for everyone (especially teens) to make web application development fun for them rather than a nightmare.

The SQL and PLSQL languages are too voluminous and exposure of every aspect of these huge languages is a very tedious task. Keeping aside the least utilized features, the book SQL and PLSQL For Everyone is rolled out to focus on the more operational areas of the language. It is meant to help you learn SQL and PLSQL quickly by yourself. It follows a tutorial approach wherein hundreds of hands-on exercises are provided, augmented with illustrations, to teach you SQL and PLSQL in a short period of time. 

Oracle APEX 20 For Beginners is my eleventh book on Oracle Application Express (APEX) written for the latest version. Just like my previous books that exposed the technology to thousands around the globe, this next-level book is also aimed at beginners who wish to learn from self-paced professional guidance and need a solid foundation in Oracle APEX.


Monday, 27 April 2020

Creating Dynamic Web Apps in Oracle APEX Without Writing any Code


This book is for anyone who wants to become a web developer but is scared of writing tons of code and is looking for the easiest track to start with. I got the idea for this book from my neighbor’s son who was studying computer science. Few months ago he approached me to discuss his IT project. He was very dejected and from his discussion I realized that the cause of his depression was the platform he was using to create the project, which involved lots of coding. Choosing such heavy coding platforms for absolute beginners is not a good idea - they need something very simple to get on the track. Keeping in view the scenario, I compiled this book for everyone (especially teens) to make programming fun for them rather than a nightmare.

Oracle APEX is a low-code application development framework. Low-code is a software development approach that enables the delivery of applications faster and with minimal hand-coding. Low-code framework helps you create complete applications visually with the help of drag-and-drop interface and wizards. Rather than writing thousands of lines of complex code and syntax, low-code platforms allow you to build complete applications with modern user interfaces, integrations, data and logic quickly and visually. Oracle APEX is one such area.

You can use Oracle APEX free of charge – either as part of an existing Oracle Database license or running in the free Oracle Database 18c XE product. Oracle APEX empowers you to build incredible apps and solve real problems. And you won't need to become an expert in a vast array of web technologies. Oracle APEX is capable to do the heavy lifting for you. You just need to focus on the problem to be solved.

This book is written for people of any age who have a desire to become web developer. The main objective of this book is to give you a jump-start in the exciting world of web application development and to make you a web application developer in a short time span. If you start learning to develop web apps today, you can actively perform your role in this fast-changing world. It is the skill of the 21st century. Organizations today need more problem-solving ability than ever before, and almost every career opportunity involves technology as a mandatory prerequisite. It is the only occupation that doesn't need master or doctoral degrees.

Mark Zuckerberg developed Facebook in 2004 when he was a college student. In 2014, 1.4 billion people were using Facebook every month. Facebook demonstrates the power of technology to engage billions and to reach more people. Mark just spent his time doing things that interested him and he did them obsessively because it was fun.

Don't try to be someone else. Be yourself. You can't create the Big Thing right now, but you can create the few small things, and bring them up so they grow bigger. If you haven't started creating something yet, get started now! 



Tuesday, 31 December 2019

Creating Kanban Board in Oracle APEX using HTML5 Drag n Drop Features

This Kanban Board is created in Oracle APEX and it allows you to drag and drop cards between different system development lifecycle (SDLC) tasks. This is not a plugin. It is built using HTML5 Drag n Drop standard features. The icons and pictures on the cards are fetched from database tables. When you drag a card from one SDLC step and drop it on another, an Ajax Callback process comes into action and immediately updates the shuffling in a backend table. Each task is provided as a link on the card that, when clicked, calls a modal page to update task details. Similarly, the plus sign that appears under each SDLC pane, lets you create a new tasks.

Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869:37






Two-Steps Authentication via SMS in Oracle APEX

The smart authentication enables application access using dual authentication methods. The first method is the conventional username and password combination. The second one is smart code authentication in which your smartphone is used. The second method is added to the first one to add an extra layer of protection to your app. Even if your username and password falls into wrong hands, they can't access the app, because they don't have your smartphone.  

When you run your application, it presents the conventional username and password for initial authentication. Once you are authenticated, a message containing 6 digit code is sent to your registered smartphone. A small text box pops up on the login page at the same time to receive the 6 digit code. Once this code is verified, you are landed on the home page. 

Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869



Drag N Drop and Click N Drop in Oracle APEX

Drag a product picture from the Products Catalog and drop it on the Shopping Cart interactive report. If you drop the same item again, its quantity and value are summed up. Clicking the delete icon in the Remove column removes the product from the shopping cart. Alternatively, just click the product image.

Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869:50




Customized Faceted Search in Oracle APEX

Oracle APEX 19.2 introduced Faceted Search, which allows you to apply filters to a classic report. The built-in faceted search page consists of a classic report region, showing search results, and a region of the new Faceted Search type, which holds the facets. The Faceted Search region is linked to the Classic Report region, and each Facet is linked to one of the Classic Report result columns.

I created this custom faceted search utility which contains different facets including a date range facet and is linked to an interactive report, which allows you to apply control breaks, aggregates, chart and group views, and pivot table.  

Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869:5






Monday, 30 December 2019

Using Calendar in Oracle APEX to Manage Events


Oracle APEX allows you to add calendars to your application with monthly, weekly, daily, and list views. Calendar is based on the FullCalendar jQuery library and can only be customized through CSS. You can create a calendar based on a table or SQL query. During the creation process, you are prompted to select date and display columns. Once you specify the table on which the calendar is based, you can create drill-down links to information stored in specific columns and enable drag and drop capability.

Using the Calendar component you can:


  • Display calendar events on multiple views (Month, Week, Day, or List).
  • Render duration and non-duration based events.
  • Render events from external sources using web service calls or Google Calendar feeds.
  • Modify the start and end dates by dragging and dropping events on different dates. Drag and drop is only supported for local data sources, that is, database objects in the referenced database schema and not on external data sources such as a Google calendar.
  • Edit or add new events on calendar using forms by clicking either on events or empty calendar cell.
  • Use different CSS classes, developer can choose different styles for different types of events.
  • Share events using multiple formats (iCal, CSV, XML).
  • Enable tooltip to make it easier for users to have a quick look at details of each event.


To use the calendar, you need to prepare a SQL query with the following columns:

Start Date – the start date for events displayed on a calendar. It can include the starting time.

End Date – the column which holds the end date for events displayed on a calendar. If this attribute is specified, then the calendar displays duration based events.

Display – Holds the text displayed for events on a calendar.

CSS Class – the CSS class name to style the events displayed on a calendar. This column is optional.

Primary Key – primary key for the event. The column becomes necessary if you want to enable drag and drop feature.

Supplemental Information – additional information which is displayed in the List View and Tooltip. Use &COLUMN. syntax to show column values in HTML. Show Tooltip must be set to Yes in order for this supplemental information to be displayed in the Month, Week and Day views.






Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869:13