ROUND (dates) is one of the vital Date/Time functions of Oracle. It is used to get a date rounded to a specific unit of measure. The ROUND (dates) function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: ROUND ( date, format … Read more

SELF JOIN The Oracle SELF Join query is used to join a table with itself, i,e, each row is combined with itself and every other rows of the table. Syntax: SELECT A.columns, B.columns FROM table_1 A, table_1 B WHERE A.common_filed = B.common_field; Example: Students Table: STUDENT_ID STUDENT_NAME STUDENT_AGE 1 Joy 20 2 Smiley 19 3 … Read more

SUM is one of the vital Numeric/Math functions of Oracle. It is used to get the SUM of an expression. The SUM function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax 1: To calculate simple SUM. SELECT SUM (aggregate_expression) FROM tables … Read more

ORACLE FUNCTION: A function in Oracle can be simply understood as a subprogram. It is mainly used to return a single value. There are mainly three subprocesses for a function to execute successfully: Declaration, Definition and Calling. The declaration and definition processes of a function must be done before invoking it. A function can be … Read more

ORACLE FROM Oracle FROM clause is used with the Oracle SELECT statement and has a mandatory existence, as it is used to specify the tables from which the desired data needs to be retrieved. Syntax: To select all fields from a table. SELECT * FROM table_name; Parameters: table_name: It is used to specify the name … Read more

ORACLE ENABLE TRIGGER As the name itself suggests, this type of trigger is used to ENABLE an already existing or newly created trigger for a table from the database. To serve this purpose ALTER TRIGGER statement is used. Syntax: ALTER TRIGGER trigger_name ENABLE; Parameters: trigger_name: It is used to specify the name of the trigger … Read more

ORACLE DROP TRIGGER As the name itself suggests, the Oracle database will fire this trigger to drop a trigger or in simple words the Oracle DROP Trigger is used to remove an already existing trigger from the database. Syntax: DROP TRIGGER trigger_name; Parameters: trigger_name: It is used to specify the name of the trigger to … Read more

ORACLE DISTINCT To eliminate the duplicate records from the result set, Oracle DISTINCT clause is used, but only with the SELECT statement. Syntax: SELECT DISTINCT columns FROM tables WHERE conditions; Parameters: columns: It is used to specify the columns to be selected. table_name: It is used to specify the name of the table from which … Read more

ORACLE DISABLE TRIGGER As the name itself suggests, this type of trigger is used to disable an already existing or newly created trigger for a table from the database. To serve this purpose ALTER TRIGGER statement is used. Syntax: ALTER TRIGGER trigger_name DISABLE; Parameters: trigger_name: It is used to specify the name of the trigger … Read more

ORACLE DELETE To remove or delete a single record or multiple records from a table, Oracle DELETE statement is used. Syntax: To delete all rows from a table. DELETE FROM table_name Syntax: To delete specific rows from a table. DELETE FROM table_name WHERE conditions; Parameters: table_name: It is used to specify the name of the … Read more