QR Mobile Reader

QR Mobile Scanner

      In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

      

     I am not an expert in Oracle Apex, but i was strongly motivated  to perform this task.  In regards to creating the QR Code, it is so easy, but scan or read it...! It was so weird to me and to most of Oracle Apex developer experts. 

   QR Code, is a picture we can use Java script and css to code e.g. the related item serial or any information needs to be coded. But, the challenge resides in answering this question? 

How can we read the QR code directly from the mobile without any barcode reader device?    

     i spent time looking for a solution to this task the solutions i found it was rare and ambiguous to me as an ex-oracle developer expert has nothing to do with Java Script codes. After intensive search finally, Allah swt guide me to ask Eng. Amr Abdeen  who gave me the first step to start and guided me indirectly, but his guidelines  helps me a lot in accomplishing a mission of one of most my oracle apex dreams.

    Task Definition:   

   
    The task solves a problem of  wasting time and effort of  Sale  Representative who distributes some goods using only with his mobile and private car to his clients. While spending much time in manually filling out the concerned client's data into the sales invoice and confirm issuing it. 

   Task Solution:
  
    The know-how of this task mainly resides in using

 QR Mobile Reader Plug-in

 in-which the Oracle Apex application Camera is used to 

• Scan the QR Code  item directly by using the mobile.
• Retrieve the item code or serial no. into a QR Code text box.
• Implementation is in Shaa Allah, the next solution step that we are going to perform in the next blog to get the rest of related data item e.g. client name,item name and the sales representative's name into a report or form.

I'll assumed that you have already created a free work space,logged into it and have already created an application Then, all you need is to follow these steps...

1.  Download the plugin; the zipped  file and extract it.

1. Open the folder, read the README file for more information on setup and demo.
2. Open your own oracle apex application 
3. Then, import the  following file region_type_plugin_apex_qr_code_scanner.sql  from the plugin folder into your Oracle Apex application as follow...

• Click Import Export/Import Button on the right side of the page.

• Click Import Button.

• The following Import page will be displayed 
• Click choose file button.

 

• Select the high lighted file called  region_type_plugin_apex_qr_code_scanner.sql

• The .sql  file you have just choosed, is now uploaded.

• Click next, you are going through the import wizard steps.

• The following page will be displayed.
• Click next button.

• The following page will be displayed.
• Then, click Install Application button.

• Consequently, the following report will be displayed with all the imported plug-ins i have already tried before, "Al-Hamdu Lelleah", finally the last one works pretty good.

• Hence, the report's third row is our concerned QR code plug-in.
• 
  

Now, there should be two apex pages one to input data. Then second is to retrieve or  display data.  In Shaa Allah, the next coming blog, i am going to implement this new technology into two Oracle apex page. This is really very important link you should recognize to be able to use this technology between The involves demonstrating how can we use this plug-in into Oracle apex, 

Hope this helps,


Learn more about:

•        Start Learning & Tasting Oracle Apex
•        Highway For Oracle Apex
•          Zoom-in Oracle Apex Work Space
•          Reset Oracle Apex Admin Password

My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.

4- Create Oracle Apex Express User

4- Create Oracle Apex Express User 

      In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

      

     It really makes a good sense for an instance administrator to carry on creating a new Oracle Apex Express User for a new workspace assigned for the new application. ُEven in your training stage you may need to know how to take over this mission.

       There are main four integrated steps for creating a manual work space. I do recommend you to perform the four steps with the same order to avoid  inconvenience in the task work follow. They all will require access to the Administration Services.

     

Task Definition:   

1.  Create a New database user.  

2.     Create a New Work Space Manually.

3.     Assign One or More Database Schema To One Work Space.

4.     Create Oracle Apex Application User.  

3- Assign Schema To Work space

3- Assign Schema To Work space 

      In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

      

     It really makes a good sense for an instance administrator to carry on assigning a new or an existing database schema to the new workspace for a new application. ُ 

      There are main four integrated steps for creating a manual work space. I do recommend you to perform the four steps with the same order to avoid inconvenience in the task work follow. They all will require access to the Administration Services.

     

Task Definition:   

1.     Create a New database user.

     2.     Create a New Work Space Manually.

     3.     Assign One or More Database Schema To One Work Space.

     4.     Create Oracle Apex Application User.  

2- Create Manual Work space

2- Create Manual Work space 

      In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

      

     It really makes a good sense for an instance administrator to carry on creating a new workspace for a new application. ُEven in your training stage you may need to know how to take over this mission.
 There are four main integrated steps for creating a manual work space. They requires access to the Administration Services.and following them with the same order to avoid inconvenience in task work flow.

     

Task Definition:   

1.     Create a New database user.

2.     Create a New Work Space Manually.

3.     Assign One or More Database Schema To One Work Space.

4.     Create Oracle Apex Application User.  

1- Create New Database User

1- Create A New Database User

      In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

     Creating a new work space for a new application requires following the next  four steps in order to avoid the inconvenience caused by missing any step of them and helps you doing your task efficiently.

    

Task Definition:   

1.     Create a New Database User.

2.     Create a New Work Space Manually.

3.     Assign One or More Database Schema To One Work Space.

4.     Create Oracle Apex Application User.  

   The Database Concept:   

         At the beginning, Even though it is not my scope,  I would like to simplify the database schema concept for the beginners.apart from other formal definitions with a little comparison story. 

        Let's imagine, creating a new database schema for a new application looks like planning to buy a new apartment in a housing project. 
             The client mainly focuses on identifying a prospective residential apartment in respect to his needs and his financial limits. 
             This concept resembles to such an extent the task of a system administrator in determining the system users with the appropriate privileges that fits his role within the system How can this be ?!  Let's see...

Create Auto-Increment Numbers Manually Client-Side

  Create Auto-Increment 
Client-Side

In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

      Auto-incremented allows a unique number to be incremented automatically  when a new record is inserted into a table. 

  

Auto increment has two types 

•     
   Server Side.  
                
•                Client Side. 
    

     Task Definition:   

Create an Auto-increment Number at Client Side.

Your 1st Web Application In 3 Min.

Your 1st Web Application

 In 3 Min.

      In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

                     

      It is well known that building a web site application is a difficult job task; it takes long time and effort to build a web page application.


Believe it Or Not To Believe it. Now, You can create your first web page within only three minutes. 

!!!...How Can You Do It ? You can just do it     

Oracle Apex New Technology Offers it Free & Live. On its Free Work Space.   
. Paste the following url to your browser 

  

     https://apex.oracle.com/pls/apex   

• work space: apex_demoo
• user:  n
• pass word:  ApexDemo5

     Well, if this is your first time you think to learn Oracle Apex then you will need  to know that NO web page can be built without three components...

   

·        A work space.

·        A schema.

·        An Application.

You can read about them in previous articles. Now, let's start creating your First Oracle Apex Web Page through using the wizard.


Task Definition   

       

        Create an Oracle Apex Web Page.
   

Reset Oracle Apex Admin Password

 Reset Oracle Apex Admin Password

       

       In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

       Everybody awares of the high security level of Oracle database. This is the main reason that makes Oracle apex very secure. Abstractly, you can say Oracle Apex is a subset of Oracle Database. The need to learn how to set or reset an Oracle Apex admin password is of significant importance. 

    It's really weird but true that you must set Oracle Apex admin password twice. One time is during Oracle Apex installation, another time where you must reset admin password on start running Oracle Apex for the first time on the browser.

    You will need to follow & apply the next steps just in case of:

•  Oracle Apex installation.
• You forget Oracle Apex admin password.
• Your Oracle Apex user is locked or blocked.

Task Definition:   

    Rest Oracle Apex Admin Password.