Oracle CURSOR with parameter.Execution of a cursor puts the results of the query into a set of rows called the result set, which can be fetched sequentially or non sequentially.
ORA-02291: integrity constraint violated – parent key not found error occurs when we try to insert a row in a child table with a foreign key constraint and the related… Read more »
The COUNT() function returns the number of records in a tables based on sql query.
The COUNT function will only count those records in which the field in the brackets is NOT NULL.
The keyword ‘ORDER BY’ clause used in SQL to order the data sets retrieved from a SQL database.
The sorting of result set can be based on column or columns.
Max() function in sql can be used to get maximum value of two or more dates.Max(Date) function is useful in retrieving the maximum value of date from a record set or column or result set etc.
TRIM function removes all specified characters from the beginning of a string or from the ending of a string.
Oracle Decode Function | Use PLSQL DECODE function to handle NULL and default values
The Max() function is another much helpful function in SQL, the MAX function returns the maximum value of an expression. Read MIN() function here. Syntax: Examples: (See more example for… Read more »
The GROUP BY statement is used in conjunction with the aggregate functions like SUM to provide means of grouping the result by certain table column or columns.
NVL function is used to substitute a value when a null value is encountered.This is useful in PL/SQL programming where we can supply default values when there is a chance of getting null at run time or to provide useful logging messages.