What is a Cursor

A cursor is a temporary  context  area created in the system  when we executes  SQLstatements.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, andmanipulate this data. A cursor can hold more than one row, but...

Read More

set serveroutput on

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

Read More

Differences Between Anonymous Blocks and Subprograms

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

Read More

Bind Variables & Associative arrays

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