-
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 error occurs when you tried to reference a cursor that does not yet exist.
A few scenarios...
Read More
-
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.Each user session can open multiple cursors up to the limit set by the initialization...
Read More
-
A cursor is a name for private SQL area.It is in private SQL area where the parsed statement and...
Read More
-
We can use the ‘ALTER TABLE’ statement in oracle to add columns to a table using ADD keyword.
Read More
-
CREATE INDEX statement is used to create Indexes using table columns.An index allows faster retrieval of records.It is mainly...
Read More
-
CREATE TABLE AS SELECT statement can be used when we need to extract part or full data from a...
Read More
-
Usage Create table statement with foreign key constraint will create table with referential integrity.
Foreign Key holds the reference to...
Read More
-
‘CREATE TABLE’ : sql create table command with composite primary key.CREATE TABLE statement can be used to create table...
Read More