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...
Saturday, May 31, 2014
Friday, May 30, 2014
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...
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...
Saturday, May 3, 2014
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...
