Posts in: SQL Functions
SQL Functions
Explore the different categories of SQL functions available in Oracle for string manipulation, numbers, dates, and type conversions.
Read More →String Functions
Learn to manipulate string data using built-in functions such as CONCAT, SUBSTR, INSTR, LENGTH, and UPPER.
Read More →Number Functions
Use number functions like ROUND, TRUNC, MOD, CEIL, and FLOOR to process numeric data in SQL queries.
Read More →Date Functions
Handle dates using SYSDATE, ADD_MONTHS, MONTHS_BETWEEN, and more to calculate and extract time-based information.
Read More →Conversion Functions
Convert data types using TO_CHAR, TO_DATE, TO_NUMBER, and implicit conversions in Oracle SQL.
Read More →