Whatisoracle? • 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.
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.
Oracle's current versions (20’s) • Oracle8i Database Release 3: 184.108.40.206–220.127.116.11 (patchset as of August 2000) • Oracle9i Database Release 1: 18.104.22.168–22.214.171.124 (patchset as of December 2003) • Oracle9i Database Release 2: 126.96.36.199–188.8.131.52 (patchset as of April 2007) • Oracle Database 10g Release 1: 10.1.0.2–10.1.0.5 (patchset as of February 2006) • Oracle Database 10g Release 2: 10.2.0.1–10.2.0.5 (patchset as of April 2010) • Oracle Database 11g Release 1: 184.108.40.206–220.127.116.11 (patchset as of September 2008) • Oracle Database 11g Release 2: 18.104.22.168–22.214.171.124 (patchset as of August 2013) • Oracle Database 12c Release 1: 126.96.36.199 (patchset as of June 2013) • Oracle Database 12c Release 1: 188.8.131.52 (patchset as of July 2014) • Oracle Database 12c Release 2: 184.108.40.206 (patchset as of March 2017)
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.
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
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
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
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
Dynamic List • Base list on SQL or PL/SQL functions • Dynamically create styled list items • Especially important for mobile based applications
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
Database Software Conclusion • while working with Oracle, you learned how to adjust the SQL*Plus 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 SQL*Plus • Distinguish between standard SQL and Oracle's SQL extensions and describe when to use each Oracle Database 11g SQL