Saturday, April 28, 2018

Create Auto-Increment Numbers Manually Client-Side


  Create Auto-Increment Numbers Manually 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 generated automatically when a new record is inserted into a specific table you have pre-  determined.
Often it is a database field of a primary key constraint type. we would like to create it automatically  in synchronize with every new record is inserted into the database table.

  • Generally, there are two types of auto-increment number 

    1. Server Side. 
    2. Client Side. 

Task Definition:   

Create an Auto-increment Number Client Side Manually.


Task Solution:


 Let's start doing that task. 
 Once, you login into Oracle Apex, open SQL WORKSHOP.

Create A New Database Table   


 CREATE TABLE SERIAL_DEMO (
DEMO_ID NUMBER(11) PRIMARY KEY,
DEMO_DESC VARCHAR2(55)
;
    /
  
  • Create a new Oracle Apex Page as follow...


  • Select a new blank Oracle Apex Page. Then, click next to continue ...


  •  Specify the Oracle Apex Page name as follow. Then, click next to continue ...


  •   Select create a new navigation menu entry and specify its display name in the new navigation menu entry as follow. Then, click next to continue ...


  •  Check the page summary. Then, press Finish to confirm its creation.



  •  The blank page is successfully created as follow. 


  •  Press run button to check its successful creation.


  •   Select Regions, press right click with mouse. Then, select Create Region.


  •   Now a new empty region is created. Rename it with Serial_Demo.


  •  Select the new created region, press right click with mouse and select Create Page Item. 

  • Follow the necessary modification concerning; name, label. 
  • Under Source> select  Type > Database Column  .& specify the Database Column name as Demo_Id.


  • Create another page item called Demo_desc the like in the  previous steps.
  • Follow the necessary modification concerning; name, label. 
  • Under Source> select  Type Database Column  .& specify the Database Column name as Demo_desc.


  • Press Save & Run button to check the last modification.


  •  Select the process tab, then the process folder, press right click with mouse and select Create Process. 




  • Follow the necessary process modification concerning; name, label. 
  • Settings  > select  Table Name > Serial_Demo 
  • Primary Key Column >  Demo_ID
  •  Primary Key Item > F3_Demo_ID


  • Create another process called  Auto_Number_Process.
  • Type PL/SQL Code

PL/SQL Code   


 BEGIN
  SELECT NVL( MAX (DEMO_ID + 1),1) 
  INTO :P3_DEMO_ID
  FROM SERIAL_DEMO ;
END;
    /

  • Select Regions, press right click with mouse and select Create Button.


  • Follow the necessary button creation concerning; name label
  • Layout > Button Position > Create  
  • Behavior  >  Action > Submit Page.

  • Select SQL WORKSHOP drop down list 
  • Select Object Browser.
  • Right click on Object Browser.
  • Select Open Link in a new tab as follow... 


  • Object Browser will be opened in a new tab as follow.
  • Search for the table name.

  • Check for any data in the table data tab. You will find no data exists.


  • Go pack to the Page Designer & run the page in the browner.
  • Insert data in the demo desc page item.
  • Press Create button.
  • I accidentally stacked in this error for 2 minutes.
  • Then go to inspect for it. 


  •  I found a logical error in the sequence of the two processes i have just created
  • I fixed it by preceding the auto increment pl/sql code before inserting it.
  • So i re-order the processes with the logical correct sequence to its execution then it works successfully.

  •  Run the page then input some data.
  • Press Create button.


  • A pop-up message declares a successful inputs into the database. 


  • Now, let's check data into the database.



      Note

  •  I shared this task with you since it involves many web concepts really we all need to recognize. In Shaa Allah, later on i will discuss these concepts with you to realize how Oracle Apex works. 
  • Oracle recommends working with server Side because it is more reliable and secure than the client side code.




Learn more about:

Hope this helps...

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



Thursday, April 12, 2018

Create Your First Web Application Only Within 3 Minutes

Create Your First Web Application
 Only Within 3 Minutes


      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 
    • work spacea :pex_demoo
    • user:  n
    • pass word:  n

     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.
   
   Task Solution

     
      There are more than a way to start your new web page wizard. Let's  follow:  
One way you can use is during Creating Your Web Base Application.

After login to your Oracle Apex dashboard page, press the page builder shortcut.


  • You can either press the upper left shortcut or the blue button marked with red to launch the web application wizard.




  •     Select the Desk Top Application marked with red.



  •   Specify the required application name & the application number is given by default. It is unique but can be changed if you like. Then, press next.




  •   Press the 'Add Page' in order to create your web page application in the mean time of creating your application.
  

  •    Choose one of the available web page types as required. Let's choose Form and Report page. In this page you must specify the table name on which the form and report web pages will be based. Then press add page.    


  •  You will notice a list of pages displayed. One blank Home page is created by default with the new application. In addition to the two form and report pages we have just created.  Then, press next.



  • Oracle Apex gives you the advantage to inherit any shared components you previously built in other application e.g. list of values, themes etc. in order to save your time and effort in the development process. Keep it as default. Then, press next.


  •  Oracle Apex gives you the ability to configure you application language, date and time format if you like. You can press next and ignore it without any error 


  •  Oracle Apex gives a final chance to check your final application configuration and  modify it back if you like before confirming its creation. 


  •  Finally, you get your first Oracle Apex new web application at the mean time with two web form and web report within at most three minutes. 



Learn more about:

Hope this helps...   

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




Monday, March 26, 2018

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 twiceOne 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.

Task Solution:

  •    Open the cmd command prompt
  •    Change its prompt path as shown in the following screenshot.
  •   Then, type SQLPLUS  to connect to sys user.

  •    Run script @apxconf.sql as in the screen shot.



  •         Use ADMIN by default, or use your Admin user predefined.
  •         Specify your email or skip this step.
  •         Specify a strong  admin password.

          Oracle recommends administrators establish a password complexity policy for each Oracle Application Express instance according to the following rules   
   
  
·         Must be at least six characters long.
·         Must contains  at least one numeric digit.
·         Must  contains  at least one punctuation character (!”#$%&()“*+,-/:;?_).
·         Must contains at least one upper-case alphabetic character.
·         Must contains  at least one lower-case alphabetic character.


      My advice is to write down any permanent or temporary passwords & save them in a safe folder. If you forget your admin password you will never not be able to retrieve it back but with the previous steps

Learn more about:


Hope this helps,

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