ORACLE JOINS To combine rows from multiple tables, the Oracle Join Query is used. It creates a new table as the end result. It is often used to combine data from two or more views, or materialized views. There is however one mandatory condition for using the JOIN Query in Oracle and that is the … Read more
REMAINDER is one of the vital Numeric/Math functions of Oracle. It is used to get the remainder of x divided by y. The REMAINDER function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g and Oracle 10g. Syntax: REMAINDER ( x, y ) Parameters: x, y: They are used to … Read more
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