Oracle DISTINCT Clause Oracle DISTINCT clause is used to remove the duplicate records from the result set. It is only used with…
Oracle Tutorial
-
-
ORACLE IS NOT NULL In oracle, IS NOT NULL is used to check not null values. It is used with select, insert,…
-
Oracle After INSERT/UPDATE/DELETE Trigger This statement specifies that Oracle will fire this trigger AFTER the INSERT/UPDATE or DELETE operation is executed. Syntax…
-
Oracle DROP TABLE Statement Oracle DROP TABLE statement is used to remove or delete a table from the Oracle database. Syntax DROP…
-
ORACLE NULL In oracle, IS NULL is used to check not null values. It is used with select, insert, update, and delete…
-
ORACLE ALIASES In Oracle, aliasing can also be done in column name as well as in table name. Aliasing is done to…
-
Oracle DROP Trigger In Oracle, DROP TRIGGER statement is used to drop the trigger if you find that you need to remove…
-
Oracle Joins Join is a query that is used to combine rows from two or more tables, views, or materialized views. It…
-
Oracle ALTER TABLE Statement In Oracle, ALTER TABLE statement specifies how to add, modify, drop or delete columns in a table. It…
-
Oracle ENABLE Trigger The ALTER TRIGGER statement is used to enable a trigger. Syntax ALTER TRIGGER trigger_name ENABLE; Parameters trigger_name: It specifies…