Programmatic Structures in Oracle

Read this Oracle Tutorial Point article to know about the programmatic structures in oracle database and different types of editions in oracle RDBMS. There are different types of programmatic structures in Oracle. That are,

1. PL/SQL:
   It is the most critical component of all the application implementations. The component can be used to create stored procedures and functions. Using this element the stored procedures and functions will be collected into single unit called packages. Using the same element the database trigger also can be designed.
2. Dynamic SQL:
   Using this concept SQL can be generated at runtime and pass it to procedures that execute it.
3. SQL * PLUS:
   It provides simple interface to the oracle database. It supports Rudimentary reportage and is that the best tool for scripting. It provides consistent interface for,
   
   • Retrieving data from data dictionary.
   • Making/Creating database objects.
4. Java & JDBC:
   It supports JAVA and JDBC and help is using Java within the place of PL/SQL. Java based mostly stored procedures can written.
5. XML:
   Oracle XML interface and XML types can be used to support inserting and retrieving of information via XML.
6. Object Oriented SQL & Pl/SQL:
   Oracle can be used to create and access object oriented structure, including user defined data types, methods, large object tables and nested tables.
7. Data Pump:
   Data pump export and data pump import, enhance the manageability and performance. Data pump can be accustomed quickly extract data and move it to completely different databases while alerting the schema and changing the rows.
8. SQL * LOADER:
   It's used to load flat files quickly into Oracle Tables. A single flat file can be loaded into multiple tables throughout a similar load, and loads are often parallelized.
9. External Programs and Procedures:
   SQL is embedded with in external programs. Procedural libraries are often created and can be linked later to oracle.
10. UTL-Mail:
    It is a package introduced in Oracle. It allows a PL/SQL application developer to see e-mails without having to know how to use the underlying SMTP protocol stack.

Types of Editions in Oracle:

1. Enterprise Edition:
   It contains all options and is that the wealthy extensible version of the Oracle database. It includes the features such as Flashback Database. The licensed functionalities are supported are:
   • Oracle OLAP
   • Oracle Spatial
   • Oracle Data Mining
   • Oracle Label Security
2. Standard Edition:
   It provides some set features of Enterprise Edition. It includes features that are needed by small business entity.
3. Personal Edition:
   It allows for the development of application which runs on either the quality or enterprise edition. The edition is not suitable for Production Environment.