1 / 14

Oracle training - Oracle Training in Chennai - Best Oracle training In Chennai

Rated as No 1 Oracle training institute in Chennai for certification and Assured Placements. Our Job Oriented Oracle training in chennai courses are taught by experienced certified professionals with extensive real-world experience. All our Best Oracle training in Chennai focuses on practical than theory model.

Heera
Download Presentation

Oracle training - Oracle Training in Chennai - Best Oracle training In Chennai

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. www.greenstechnology.com ORACLE

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

  3. Oracle Databaseoverview

  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 (20’s) • Oracle8i Database Release 3: 8.1.7.0–8.1.7.4 (patchset as of August 2000) • Oracle9i Database Release 1: 9.0.1.0–9.0.1.5 (patchset as of December 2003) • Oracle9i Database Release 2: 9.2.0.1–9.2.0.8 (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: 11.1.0.6–11.1.0.7 (patchset as of September 2008) • Oracle Database 11g Release 2: 11.2.0.1–11.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 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

  14. Thank you

More Related