ORACLE ORDER BY Oracle ORDER BY clause is used with the Oracle SELECT statement, however, it does not have a mandatory existence but still is important enough, as it is used to sort or re-arrange the records in the result set. Syntax: SELECT expressions FROM table_name WHERE conditions; ORDER BY expression [ ASC | DESC … Read more
ORACLE MINUS To return all the rows of the first SELECT statement which are not common to the rows of the second SELECT statement, the Oracle MINUS operator is used. After the subtraction process, the MINUS operator returns the uncommon or unique records from the corresponding rows of the first SELECT statement. There are however … Read more
ORACLE GROUP BY Oracle GROUP BY clause is used with the Oracle SELECT statement, however, it does not have a mandatory existence but still is important enough, as it is used to collect data from multiple records and then to group the results by one or more columns. Syntax: To group the rows by values … Read more
ORACLE INSERT To insert a single record or multiple records into a table the Oracle INSERT statement is used. Oracle INSERT by using the VALUE keyword: Inserting elements to the Oracle database by using the VALUE keyword is the simplest way of insertion in Oracle. Syntax: INSERT into table_name(column_1, column_2, … column_n ) VALUES(value1, value2, … Read more
ORACLE INSERT ALL To insert multiple rows, the Oracle INSERT ALL statement is used. A single INSERT statement, as a SQL command thus can insert the rows into one table or multiple tables. Syntax: INSERT ALL INTO table_name (column_1, column_2, column_n) VALUES (expression_1, expression_2, … expression_n) INTO table_name(column_1, column_2, column_n) VALUES (expression_1, expression_2, … expression_n) … Read more
ORACLE HAVING Oracle HAVING clause is used with the Oracle GROUP BY Clause, however, it does not have a mandatory existence but still is important enough, as it is used to return the groups of rows only when the condition is TRUE. Syntax: To group the rows by values in multiple columns. SELECT expressions FROM … Read more
COSH is one of the vital Numeric/Math functions of Oracle. It is used to get the hyperbolic cosine of a number. The COSH function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: COSH ( number ) Parameters: number: It is used … Read more
ORACLE TRIGGER The database TRIGGERS are the procedures defined in the Oracle. When an INSERT, UPDATE or DELETE statement is issued these triggers can be implicitly executed. On the basis of the Firing Points, six CREATE TRIGGER statements can be defined. BEFORE — Firing Point: BEFORE INSERT TRIGGER BEFORE UPDATE TRIGGER BEFORE DELETE TRIGGER … Read more
RAWTOHEX is one of the vital Conversion functions of Oracle. It is used to convert a raw value to a hexadecimal value. The RAWTOHEX function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: RAWTOHEX ( raw ) Parameters: raw: It is … Read more
RANK is one of the vital Analytic functions of Oracle. It is used to get the rank of a value in a group of values. It can also result in the non-consecutive ranking of the rows. The RANK function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g … Read more