What is a Cursor

A cursor is a temporary  context  area created in the system  when we executes  SQL statements. A cursor contains information on a select statement and the rows of data accessed by it. This temporary work area is used to hold  the data retrieved from the database, and manipulate this data. A cursor can hold more than...

Read More

set serveroutput on

When we execute PL/SQL program  into Oracle engine so we always required to get output result and display into the screen otherwise result can't be display. Whenever we connect Oracle SQL (PL/SQL) at that time you must have to write...

Read More

Differences Between Anonymous Blocks and Subprograms

Normal 0 false false false EN-US X-NONE X-NONE 1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle stores pl/sql block in the...

Read More

Bind Variables

Suppose that you want to be to display the variables you  use in your PL/SQL subprograms in SQL*Plus or you can use the same variables in multiple subprograms. If you declare a variable in a PL/SQL , We  cannot display that variable in SQL*Plus.Use a bind variable in PL/SQL to access the variable from SQL*Plus. Bind variables are variables...

Read More