Oracle Database

• Getting started with Oracle Database
• Awesome Book
• Awesome Community
• Awesome Course
• Awesome Tutorial
• Awesome YouTube
• Anonymous PL/SQL Block
• Autonomous Transactions
• constraints
• Creating a Context
• Data Dictionary
• Data Pump
• Database Links
• Dates
• Changing How SQL/Plus or SQL Developer Display Dates
• Converting Dates to a String
• Date Arithmetic - Difference between Dates in Days, Hours, Minutes and/or Seconds
• Date Arithmetic - Difference between Dates in Months or Years
• Extract the Year, Month, Day, Hour, Minute or Second Components of a Date
• Generating Dates with a Time Component
• Generating Dates with No Time Component
• Getting the Day of the Week
• Leap Seconds
• Setting the Default Date Format Model
• The Format of a Date
• Time Zones and Daylight Savings Time
• Delimiting keywords or special characters
• Different ways to update records
• DUAL table
• Dynamic SQL
• Error logging
• Handling NULL values
• Hierarchical Retrieval With Oracle Database 12C
• Hints
• Indexes
• JOINS
• level query
• Limiting the rows returned by a query (Pagination)
• Oracle Advanced Queuing (AQ)
• Oracle MAF
• Real Application Security
• Recursive Sub-Query Factoring using the WITH Clause (A.K.A. Common Table Expressions)
• Sequences
• Splitting Delimited Strings
• Statistical functions
• String Manipulation
• Table partitioning
• Update with Joins
• Window Functions
• Working with Dates