Subscribe SQL & PLSQL Tips via email
Globinch is a Technology Blog .More
| Search Globinch plsql world: |
-
Oracle CURSOR with parameter
Oracle CURSOR with parameter.Execution of a cursor puts the results of the query into a set of rows called... -
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... -
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... -
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... -
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... -
Oracle ‘ALTER TABLE’ to ADD columns
We can use the ‘ALTER TABLE’ statement in oracle to add columns to a table using ADD keyword. -
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... -
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... -
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... -
‘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...
-
Oracle
Autonomous Transactions in PL/SQL -Autonomous Transactions
2 Comments
-
Cursors
Oracle CURSOR with parameter
1 Comment -
Cursors
ORA-01001: invalid cursor
2 Comments -
Cursors
Oracle Cursors | OPEN ,FETCH and CLOSE Cursor statements.
1 Comment -
Cursors
ORA-01000: maximum open cursors exceeded.
3 Comments -
Cursors
Cursor | Oracle PL/SQL Cursors and example.
6 Comments -
Fundamentals
Oracle ‘ALTER TABLE’ to ADD columns
2 Comments -
Constraints
CREATE INDEX as part of CREATE TABLE statement.
2 Comments -
Fundamentals
Oracle Tables: Create Table as Select
1 Comment -
Constraints
Oracle Tables: Create table with foreign key constraint
2 Comments -
Fundamentals
‘CREATE TABLE’ : create table with composite primary key
1 Comment