In Oracle Database, the NVL() function allows us to replace null values with another value.
Category: Oracle
COALESCE() Function in Oracle
In Oracle Database, the COALESCE() function returns the first non-null expression the expression list.
How to Add the AD/BC Indicator to a Date in Oracle
When using the TO_CHAR() function to format a datetime value in Oracle Database, you can add the AD/BC indicator by simply adding either AD or BC to your format model.
Oracle then displays the appropriate indicator, depending on whether the date value is AD or BC.
You can provide it in any uppercase or lowercase, and with or without dots (e.g. AD, A.D. ad, a.d, etc). Oracle will then display the indicator as specified.
2 Functions that Return the Seconds from a Datetime Value in Oracle
Below are two functions that can be used to return the seconds portion from a datetime value in Oracle Database.
Continue readingHow to Format Dates in Oracle
This article contains common examples of formatting dates in Oracle Database.
Continue readingHow to Return the Number of Seconds Past Midnight in Oracle Database
Oracle Database provides the SSSSS format element that enables us to get the number of seconds past midnight from a given datetime value.
How to Get the Month Name from a Date in Oracle
In Oracle Database, the TO_CHAR(datetime) allows us to return a datetime value, formatted in a way that we specify.
One of the things we can do is return the month name from a date.
Continue readingROWIDTONCHAR() Function in Oracle
In Oracle Database, the ROWIDTONCHAR() function converts a ROWID value to NVARCHAR2 data type
It’s similar to the ROWIDTOCHAR() function, except that ROWIDTOCHAR() converts a ROWID value to VARCHAR2 data type.
ROWIDTOCHAR() Function in Oracle
In Oracle Database, the ROWIDTOCHAR() function converts a ROWID value to VARCHAR2 data type.
4 Ways to Format a Number Without Decimals in Oracle
When using Oracle Database, you can use functions like TO_CHAR(number) to return numbers as a string. This enables you to format the number to have a specific number of decimal places – including no decimal places, if that’s what you want.
You can also use functions like ROUND(number) and TRUNC(number) to round or truncate the number to no decimal places.
There’s also the CAST() function that allows you to cast a data type as an integer, which effectively removes any decimal places.