Functions Archive

• 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...

  Read More

• 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...

  Read More

• Oracle PL/SQL: To_Timestamp Function | Datetime Format Models

  To_timestamp method in oracle is used with string (varchar2 or similar) or character sequences to convert it into timestamp...

  Read More

• Oracle to_char function and usage

  A to_char function is useful while displaying oracle date value to a required string format.This is particularly...

  Read More

• PL/SQL EXTRACT function for oracle datetime

  The EXTRACT function extracts and returns the value of a specified datetime field from a datetime.It can also be...

  Read More

• Oracle Dates and Times |SYSDATE|CURRENT_TIMESTAMP |SYSTIMESTAMP |DBTIMEZONE |LOCALTIMESTAMP

  The DATE type is stored in a special internal format that includes not just the month, day, and year,...

  Read More

• oracle to_date | Oracle/PLSQL: To_Date Function

  The purpose of TO_DATE in Oracle pl/sql is to convert char of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type...

  Read More

• DATE Data type in Oracle|Oracle Dates and Times|Dates in OracleDATE Data type in Oracle|Oracle Dates and Times|Dates in Oracle

  In Oracle Date data is stored in fixed-length fields of seven bytes each, corresponding to century, year, month, day,...

  Read More

• Formatting date in SQL (Oracle) -Simple date formatting

  Formatting date in SQL (Oracle) -Simple date formatting.Here is few simple SQL date formatting examples that can be useful...

  Read More