Blogs

FOREIGN KEY Constraint in Oracle

FOREIGN KEY Constraint in Oracle FOREIGN KEY is a referential integrity constraint.It establishes a relationship… Read More

PRIMARY KEY Constraint in Oracle

PRIMARY KEY Constraint in Oracle The PRIMARY KEY enforces the uniqueness in table.PRIMARY KEY can… Read More

UNIQUE Constraint in Oracle

UNIQUE Constraint in Oracle An UNIQUE constraint specified that a column or a group of… Read More

NOT NULL Constraint in Oracle

NOT NULL Constraint in Oracle Constraints in Oracle Constraints allows Oracle to set some rule… Read More

TRUNCATE Table Statement

TRUNCATE Table Statement TRUNCATE table statement is used to remove all the records permanently.Its a… Read More

DROP Table Statement in Oracle

DROP Table Statement in Oracle DROP statement is used to do below operations: DROP ONE… Read More

MODIFY Table Statement in Oracle

MODIFY Table Statement in Oracle MODIFY statement is used to do below operations: MODIFY ONE… Read More

ALTER Table Statement in Oracle

ALTER Table Statement in Oracle ALTER statement is used to do below operations: ADD ONE… Read More

CREATE Statement in Oracle

CREATE Statement in Oracle CREATE statement is used to create a new database object. Its… Read More

Working with Stored Procedure Parameters

Working with Stored Procedure Parameters WORKING WITH DATE AS INPUT PARAMETERWORKING WITH CHARACTER AS INPUT… Read More