SQL and PLSQL

Oracle CURSOR with parameter

Oracle CURSOR with parameter.Execution of a cursor puts the results of the query into a set of rows called the result set, which can be fetched sequentially or non sequentially.

Click the title or visit http://plsql.globinch.com/ to read more..

ORA-01001: invalid cursor

ORA-01001: invalid cursor error occurs when you tried to reference a cursor that does not yet exist. A few scenarios given below.

Click the title or visit http://plsql.globinch.com/ to read more..

Oracle Cursors | OPEN ,FETCH and CLOSE Cursor statements.

A cursor is a name for private SQL area.It is in private SQL area the parsed statement and other information for processing the statement are kept.

Click the title or visit http://plsql.globinch.com/ to read more..

ORA-01000: maximum open cursors exceeded.

ORA-01000: maximum open cursors exceeded.Each user session can open multiple cursors up to the limit set by the initialization parameter OPEN_CURSORS.

Click the title or visit http://plsql.globinch.com/ to read more..

Cursor | Oracle PL/SQL Cursors and example.

A cursor is a name for private SQL area.It is in private SQL area where the parsed statement and other information for processing the statement are kept.

Click the title or visit http://plsql.globinch.com/ to read more..

Oracle ‘ALTER TABLE’ to ADD columns

We can use the 'ALTER TABLE' statement in oracle to add columns to a table using ADD keyword.

Click the title or visit http://plsql.globinch.com/ to read more..

CREATE INDEX as part of CREATE TABLE statement.

CREATE INDEX statement is used to create Indexes using table columns.An index allows faster retrieval of records.It is mainly used as a performance-tuning method.An index creates an entry for each...

Click the title or visit http://plsql.globinch.com/ to read more..

Oracle Tables: Create Table as Select

CREATE TABLE AS SELECT statement can be used when we need to extract part or full data from a table and store it into another table based on certain conditions .

Click the title or visit http://plsql.globinch.com/ to read more..

Oracle Tables: Create table with foreign key constraint

Usage Create table statement with foreign key constraint will create table with referential integrity. Foreign Key holds the reference to another table column value.

Click the title or visit http://plsql.globinch.com/ to read more..

‘CREATE TABLE’ : create table with composite primary key

'CREATE TABLE' : sql create table command with composite primary key.CREATE TABLE statement can be used to create table objects in database. It is possible to add constraints like primary key...

Click the title or visit http://plsql.globinch.com/ to read more..