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
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 expression. Read MIN() function here. Syntax: Examples: (See more example for… 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 the result by certain table column or columns.
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 where we can supply default values when there is a chance of getting null at run time or to provide useful logging messages.
Oracle SUBSTR functions | Oracle/PLSQL: Substr() Function
The oracle SUBSTR functions return a portion of string, beginning at a specified position in the string.This functions allows to extract a substring from a string.To know the position of a string in a string you can use INSTR function.
Oracle/PLSQL: Instr Function |INSTR functions |Case sensitive search
The oracle INSTR function returns the location of a sub string in a string.The search is case sensitive.If the specified string is not found, then the instr Oracle function will return 0.
Oracle pl/sql error: ORA-06502: PL/SQL: numeric or value error:
This error occurs due to an arithmetic, numeric, string, conversion problem.
This normally displayed as ORA-06502: PL/SQL: numeric or value error:This error can happen because of different scenarios.
Oracle pl/sql error: ORA-06512
ORA-06512
This is a Back trace error message.This normally displayed as ORA-06512: at line (linenumber).The below give example is a typical scenario.
ORA-12154: TNS:could not resolve the connect identifier specified
The error ORA-12154: TNS:could not resolve the connect identifier specified occurs when the listener could not resolve SERVICE_NAME specified in the connect descriptor.The common causes of this error explained below.
Oracle timestamp format milliseconds| Oracle Date format
Oracle provide a lot of mechanisms to handle the time and date types.Formatting the date and time objects can be done in different ways.Please read the following articles to know more about timestamp in milliseconds and Date format.