Here are two ways you can use SQLcl or SQL*Plus to check your Oracle Database compatibility level.
Continue readingCategory: Database Tools
2 Ways to Format your Query Results in SQLcl (Oracle)
When using SQLcl to run queries against Oracle Database, you can specify the output of the query results using the following two options:
- The
SET SQLFORMATcommand - Add a comment shortcut to your query
SQLcl Formatting Options (Oracle)
When using SQLcl to query Oracle Database, you can use the SET SQLFORMAT command to determine the format of the results.
You can also use inline comments to specify the format from directly within your query.
Continue readingHow 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.
Continue readingHow to Install Windows 10 on an M1 Mac for Free
In 2020, Apple introduced Mac computers with Apple silicon, with the first chip being the Apple M1.
This was a major change, and it affected many third party applications to the point where they simply don’t run on the M1 Mac.
One application that doesn’t run on M1 Macs is VirtualBox. Prior to the M1 Mac, we could use VirtualBox to install Windows on our Mac. VirtualBox is a free virtualisation application that enables you to install virtual machines (with other operating systems) on your Mac.
Fortunately, there’s a free alternative to VirtualBox – UTM.
Continue readingSET SQLBLANKLINES: How to Allow Blank Lines in SQLcl & SQL*Plus
If you’re trying to run a multi-line query in SQLcl or SQL*Plus, and you keep getting an error such as “Unknown Command”, but running it in SQL Developer causes no such error, maybe this post will help.
By default, SQLcl and SQL*Plus don’t allow blank lines in SQL statements. However, you can change this with the SET SQLBLANKLINES command.
SET NULL: Specify a String to Return Whenever a Null Value Occurs in SQLcl / SQL*Plus
SQLcl and SQL*Plus are command line interfaces for working with Oracle Database.
By default, they return an empty string whenever null occurs as a result of a SQL SELECT statement.
However, you can use SET NULL to specify a different string to be returned. Here I specified that the string null should be returned.
How to Configure Syntax Highlighting in SQLcl
Starting with SQLcl version 21.2, we can now configure SQLcl for syntax highlighting.
That means that the code you write in SQLcl can be color coded, based on the syntax highlighting rules you apply.
Continue readingHow to Create a login.sql File for SQLcl
When using SQLcl (Oracle’s command line interface), you can create a login.sql file, and have it run each time you run SQLcl.
This allows you to have commands executed each time you run SQLcl. For example, you can specify your formatting preferences in the login.sql file, set up aliases, etc.
Here I show you how to create a login.sql file and how to make it run each time you run SQLcl.
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 reading