Sunday, July 7, 2019

Blog Site Creation Using Oracle Application Express 19

Leave a Comment
We are going to discuss about Blog Site Creation Using Oracle Application Express 19.
Oracle Application Express (APEX) is a framework to create multi purposes application. One of current available type of application is a blog site. A blog site that already exist and used is blogspot.


There are 2 main parts of Oracle Application Express environments which are Application Builder and SQL Workshop. Application Builder is used to create the application, it consists of several component. SQL Workshop is used to design the data structure along with the data itself. When we create a web base application, we must design the data structure after that we will design the application by using the created data structure.

Many of other articles already discuss about Oracle Application Express in many ways, some of them discuss about beginner knowledge or even in advanced knowledge. Next some articles will describe the basic and advanced theories about Oracle Application Express concurrently with the implementation by creating a blog site application. The blog site will have capabilities to show an article that has an image or YouTube video within it and it will have administrator area to control the articles. 

Oracle Application Express features that will be used to create the blog site are Page, Region, Items, Buttons, Dynamic Action, Processes, Authentication, Authorization, Lists. HTML, CSS, javascript will also be discussed here. Of course the SQL and PL/SQL capabilities also will be discussed.

Here are the Chapters:


Chapter 1, Example of Live Oracle APEX on VPS


Chapter Content:
·         Just APEX Blog (JEBLOG) -> www.jeblog.net
·         JEBLOG features

Chapter 2, Oracle APEX 19 Features
·         Page Rendering
·         Page Processing
·         SQL Commands
·         Application Builder
·         Simple Application Development Example

Chapter 3, Design the Database
·         Entity Relationship Diagram (ERD) Theory
·         Generate Tables from ERD


Chapter 4, Develop Web Blog using Oracle APEX
·         Create ERD
·         Create Mockup diagram
·         Application Development


Chapter 5, Go Live Oracle APEX + VPS (Virtual Private Server)
·         Introduction to VPS
·         VPS Hosting Plan
·         Manage your VPS
·         Upload your Oracle APEX Web Blog


Next articles will discuss each of the chapters.
Thank You - Bobsis
Read More

Saturday, May 18, 2019

Custom Authentication with MD5 Encryption on Oracle APEX 19

Leave a Comment

This article will guide you to create custom authentication with MD5 Encryption on Oracle APEX 19.


On every computer application there will be a login process to make sure only authenticated user is allowed. As a default, every application built on Oracle Application Express has predefined authentication scheme using Application Express Accounts. This predefined authentication scheme will allow user to make a login into built application using same credential as their workspace login.

There is another way to make another authentication scheme, which is will be using different credential not the workspace credential. We can create Custom authentication scheme that will use custom table to store the login credential. For example, we can create TLOGIN table with username and password attributes to hold the authenticated user credentials. This TLOGIN table will be read by the application login page when the application is running for the first time.

By default, all information stored inside the table the hold password information is a string. For example, the password for admin user is “thePassword”, this word will appear every time we open the data of table. Unfortunately, if someone else able to open the table, they will know the password and they will be able to enter the application.

There is a way to secure the credential even if someone else able to view the data inside the table. We can encrypt the string of text that hold the password credential by using MD5 hash encryption. Fortunately, Oracle has built in function to implement the MD5 hash function. This MD5 function will encrypt any words into 32 randomized characters. For example, “thePassword” will be encrypted into “OED4768C11461AB762DA1F5719AD560B”.

This tutorial will guide you to implement MD5 hash function into custom authentication scheme. Here are the steps:

1.       Open Oracle APEX website using your web browser. Login into your Oracle Application Express Workspace


2.       Create a Table namely TLOGIN with some attributes (e.g. ID, USERNAME, PASSWORD, STATUS)


3.       Go to Application Builder and click on Create to create new application


4.       Next choose New Application


5.       Set the project name with anything you wish (e.g. ProjectWithMD5), leave other options as default and the click on Create Application button


6.       The application is created, you will found 3 pages (Global Page, Home, Login Page)


7.       Click on Shared Component


8.       On Security area, click on Authentication Schemes


9.       Choose “Based on a pre-configured scheme from gallery” the click on Next button


10.   Fill some information on required text field.
Name: myOten, Scheme Type: Custom, Authentication Function Name: cek_otentikasi


11.   Still on Create Authentication Scheme page, scroll down and fill in the PL/SQL code with a function and then click on Create Authentication Scheme Button


12.   Create a function “GetMD5(pstring IN VARCHAR2) RETURN VARCHAR2” using SQL Workshop


13.   Execute the function to get encrypted password


14.   Open TLOGIN table, insert one record contains the encrypted password


15.   Run the application, try to login using any username and password. Invalid Login Credentials will be appeared.


16.   Try to make a login using admin as the username and thePassword as the password, it should be worked.


17.   The homepage will be appeared as the login process has been successful


Thank You - Bobsis

Read More

Wednesday, March 27, 2019

How To Create First Web Application in Oracle APEX

Leave a Comment

This article will describe about How To Create First Web Application in Oracle APEX (Application Express). After successfully install Oracle APEX, the next process which is the main process is creating the web application. This article will give you an illustration about how to create simple web application. The processes will give you global knowledge about how to create a web application in Oracle APEX for all of your future applications. When you understand the processes in this article, you will be able to create other application easily.

Here are the processes of creating web application on Oracle APEX (Oracle Application Express 19.1.0.00.13):
1.       Login into your Oracle Application Express Workspace.



2.       After successfully login into the workspace, click on App Builder to start the creation.


3.       The next process is choosing about how we are going to create the application. We can Import existing application by choosing Import icon instead of creating from scratch. Here in this article we are going to create the application from scratch, so we choose Create icon.


4.       Next, choose New Application to continue the process


5.       In the next page we need to fill and choose some options. For an example you might to fill the information as follows:
a.       Name                    : myProject
b.       Appearance       : Vita – Red, Side Menu
c.       Features              : About Page, Feedback
Scroll down the page and click on Create Application button on the bottom.


6.       The creation progress bar will appear, wait until the progress is completed.



7.       That’s it, we already complete the process, some pages will be generate automatically. It’s time to test our new application by clicking the Run Application icon.


8.       The first page will be shown is your application login page. Fill your Oracle APEX credentials and click the Sign In button.


9.       Your new application home page will appear, you may click anything visible there. If you want to sign out from your application just click on login username located on the right top of the page.



That’s all for the process of HowTo Create First Web Application in Oracle APEX. Hope it’s clear enough for you to create your first web application in Oracle APEX.

Thank You - Bobsis

Read More