Category: PL/SQL
Total: 32 Posts
Posts of Category: PL/SQL
  1. PL/SQL Cursors

    PL/SQL Cursors Whenever you try to execute an SQL statement, Oracle processes it in a separate memory zone called as ‘Context Area’. It contains information regarding information retrieved from database tables...Learn More
    PL/SQLCursors
  2. PL/SQL Operators

    **PL/SQL Operators** In the previous tutorials, we have learnt about the variables in PL/SQL. In almost every programming language, we need to do mathematical calculations and other such related operations. To...Learn More
    PL/SQL
  3. Introduction to PL/SQL Programming

    **Introduction to PL/SQL Programming** PL/SQL Basics – Introduction to PL/SQL Programming PL/SQL stands for Procedural Language/Structured Query Language. It is an extension of Structured Query Language (...Learn More
    PL/SQLProgramming
  4. PL/SQL Data Types

    **PL/SQL Data Types** In the previous tutorial, you learnt about how to write and run Hello World program in PL/SQL programming language. In this tutorial you will learn about various data types used in PL/SQL...Learn More
    PL/SQL
  5. PL/SQL Program to Check Number is Odd or Even

    PL/SQL Program to Check Number is Odd or Even Here you will get pl/sql program to check number is odd or even. A number is even if it is completely divisible by 2 otherwise it is odd. PL/SQL Program to Check Nu...Learn More
    PL/SQL
  6. PL/SQL Program to Find Factorial of a Number

    PL/SQL Program to Find Factorial of a Number Here you will get pl/sql program to find factorial of a number. We can calculate factorial of a number by multiplying it with all the numbers below it. For example f...Learn More
    PL/SQL
  7. PL/SQL Program To Add Two Numbers

    PL/SQL Program To Add Two Numbers In the previous tutorial we have learnt much about PL/SQL variables, operators, data types and other such fundamental topics. Let us get into real programming now onwards. For...Learn More
    PL/SQL
  8. PL/SQL Program to Reverse a String

    PL/SQL Program to Reverse a String Here you will get pl/sql program to reverse a string. The substr() function returns a part of string. It has following syntax. substr(string, position, length); We will use th...Learn More
    PL/SQLString
  9. Pl/SQL Program for Palindrome Number

    Pl/SQL Program for Palindrome Number Here you will get pl/sql program for palindrome number. A number is called palindrome number if its reverse is equal to itself. For example 12321 is palindrome while 123 is ...Learn More
    PL/SQL
  10. PL/SQL Program to Swap two Numbers

    PL/SQL Program to Swap two Numbers Here you will get pl/sql program to swap two numbers with and without using temporary variable. Method 1: Using Temporary Variable declare a number; b number; ...Learn More
    PL/SQL
  11. PL/SQL Program for Armstrong Number

    PL/SQL Program for Armstrong Number Here you will get pl/sql program for armstrong number. A number is said to be an armstrong number if sum of its digits raised to the power n is equal to number itself, w...Learn More
    PL/SQL
  12. PL/SQL Procedure

    PL/SQL Procedure A subprogram is a module or a small unit/part of a program that performs a particular task. In modular programming, a program can optionally consist of multiple subprograms. Note: A schema le...Learn More
    PL/SQLProcedure