Delete
|
Drop
|
(i)
The DELETE command is used to remove rows from a table.
|
(i)
The DROP command removes a table from the database.
|
(ii)
Delete statement performs conditional based deletion.
|
(ii)
Drop command deletes entire records in the table.
|
(iii)
Delete is a DLM statement.
|
(iii)
Drop is a DDL command.
|
(iv)
Delete operation can be rolled back and it is not auto committed.
|
(iv)
Drop operation cannot be rolled back in any way as it is an auto committed
statement.
|
(v)
They require segments in the UNDD table space.
|
(v)
They do not require segments in the UNDO table space.
|
(vi)
It can activate the triggers.
|
(vi)
It does not activate the triggers.
|
(vii)
The syntax for Delete statement:
DELETE
FROM <table_name>
or,
DELETE
FROM <table_name>
WHERE
<condition>
|
(vii)
The syntax for Drop command DROP TABLE <table_name>
|
11 March 2018
Differentiate between 'delete' arid 'drop'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment