Oracle Archive

• Oracle CURSOR with parameter

  Oracle CURSOR with parameter.Execution of a cursor puts the results of the query into a set of rows called...

  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...

  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...

  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...

  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...

  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.  

  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...

  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...

  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...

  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...

  Read More