sql

What is connect by level in oracle Level is nothing but it’s a Pseudocolumn column in oracle which is used in a hierarchical query to identify the hierarchy level (parent->child) in numeric format. How to Print 1 to 10 in a SQL Query : Here is simple query to print 1 to 10 in sql […]

Oracle PL/SQL Cursor: Implicit, Explicit, Cursor FOR Loop What is CURSOR in PL/SQL? A Cursor is a pointer to this context area. Oracle creates context area for processing an SQL statement which contains all information about the statement. PL/SQL allows the programmer to control the context area through the cursor. A cursor holds the rows