Best websites for learning PL SQL

Hello friends, I had written some post related to PL SQL but due to my low configuration laptop, I wasn't able to write any more post. But I am creating a note on PL/SQL topic and It will available as PDF. So I am listing some websites where you can continue learn about PL/SQL.

Data Retrieval statement using PL/SQL

Today we will know how to retrive data from Oracle database using PL/SQL.PL/SQL provide three ways to extract data from Oracle database.These ways are as follow:-

Select and Loop Control Statement in Oracle Pl SQL

Hi friends,today we will learn about Select statement in Pl Sql.It is second part of control statement.
we will also discus Loop statement in Pl Sql.Let's start..

What is select control statement in Pl Sql:

It provide selection strategy in PL Sql.This is achieve by CASE statement.There are two types of selection statement

Control Structure in PL/Sql

   

  Hi friends,today i will tell you about Control Structure in Pl/Sql.So first question come into mind is "what is Control Structure".So below is the answer-

   'Control structure' enable us to specify the order in which the various instruction in a program are to be executed by the computer.In other word,the control structure determine the 'flow of control'in a program.

5 basic Plsql programs till operators

Hi friends today i will show before you some plsql programs.After two post about plsql it is neccessary to see some programs example. I hope you will like it.

5 basic plsql programs:-

Q1.Write a PL/SQL code that display "Hello World" on the Screen.

1) begin
    dbms_output.put_line('Hello world');
 end;
 /

Operators in pl sql

Hi friends,today will discuss Operators in plsql.So first thing what is Operators.

Definition of Operator :

in computer programming, an operator is a character that represents an action, as for example x is an arithmetic operator that represents multiplication.* is an arithmetic operation in plsql.

PL/SQL Free tutorial:The Ultimate Guide To Introduction Of Pl/sql

Introduction Of plsql

PL/SQL stands for Procedural Language extension for SQL.It was developed to extend the feature and security of SQL.This language was developed by Oracle Corporation in the late 1980s.
In this  PL SQL tutorial, we will learn basic structure and features of  PL SQL.

 It has many Notable facts:

plsql Client Server Architecture