fetch record from cursor in SQL

fetch record from cursor in SQL

References

Reference NO 1

http://technet.microsoft.com/en-us/library/ms180152.aspx

Reference NO 2

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.apdv.plsql.doc/doc/c0053889.html

Reference NO 3

http://stackoverflow.com/questions/15195364/fetch-record-from-cursor-in-sql

Reference NO 4

http://plsql-tutorial.com/plsql-explicit-cursors.htm

Reference NO 5

http://ss64.com/oraplsql/cursor_fetch_close.html

Reference NO 6

http://www.java2s.com/Tutorial/Oracle/0500__Cursor/PopulatingaRecordwithFETCHINTO.htm

Reference NO 7

http://blog.sqlauthority.com/2006/11/30/sql-server-cursor-to-process-tables-in-database-with-static-prefix-and-date-created/

Reference NO 8

http://docs.oracle.com/cd/B12037_01/appdev.101/b10807/13_elems020.htm