Oracle How-To Guides

Practical Oracle answers with statements you can copy and run.

• How to Convert a String to a Date in Oracle
• How to Format a Date in Oracle
• How to Get the Current Date in Oracle
• How to Truncate a Date in Oracle
• How to Add Days to a Date in Oracle
• How to Calculate a Date Difference in Oracle
• How to Extract Year and Month from a Date
• How to Use NVL in Oracle
• How to Use COALESCE in Oracle
• How to Use DECODE in Oracle
• How to Use CASE WHEN in Oracle
• How to Concatenate Strings in Oracle
• How to Use SUBSTR in Oracle
• How to Use INSTR in Oracle
• How to Use REGEXP_SUBSTR in Oracle
• How to Use REGEXP_LIKE in Oracle
• How to Split a String in Oracle
• How to Use LISTAGG in Oracle
• How to Limit Rows in Oracle
• How to Use ROWNUM in Oracle
• How to Use ROW_NUMBER in Oracle
• How to Rank Rows in Oracle
• How to Use PIVOT in Oracle
• How to Use MERGE in Oracle
• How to Update From a SELECT in Oracle
• How to Insert Multiple Rows in Oracle
• How to Delete Duplicate Rows in Oracle
• How to Use a WITH Clause in Oracle
• How to Create a Table in Oracle
• How to Create a Table as Select in Oracle
• How to Add a Column in Oracle
• How to Create a Sequence in Oracle
• How to List Tables in Oracle
• How to Use CONNECT BY in Oracle
• How to Convert a String to a Number in Oracle