Curriculum
Course: The Complete PLSQL Bootcamp (Beginners t...
Login

Curriculum

The Complete PLSQL Bootcamp (Beginners to Advanced)

Introduction

0/1

Declaring PLSQL Variables

0/11

Installation

0/9

Writing Executable Statements

0/5

Writing Executable Statements

0/5

Writing Control Structures

0/6

Iterative processing with loops

0/6

Creating Procedures

0/3

Using Cursors

0/9

Handling Exceptions

0/3

Creating Procedures

0/3

Creating Functions

0/1

Creating Packages

0/2

Creating Triggers

0/8
Text lesson

What are Bind Variables?

Example :

set serveroutput on

VARIABLE X NUMBER;

BEGIN
:X:=11;
DBMS_OUTPUT.PUT_LINE(:X);
END;
/

DECLARE
X NUMBER:=1;
BEGIN
DBMS_OUTPUT.PUT_LINE(X);
END;
/

Next
Live Courses