Let us Learn Oracle
Since sometime I was thinking to start a series of article on Oracle, but because of time constraint I was not able to do so. But atlast I have decided to take it up seriously and henceforth starting this new series of Oracle.
In this series(an N-Part series) we will learn the new Oracle features that came till 11g , various functions, PL-Sql stuffs adroned with many examples.
This is a N-Part series and will go on for a long time. This series will not cover those Oracle functions which are precisely similar to Sql Functions but will list those common function names
Also wherever possible, we will see for a particular Oracle function the equivalent of that in Sql Server.
Initial Set Up
We need to have minimum Oracle 10g (preferred 11g though it's appearence will come later) for our learning.
Also we will work upon certain tables for our demonstration purpose.Henceforth, the table creation script will be listed at the down. As and when needed, we will kepp on adding more tables for our demonstration purpose.
We will have two version of the table scripts - one for Oracle and the other for Sql Server. We will refer to those tables at the time of learning/experiment.
The article is categorized in the following series(The series will grow don't worry)
- Sql predefined functions and statements/clause
- Sql Functions
- String Functions
- Date Functions
- Aggregate Functions
- Analytical Functions
- Regular Expression Functions
- Sql Statements
- With Clause
- Model clause
- PL/Sql Section
- What is PL/SQL
- IF/IF..Else block
Thanks for reading