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:-

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;
 /

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