Globinch - plsql.globinch.com - SQL and PLSQL
General Information:
Latest News:
Oracle CURSOR with parameter 3 Feb 2009 | 02:02 am
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. You can create Cursors which accepts parameters at...
ORA-01001: invalid cursor 3 Feb 2009 | 01:56 am
ORA-01001: invalid cursor error occurs when you tried to reference a cursor that does not yet exist. A few scenarios given below. 1. FETCH cursor before opening the cursor. 2. CLOSE cursor before o...
Oracle Cursors | OPEN ,FETCH and CLOSE Cursor statements. 3 Feb 2009 | 01:49 am
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. Execution of a cursor puts the results of the query...
ORA-01000: maximum open cursors exceeded. 3 Feb 2009 | 01:38 am
Each user session can open multiple cursors up to the limit set by the initialization parameter OPEN_CURSORS. If the number of open cursors exceeds this limit,oracle will throw the ‘ORA-01000: maximu...
Cursor | Oracle PL/SQL Cursors and example. 3 Feb 2009 | 01:32 am
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. Execution of a cursor puts the results of the...
Oracle ‘ALTER TABLE’ to ADD columns 14 Jan 2009 | 12:36 am
We can use the ‘ALTER TABLE‘ statement in oracle to add columns to a table using ADD keyword. It is fairly straight forward. We can specify column details and constraints if any, See the below exam...
CREATE INDEX as part of CREATE TABLE statement. 12 Jan 2009 | 11:25 pm
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 val...
Oracle Tables: Create Table as Select 9 Jan 2009 | 11:41 pm
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 . We can create a table based on a quer...
Oracle Tables: Create table with foreign key constraint 9 Jan 2009 | 11:40 pm
Usage Create table statement with foreign key constraint will create table with referential integrity. Foreign Key holds the reference to another table column value.It is also known as references con...
‘CREATE TABLE’ : create table with composite primary key 9 Jan 2009 | 11:38 pm
CREATE TABLE statement can be used to create table objects in database. It is possible to add constraints like primary key ,foreign key while table creation.Primary key is the unique identifier for a ...
