Learn Oracle Database

######## Learn Oracle Database ########

This app contains tutorials and reports for the all who want to learn Oracle Database. They can learn easily from this application.

Following Chapters included in this Application:

#1 Getting started with Oracle Database #2 Getting started with PL/SQL #3 Anonymous PL/SQL Block #4 PL/SQL procedure #5 Data Dictionary #6 Dates #7 Working with Dates #8 DUAL table #9 JOINS #10 Handling NULL values #11 String Manipulation #12 IF-THEN-ELSE Statement #13 Limiting the rows returned by a query (Pagination) #14 Recursive Sub-Query Factoring using the WITH Clause (A.K.A. Common table expressions) #15 Dierent ways to update records #16 Update with Joins #17 Functions #18 Statistical functions #19 Window Functions #20 Creating a Context #21 Splitting Delimited Strings #22 Collections and Records #23 Object Types #24 Loop #25 Cursors #26 Sequences #27 Indexes #28 Hints #29 Packages #30 Exception Handling #31 Error logging #32 Database Links #33 Table partitioning #34 Oracle Advanced Queuing (AQ) #35 constraints #36 Autonomous Transactions #37 Oracle MAF #38 level query #39 Hierarchical Retrieval With Oracle Database 12C #40 Data Pump #41 Bulk collect #42 Real Application Security #43 Assignments model and language #44 Triggers #45 Dynamic SQL