How to Check Session Time Zone
SESSIONTIMEZONE While DBTIMEZONE is to check the database time zone, the built-in function SESSIONTIMEZONE is to check the exact time zone in the current session.… Read More »How to Check Session Time Zone
SQL Function
SQL functions are built into Oracle Database and are available for use in various appropriate SQL statements. Do not confuse SQL functions with user-defined functions written in PL/SQL.
If you call a SQL function with an argument of a data type other than the data type expected by the SQL function, then Oracle attempts to convert the argument to the expected data type before performing the SQL function.
Derive Timestamp from SYSTIMESTAMP
SYSTIMESTAMP To have a timestamp as of now, we can use the function SYSTIMESTAMP. SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 09-AUG-23 04.36.54.934270 PM -04:00… Read More »Derive Timestamp from SYSTIMESTAMP
How to Check Database Time Zone
DBTIMEZONE There're 2 ways to check the time zone of a database. Database Property Since DBTIMEZONE is actually a property of database, we may query… Read More »How to Check Database Time Zone
Oracle TO_CHAR Example
TO_CHAR is an overloading function which converts or extracts various types of input values into desired or readable output. TO_CHAR for Datetime TO_CHAR for Number… Read More »Oracle TO_CHAR Example
How to Resolve ORA-01821: date format not recognized
ORA-01821 Tried to display a datetime into a readable format by TO_CHAR function, but it failed with ORA-01821. SQL> set heading off; SQL> select TO_CHAR(sysdate,… Read More »How to Resolve ORA-01821: date format not recognized
How to Add New Line for Each Row
What is New Line Character in Oracle? Sometimes, we need to make several lines for each row. For example, we'd like to compose some dialogs… Read More »How to Add New Line for Each Row
Oracle TO_DATE Example
Oracle TO_DATE function can convert a string into a datetime value which is acceptable for computing or comparing values of datetime type. In other words,… Read More »Oracle TO_DATE Example
Oracle SUBSTR Function by Examples
SUBSTR Function Oracle SUBSTR function is used to cut or extract a piece of sub-string from an outer string. In this post, I will introduce… Read More »Oracle SUBSTR Function by Examples