Orcale PPT

1
ORACLE

• www.greenstechnology.com

2
What is oracle?

• In 1979, Oracle Corp. was the first company
  to commercialize an RDBMS platform, and it's
  still the leading database vendor by a wide
  margin in terms of revenue.
• Decades after launching the RDBMS
  technology, Oracle greatly expanded its product
  portfolio through internal development and
  numerous acquisitions.
• It now also sells several other databases,
  multiple line of business applications, Data
  analytics software, middleware, computer systems,
  data storage equipment, development tools and
  other technologies. 

3
Oracle Database overview
4
Oracle Database's architecture

• The Oracle software is tied to PL/SQL, an
  implementation developed by Oracle that adds a
  set of proprietary programming extensions to
  standard SQL.

5
Oracle's current versions (20s)

• Oracle8i Database Release 3 8.1.7.08.1.7.4
  (patchset as of August 2000)
• Oracle9i Database Release 1 9.0.1.09.0.1.5
  (patchset as of December 2003)
• Oracle9i Database Release 2 9.2.0.19.2.0.8
  (patchset as of April 2007)
• Oracle Database 10g Release 1 10.1.0.210.1.0.5
  (patchset as of February 2006)
• Oracle Database 10g Release 2 10.2.0.110.2.0.5
  (patchset as of April 2010)
• Oracle Database 11g Release 1 11.1.0.611.1.0.7
  (patchset as of September 2008)
• Oracle Database 11g Release 2 11.2.0.111.2.0.4
  (patchset as of August 2013)
• Oracle Database 12c Release 1 12.1.0.1 (patchset
  as of June 2013)
• Oracle Database 12c Release 1 12.1.0.2 (patchset
  as of July 2014)
• Oracle Database 12c Release 2 12.2.0.1 (patchset
  as of March 2017)

6
Oracle Database editions

• Oracle Database Enterprise Edition includes all
  of the software's features and is designed for
  use by large organizations running high-volume
  transaction processing, data warehousing,
  analytics and internet applications.

7
Error Handling

• Error Handling Function
• Provide developers full control when an error
  occurs
• Capabilities include
• Log all errors
• Map errors raised by the Oracle Database (like
  Unique constraint XYZ violated) to friendlier
  error messages
• Display all errors Inline in Notification
• Increase security by masking internal APEX errors

8
Data Upload

• Provide the ability for end-users to update
  spreadsheet data into tables
• Developer uses wizard to specify parameters
• Following pages created
• Data Load Source
• Data / Table Mapping
• Data Validation
• Data Load Results

9
Calendar

• Added Drag and Drop functionality
• Change Date and Time of records
• Added ability to create Edit page as part of
  calendar wizard
• Edit Page types of
• Existing page
• Pop-up page
• New page

10
Plug-In Enhancements

• Increased Number of Custom Attributes to 15
• New Attribute Type - Checkboxes
• Add plug-in Support for
• Authentication Schemes
• Authorization Schemes
• Attribute Usability Enhancements in Application
  Builder

11
Dynamic List

• Base list on SQL or PL/SQL functions
• Dynamically create styled list items
• Especially important for mobile based
  applications

12
Mobile Applications

• Provide themes HTML templates suitable for
  smart phones and mobile devices
• jQuery Mobile
• Dynamic List Support
• Improved HTML out of the box
• We plan to bundle jQuery Mobile into a future
  release of Application Express

13
Database Software Conclusion

• while working with Oracle, you learned how to
  adjust the SQLPlus environment using
  the FLAGGER to mark queries that contain Oracle
  extensions.
• In this module, you learned how to
• Identify the primary components of an Oracle
  database
• Name several data dictionary views and their
  purpose
• Log into the database with SQLPlus
• Distinguish between standard SQL and Oracle's SQL
  extensions and describe when to use each Oracle
  Database 11g SQL

14
Thank you