Category: Oracle PL SQL

Sample Table Creation Insertion and Display Data  – Learn how to create tables, insert data into tables and display data with the following examples. Sample

PL-SQL Arrays – Learn how to declare  and initialize the values to array with some example programs. PL-SQL Arrays An array in PL-SQL is Varray. A

PL-SQL-Strings- Learn how to declare string variables and initialization of values into them. PL-SQL-Strings A string is a collection of characters with in a single

ORACLE DATA TYPES – Learn about data types classification and their usages with full explanation. ORACLE DATA TYPES This  are built-in(Predefined) data Types. They categorize

ORACLE-VIEWS-Learn about features of oracle views ,how to create view, and how to perform insert,update,delete operations on views with super simple explanation with examples. ORACLE-VIEWS

ORACLE-INDEX- Learn about different types of index available  in oracle and how to create index ,rename index and drop index. ORACLE-INDEX Index sorts the data

Learn PL/SQL functions with simple explanation with examples. PL-SQL-Functions A FUNCTION is a named PL-SQL block that may or may not take a values as

PL-SQL-Procedures Learn procedures in PL-Sql with simple explanation with examples. PLSQL PROCEDURES Procedure is a PL/SQL block/group of statements that can be called by name.

PL/SQL Case Statement -Learn use of case statements in pl-sql programming with simple explanation and example. PL/SQL Case Statement CASE Statement similar to SWITCH statement

Learn PL/SQL Loops used in Oracle viz Basic Loop or Simple Loop| For Loop | WHILE Loop| Nested loops with examples. PL/SQL Loops or PL/SQL