Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: sqlplus
Take a COPY out of SQLcl’s book
As the world continues to get smaller, it makes sense for all databases to be defined to handle more than just US7ASCII, which is why the default characterset for all recent versions of the Oracle database is AL32UTF8. In that way, we can handle…
12c Release 2, set feedback enhancement in SQL PLus
There’s a nice little touch to the “set feedback” command in SQL PLus in 12.2. There is a new “only” clause in the SET FEEDBACK command, so you can run queries but the resulting rows are not shown in the display. They are still…
Are your SQL Plus scripts going to ‘ell ?
Excuse the hideous pun in the title. All will become clear shortly. Often we use SQL Plus to run scripts on a scheduled basis in our database. The “problem” is, they need to connect to that database. Here’s a simple script I want to…
Amped on Amper
This “problem” rates in the top 10 all time viewed questions on AskTom, and it demonstrates the importance of reading the Concepts guide with Oracle SQL> create table CARTOONS ( name varchar2(30)); Table created. SQL> insert into CARTOONS values (‘Tom & Jerry’); Enter value…
SQL*Plus quick tip
SQL Plus does not appear to be bothered by the direction of slashes, ie “/” or “\” in its scripts Hence as long as you have a “C:\tmp” folder on your Windows drive (or wherever your SQL Pus binaary is installed/running from), you can…
SQL*Plus hints and tips
I just posted a video on how I get the most out of my SQL*Plus usage. You can check it out here I reference various elements of my login.sql file throughout the video – so here’s login.sql file – feel free to utilise any…
exitcommit … or your career down the drain
I recently posted a little video on the ‘exitcommit’ option in SQL Plus, adding a theatrical drama to present a worst case scenario of potentially destroying a Production system. Take 3 mins to have a chuckle here. https://www.youtube.com/watch?v=uCgbxGayjXA My predecessor Natalka Roshak tweeted an…
