Cursor In Oracle .What is Cursor?
it is a pointer to this context area. Oracle creates context area for processing an SQL statement which contains all information about the statement.
Cursors In Pl Sql What is a cursor in OracleA cursor is a pointer to the private memory area allocated by the Oracle server.There are two types of cursors:Implicit: C…Read More
Merging RowsMerging RowsIn Oracle The MERGE statement inserts or updates rows in one table by using data from another table. Each row is inserted or updated in th…Read More
Basic Pl sql1 Views 2.Conversion_Functions3.Bind Variables4.Constraints4 Exit Loop…Read More
Statement Level Trigger Statement Triggers A statement triggers is fired once on behalf of the triggering statement, in spite of of the number of rows in the table that the…Read More
set serveroutput on PL/SQL is a block always required to server output result is to be show on the screen otherwise output will not display .Whenev…Read More
0 comments:
Post a Comment