Oracle is the most widely used Database Management System in current world. Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a proprietary multi-model database management system produced and marketed by Oracle Corporation.
Happy Reading and Learning Through Examples!
Articles
- 1 Oracle SQL Basics
- 2 Parts of Oracle SQL Query
- 3 Oracle Functions
- 3.1 Functions Overview
- 3.1.1 Single Row Functions
- 3.1.1.1 Character Functions
- Character Functions: UPPER, LOWER, INITCAP
- Character Functions: LENGTH, CONCAT
- Character Functions: SUBSTR, INSTR
- Character Functions: LTRIM, RTRIM, TRIM
- Character Functions: LPAD, RPAD
- Character Functions: REPLACE, TRANSLATE
- Character Functions: CHR, ASCII, SOUNDEX
- 3.1.1.2 Number Functions
- 3.1.1.3 DATE and TIME FUNCTION
- 3.1.1.4 CONVERSION FUNCTION
- 3.1.2 Multiple Row Functions
- 3.1.3 Hierarchical Functions
- 3.1.4 Analytical Functions
- 4 Joins in Oracle
- 5 Subqueries In Oracle
- 6 SET Operators
- 7 Pseudo Columns
- 8 Hierarchical Query
- 9 Constraints
- 10 Sequences
- 11 Views
- 12 Indexes in Oracle