Subscribe SQL & PLSQL Tips via email
Globinch is a Technology Blog .More
| Search Globinch plsql world: |
-
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... -
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... -
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... -
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... -
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... -
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... -
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... -
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... -
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...
-
Functions
Oracle Decode Function | Use PLSQL DECODE function to handle NULL and default values
3 Comments -
Functions
SQL: MAX Function | Oracle Max() examples
2 Comments -
Functions
SQL GROUP BY Statement | Oracle GROUP BY Clause examples
2 Comments -
Functions
NVL | Oracle/PLSQL: NVL Function
No Comments -
Functions
Oracle SUBSTR functions | Oracle/PLSQL: Substr() Function
No Comments -
Functions
Oracle/PLSQL: Instr Function |INSTR functions |Case sensitive search
1 Comment -
Error Codes
Oracle pl/sql error: ORA-06502: PL/SQL: numeric or value error:
1 Comment -
Error Codes
Oracle pl/sql error: ORA-06512
No Comments -
Error Codes
ORA-12154: TNS:could not resolve the connect identifier specified
No Comments -
Oracle
Oracle timestamp format milliseconds| Oracle Date format
1 Comment