SQL Tips Archive

• Oracle CURSOR with parameter

  Oracle CURSOR with parameter.Execution of a cursor puts the results of the query into a set of rows called...

  Read More

• ORA-02291: integrity constraint violated – parent key not found

  ORA-02291: integrity constraint violated – parent key not found error occurs when we try to insert a row in...

  Read More

• COUNT() Function in SQL ,Using COUNT(*) and COUNT(1)

  The COUNT() function returns the number of records in a tables based on sql query. The COUNT function will only...

  Read More

• ‘ORDER BY’ clause in SQL | Using SQL order by

  The keyword ‘ORDER BY’ clause used in SQL to order the data sets retrieved from a SQL database. The sorting...

  Read More

• Oracle Max(Date) function usage-SQL max date

  Max() function in sql can be used to get maximum value of two or more dates.Max(Date) function is useful...

  Read More

• Oracle Trim Function | PL/SQL TRIM() Function.

  TRIM function removes all specified characters from the beginning of a string or from the ending of a string.  

  Read More

• Oracle Decode Function | Use PLSQL DECODE function to handle NULL and default values

  Oracle Decode Function | Use PLSQL DECODE function to handle NULL and default values  

  Read More

• SQL: MAX Function | Oracle Max() examples

  The Max() function is another much helpful function in SQL, the MAX function returns the maximum value of an...

  Read More

• SQL GROUP BY Statement | Oracle GROUP BY Clause examples

  The GROUP BY statement is used in conjunction with the aggregate functions like SUM to provide means of grouping...

  Read More

• NVL | Oracle/PLSQL: NVL Function

  NVL function is used to substitute a value when a null value is encountered.This is useful in PL/SQL programming...

  Read More