Oracle Apps Technical is a collection of a bunch of collected applications like accounts payables, purchasing, inventory, accounts receivables, human resources, order management, general ledger and fixed assets, etc which have its own functionality for serving the business.
Introduction to Oracle Database
Retrieve Data using the SQL SELECT Statement
Learn to Restrict and Sort Data
Usage of Single-Row Functions to Customize Output
Invoke Conversion Functions and Conditional Expressions
Aggregate Data Using the Group Functions
Display Data from Multiple Tables Using Joins
Use Sub-queries to Solve Queries
The SET Operators
Data Manipulation Statements
Use of DDL Statements to Create and Manage Tables
Other Schema Objects
Control User Access
Management of Schema Object
Manage Objects with Data Dictionary Views
Manipulate Large Data Sets
Data Management in Different Time Zones
Retrieve Data Using Sub-queries
Regular Expression Support
Introduction
Introduction to PL/SQL
PL/SQL Identifiers
Write Executable Statements
Interaction with the Oracle Server
Control Structures
Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures and Functions
Create Stored Procedures
Create Stored Functions
Create Packages
Packages
Implement Oracle-Supplied Packages in Application Development
Dynamic SQL
Design Considerations for PL/SQL Code
Triggers
Create Compound, DDL, and Event Database Triggers
The PL/SQL Compiler
Manage PL/SQL Code
Manage Dependencies
Powered by Froala Editor
Access your courses anywhere, anytime & prepare with practice tests