When using SQLcl with Oracle Database, you can use the SPOOL command to export your query results to a file with an .html extension, and you can set SQLFORMAT to html in order to output the actual query results in HTML format.
how to
2 Ways to Replace a Substring in MariaDB
If you need to replace a substring with another string in MariaDB, here are two approaches that you can use.
How to Export Query Results to a CSV File in SQL Developer (Oracle)
You can do this to export your query results to a CSV file when using SQL Developer to query Oracle Database.
Return the Short Month Name from a Date in Oracle
In Oracle Database, we can use the TO_CHAR(datetime) function to return the various date parts from a datetime value, including the short month name.
The short month name is also referred to as the abbreviated month name. Examples of returning the short month name are below.
UID – Return the ID of the Current Session in Oracle
In Oracle Database, the UID function returns an integer that uniquely identifies the session user (the user who logged on).
How to Export Query Results to a CSV File in SQLcl (Oracle)
If you’re using SQLcl to run queries against Oracle Database, then you can use the SPOOL command to export your query results to a CSV file.
4 Ways to Separate Hours, Minutes, and Seconds from a Time Value in MariaDB
MariaDB has several functions that enable you to extract various date and time parts from date/time values. You can use these to separate each date/time component into its own column if required.
Below are four ways to extract the hours, minutes, and seconds from a time value in MariaDB. As a bonus, we’ll also include microseconds.
How to Return Fractional Seconds from a Datetime Value in Oracle
When using Oracle Database, you can use the TO_CHAR(datetime) function to return various parts of a datetime value, including the fractional seconds.
To return the fractional seconds part from a datetime value, use the FF format element.
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.