Friday, December 22, 2017

Highway For Oracle Apex

Highway For Oracle Apex 


    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,

       May be you are anxious to try Oracle Apex by yourself. This article mainly presents to you a high way to Oracle Apex.
     It offers you a free Oracle Apex work space to try it yourself easily and  simply. 
       Let's follow the next steps below you will be able to feel and taste the beauty and capabilities of this wonderful technology.    


Task Definition:   


Create a new free Oracle Apex workspace. 
Hence, i will share all the difficulties i faced and discuss it with you.

Thursday, December 21, 2017

Oracle Forms 10G Installation For Oracle Designer


Oracle Forms 10G Installation
 On Windows 8.1 & Windows 10 64 bit



 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,


              Oracle  Developer Suite 10G still compete with Oracle Developer Suite 11g & 12c in regard to its convenient installation and common configuration. Although, Oracle no longer supports Oracle Developer Suite 10G but, it involves the latest Oracle Designer available for download at Oracle Official Site. 
     
       The significant installation problem is a compatibility problem. Oracle Developer 
Suite 10G is  no longer compatible with the new OS as Microsoft Windows 8.1 
 The need for Oracle Designer never stops and the client's old applications still running. These were two reasons to illegally create some work around.
  (May Allah Forgive Us ) to cope with the new Operating System.  

Task Definition:   

    Oracle Developer Suite 10G Installation for Oracle Designer. On Windows 8.1 64 bit


Oracle  Database Function
( Create & Call )


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,


      This is just an example of  Oracle Database Function to show you how can we create and call it as an individual database function not related to any PL/SQL package. Later on, In shaa Allah, we will declare and implement it with it's related database functions in a new package called a trans_pkg. 
Now, let's start the current task definition.


Task Definition:   

      1- Get the maximum quantity for each item stored in a specific  storage area.
     2- Update its maximum quantity in  the transaction table. 


Oracle PL/SQL Package

Oracle PL/SQL Package

      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's really a good practice to relay on PL/SQL Packages. Oracle bundle related PL/SQL programming resources into PL/SQL Packages.
It comprises  all the database triggers, procedures, functions and  etc.


PL/SQL Packages Advantage :

1.     Modularity:  One package  for a specific module or function.
2.      Security:      Granting privileges enhance security.
3.     Better Performance:  Loading multiple objects into the memory at once helps in reducing the traffic and increasing the performance.


 Task Definition:   

    Create PL/SQL Package  to group all related database  functions expected to return the name or the descriptions of all lookup tables created within  your application.


Wednesday, December 20, 2017

Oracle Flags Validation


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,

     Flags are useful in Oracle form validations. It's value can be stored into the database or it can be handled from form side. It can be represented in many different forms e.g. a checked box, a radio box or a static drop down list.


Task Definition:   


Validate a database  flag.


Oracle Report Layout
Confine Mode Vs. Flex Mode


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,

 This is a reminder upon request to Oracle developers concerning dealing with two main component modes of  Oracle Report  layout.

  •        Confine Mode.
  •        Flex Mode.

       These two modes  control  the management of  your report frames and fields. wizards can do the initial layout but wizards are always unsatisfied; you must modify the layout manually. Here comes the need to recognize the functionality of Confine and Flex modes to deal with them efficiently.


Tuesday, December 19, 2017

Start Learning &Tasting Oracle Apex

Start Learning & Tasting  
 Oracle Apex


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,

  • If you think its time to start a forward step into a promising career.
  •  If you think of upgrading your skills to learn a new web technology.
  •  If you think of the easiest way to develop fast attractive web application.

             Then, you should first pray to Allah "Estikharah" to guide you in shaa Allah
 to the best career path. Then, after praying, if your heart feels comfortable with choosing the web technology path  then i do re-command you to start learning the promising Oracle Apex technology


       In shaa Allah, the next following lines will define to you:


  • what is Oracle Apex?
  •  why do customers are increasingly looking for upgrading their old oracle forms applications?
  • How can you get a free on line access to Oracle Apex Work Space?
  • What are the basics skills you need to learn Oracle Apex?
  •  What is the starting point you are looking for to start learning Oracle Apex; this includes all the most simplest and reliable tutorials in both languages English and Arabic.
  • Where can you get the technical support?


        Well, Oracle apex is a 100% browser-based rapid application development (RAD) tool that helps you to create rich, interactive, Oracle-based web applications very quickly and with relatively little programming experience effort. 



Why Do Customers Choose Oracle APEX ?

·        Fully supported by Oracle.
·        No cost feature of the Oracle Database.
·        Low code means higher productivity with less experience & effort.
·        Interactive Web based & Mobile Technology.
·        Ultimate  Security since APEX is an Oracle database feature.
·        Familiar to developers using SQL and PL/SQL.
·        Distinctive Interactive Reports & charts for your application & more.
    

Do you like Oracle Apex benefits? 

If the answer is yesss then try it yourself with no need for an installation. 
Oh yes it's really true, the following are three steps that can helps you just keep on reading ...

.

Saturday, December 2, 2017

Handling Oracle Forms Sequence


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,


     You can smartly handle the Oracle forms sequence for your application with No Gaps as follow:


Task Definition:   


Increment a data block serial no by 1.