










Description
######## 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 Dierent 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