FOREIGN KEY Constraint in Oracle
Table of Contents
PRIMARY KEY Constraint in Oracle
Table of Contents
UNIQUE Constraint in Oracle
Table of Contents
NOT NULL Constraint in Oracle
Table of Contents
TRUNCATE Table Statement
TRUNCATE Table Statement
TRUNCATE table statement is used to remove all the records permanently.
Its a DDL statement, so we do not need to explicitly COMMIT the transaction.
Also a ROLLBACK command does not rolled back the transaction.
SELECT *…
DROP Table Statement in Oracle
Table of Contents
DROP Table Statement in Oracle
DROP statement is used to do below operations:
- DROP ONE OR
MODIFY Table Statement in Oracle
Table of Contents
ALTER Table Statement in Oracle
Table of Contents
CREATE Statement in Oracle
Table of Contents
Working with Stored Procedure Parameters
Table of Contents