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.

دراسة جدوى تحليل نظم المعلومات

تحليل نظم المعلومات دراسة جدوى      

السلام عليكم ورحمه الله وبركاته...

بسم الله والصلاة والسلام على سيدنا محمد وعلى آله وصحبه وسلم ومن والاه

"سبحانك ربنا لا علم لنا إلا ما علمتنا إنك انت العليم الحكيم"

دراسة الجدوى  

     دارسة الجدوى هى من أهم الوسائل التى يلجأ إليها متخذى القرار فى أى شركة أو مؤسسة لدراسة وضع الشركة الحالى ومدى ملائمة المشروع المقترح من قبل شركات التقنية المختلفة لتلبيـة إحتياجاتها فى ظل ظروفها المادية وفى إطار إمكانيات موظفيها الفنية ومستوى عملائها فى إستخدام خدماتها التقنية ذلك من خلال تحليل وتصميم وتنفيذ وإختبار وتطبيق المشروع خلال فترة زمنية محددة،  ولا يفوتنا أهمية مراعاة شركات التقنية على المنافسة فى سوق البرمجيات بتقديم أفضل الإمكانيات التقنية وإقتراح تقديم الحلول التقنية المناسبة بأسعار تنافسية 
مقبولة لدى العميل.

مفهوم تحليل نظم المعلومات

 مفهوم تحليل نظم المعلومات

      

السلام عليكم ورحمه الله وبركاته...

بسم الله والصلاة والسلام على سيدنا محمد وعلى آله وصحبه وسلم ومن والاه
"سبحانك ربنا لا علم لنا إلا ما علمتنا إنك انت العليم الحكيم"

         إن أساس العمل فى مجال نظم المعلومات يشبة إلى حد كبير عمل المهندس المعمارى الذى يقوم بتخطيط وتصميم  المبانى لتنفيذ إنشائها على أرض الواقع، وكذلك محلل نظم المعلومات يقوم بتخطيط وتصميم البرامج والتطبيقات لإعدادها للتنفيذ والبناء على قواعد البيانات، وبالرغم من أن معدل تطوير لغات البرمجة تتقدم بصور مذهلة مقارنة بمعدل تطور مبادىء تحليل نظم المعلومات التى تعتمد على تجميع مفاهيم منطقية لسير العمل، وتقارير فعلية من مختلف الإدارات لإعداد مخططات وتصميمات تحليلية تستخدم كمدخلات للبرامج يتم استخدامها وتفعيلها لتوظيفها لتقديم حلول تتناسب مع متطلبات العميل، لذا فإن مفهوم ومبادىء تحليل نظم المعلومات لا يختلف كثيرا بل يظل هو الدعامة والقاعدة الأساسية التى نرتكز عليها فى بناء جميع التطبيقات، بصرف النظر عن تعدد وتطور لغات البرمجة. 

    تكررت أسئلة كثيرة حول ميول عدد لا بأس به من طلبة حاسبات ومعلومات، وبعض من مطورى البرامج الذين لا علاقة لهم بأساسيات تحليل وتصميم البرامج برغبتهم فى دراسة مفهوم ومبادىء تحليل نظم المعلومات باللغة العربية، فهى فى واقع الأمر ليست متوافرة بالقدر الكافى لدراسة مفهومها ومبادئها لا على الإنترنت ولا فى المعاهد التعليمية لإكتساب خبرات فى مشاريع تخدم وتعالج متطلبات العميل فى قطاعات العمل المختلفة مقارنة بنظيرتها باللغة الإنجليزية.

      وعليه فإن هذا المنطلق إن شاء الله سأبدأ فى شرح مفاهيم ومبادىء تحليل نظم المعلومات باللغة العربية وسألحق الشرح بأمثلة لأنظمة مختلفة من التحاليل ليكون مرجع لكل طالب علم مهما تنوعت لغات البرمجة التى يدرسها أو ينوى إن شاء الله العمل بها فى مجال تكنولوجي انظم المعلومات.

Zoom-in Oracle Apex Work Space

Zoom-in

Oracle Apex 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,

       Let's take a Zoom-in the significance of a work space and it's components. The development process takes place in the context of a workspace, so it’s important to know how a workspace is structured.

      

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.

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.

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.

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?

What Is Oracle APEX?

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

.