- Sayantan's Blog On Oracle

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

2 years ago

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

2 years ago

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

2 years ago

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

2 years ago

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

2 years ago

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

2 years ago

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

2 years ago

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

2 years ago

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

2 years ago

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

2 years ago

sayan_bappa@yahoo.co.in