Monday, September 26, 2016

Oracle Forms
 Default Menu Toolbar



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 forms can easily handle the CRUD processes of your system application and more in one menu toolbar.
 New developer with a  previous experience of other programming languages tends to manually handle the CRUD processes by  writing many lines of code which almost ends with wasting time and efforts while Oracle forms presents these functions and more in a menu toolbar.

Oracle forms toolbar 
 is a set of iconic buttons that represent individual items from a menu. Some of these buttons are  shortcuts to the forms basic operations CRUD  of Captured One.

The Acronym CRUD 
refers to all of the major functions that are implemented in relational database applications. Each letter in the acronym can map to a standard SQL statement as follows:

  Create  - INSERT  - to store new data.
  Read    - SELECT  - to retrieve data.
  Update - UPDATE - to change or modify data.
    Delete  - DELETE  - delete or remove data 

Without at least these four operations, your application  software cannot be considered complete. 
  
The  Oracle Forms default menu toolbar is not a separate menu module, but is built into every form module. If and Only if a developer specify this into each for menu as the  following steps:

·        Press (F4) to open the form module property.
·         Functional's node > select  menu module  property.
·        Paste  > DEFAULT&SMARTBAR

It includes standard commands for database transactions e.g. Save, New, Delete, Print button and common  navigating arrows as shown in the below image




Alternatively u could either create a canvas toolbar from canvas's property> canvas type> toolbar.
Or u could customize the menudefs.mmb. in the demos provided by Oracle.


Note:

  •        Pls notify that the DEFAULT&SMARTBAR must be attached if required to every form module as mentioned.
  •        The default menu toolbar is not for customization because it is a part of the frmall_jinit.jar.

In my point of view, any Oracle Developer  building a new system application can optimize his time by using the default menu toolbar giving by Oracle forms.
 Otherwise, if any other requirement is needed you can create your own customized one.

: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, September 22, 2016

Import Oracle Database



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,

  
Well, after discussing the export utility  to create an Oracle binary-format dump file, we will logically need to learn about  reading this binary file through using the Import utility.

Task Definition:   

Import  data  from dump files into an Oracle  database


 What Is the Import Utility?

        The Import utility is used to read data from Export files into an Oracle database. Export dump files can only be read by the Oracle Import utility. 


   Before using Import :            

  • Run the catexp.sql or catalog.sql script.
  • Verify that you have the required access privileges.

Task Solution:

There are two Import utility methods  you have to consider:
1.     imp (Old & not recommended).
  2.     impdp  (New & recommended).

Both methods will do the same function; import a dump file e.g. file_name .dmp and store the imported data into the database.

 The question you may ask is...
 What is the difference between both methods if they are giving me the same output ?

The Answer to Your Question:

·        Data Pump recreates  the user, whereas the old imp utility requires you or the DBA to create the user ID before importing.
·        The original import utility dates back to the earliest releases of Oracle, and it's quite slow and primitive compared to Data Pump that  gives 15 – 50%  performance improvement than exp/imp.
·        It's much easier to implement as you will see.

Now,let me ask you:  How do you export  your data ...?
 You have only two answers either using exp or using expdp method.

·         Using exp and a full schema requires these Solution Steps:
  
1.    Create the user:

create user identified by default tablespace quota unlimited on ;

2.    Grant the rights:

Grant connect, create session, imp_full_database to ;

3.    Start importing Data:

    Select Start  menu> select Run> write CMD then a window will open write the following command according to your naming requirements:

impdp user_name/password@database_instance   file= file_name.dmp  log=log_file_name.log full=y;
 Example:
 impdp Scott/tiger@orcl  file=test.dmp  log= test_log.log  full=y;     
·         Using expdp and a full schema requires you to only write this command line:
 Select Start  menu> select Run> write CMD then a window will open write the following command according to your naming requirements:

impdp user_name/password@database_instance   file= file_name.dmp  log=log_file_name.log    full=y;
 Example:
impdp Scott/tiger@orcl  file=test.dmp  log= test_log.log full=y;
          The Data Pump Import utility is invoked using the impdp command. The characteristics of the import operation are determined by the import parameters you specify. These parameters can be specified either on the command line or in a parameter file.

Note:
·        The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file.

Learn more about:

·        Export Utility


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.