Collection of articles about Oracle db
- Adding a leading dollar sign ($) in front of a number in Oracle
- Changing case in Oracle
- Concatenation is Oracle
- Limit clause in oracle
- Listing objects in Oracle
- Listing tables, views, procedures, indices, packages, sequences, synonyms, triggers in Oracle
- Oracle comparing years in dates
- Oracle decode function
- Oracle extract function
- Oracle NVL function
- Oracle NVL2 function
- Oracle set operators: union, intersect, minus
- Oracle subtring - substr function
- Testing inequality in oracle
- ORA-00979 - Not a group by expression
- ORA-01858: a non-numeric character was found where a numeric was expected