In Oracle, the ASIN() function returns the arcsine (inverse sine) of its argument.
In other words, it returns the value whose sine is the argument.
Continue readingCategory: Oracle
How to Add Vertical Borders to your SQL*Plus / SQLcl Output Grid
When you run a query against an Oracle database using SQLcl or SQL*Plus, the results are displayed according to the SQLFORMAT option. But within that, there are other things you can do to customise the format of the results.
One of the things you can do is specify a column separator for the output grid.
Continue readingACOS() Function in Oracle
In Oracle, the ACOS() function returns the arccosine (inverse cosine) of its argument.
In other words, it returns the value whose cosine is the argument.
Continue readingABS() Function in Oracle
In Oracle, the ABS() function returns the absolute value of its argument.
The absolute value is the non-negative value of a real number without regard to its sign. It describes the distance from zero that a number is on the number line, without considering direction.
Continue reading7 Ways to Check your Oracle Version
Here are seven ways to check which version of Oracle Database you’re running.
Continue readingHow to Install Oracle on a Mac
Here’s a quick and easy way to install Oracle Database on a Mac.
First up, Oracle isn’t available natively on the Mac. But don’t let that stop you!
If you’re a developer, and you just want to have Oracle Database running on your local machine, there are ways to do it. In fact, Oracle provides us with a virtual appliance precisely for that purpose.
Continue readingHow to Install SQL Developer on a Mac
SQL Developer is a GUI tool for working with Oracle Database. It’s available on many major operating systems, including Window, Linux, and of course, MacOS.
Here’s a quick rundown on the steps I took to install SQL Developer on a Mac.
Continue readingHow to Install SQLcl on a Mac
SQLcl is a command line tool for working with Oracle Database. It’s available on many major operating systems, including MacOS.
Here’s a quick rundown on the steps I used to install SQLcl on a Mac.
Continue readingFix ‘The application “SQLDeveloper.app” can’t be opened.’
If you just installed SQL Developer on a Mac, but you’re getting an error when trying to launch it, try the steps below to fix it.
The error reads “The application “SQLDeveloper.app” can’t be opened because Apple cannot check it for malicious software“. It also mentions that “This software needs to be updated. Contact the developer for more information“.
Below are the steps I used to overcome this issue, and launch SQL Developer.
Continue readingSQL DROP TABLE Syntax – Listed by DBMS
This article lists the SQL DROP TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.