Oracle has evolved over time to much more than just a plain relational database. One option is to use Oracle as an expensive calculator.
When researching or demoing Oracle, it’s quite convenient to do number calculations directly on sqlplus prompt, especially if dealing with internals where lots of stuff is about addresses and offsets shown in hex.
Here’s the script what I use for such purposes: https://github.com/tanelpoder/tpt-oracle/blob/master/calc.sql.
It usually saves me couple of seconds every calculation as I don’t have to reopen the calc.exe on my Windows box (I immediately stopped using it after I wrote the script).
But the main benefit is that your calculation outputs remain in the sqlplus output history, so you don’t have to redo them again and you’ll have somewhat better documentation of the output of research steps you’ve done.
Here’s a quick demo:
Add a decimal value to decimal value:
SQL> @calc 10 + 10
DEC HEX
-------------------- --------------------
20 14
Add a hex value to a decimal:
SQL> @calc 10 + 0x10
DEC HEX
-------------------- --------------------
26 1A
Divide a hex value with a decimal one:
SQL> @calc 0xFFFF / 64
DEC HEX
-------------------- --------------------
1024 400
Show a value in both hex and dec:
SQL> @calc 65536 + 0
DEC HEX
-------------------- --------------------
65536 10000
Note that you do not need to use “0x” for indicating a hex value, instead just an “x” will do:
SQL> @calc xB0B * x142A2D
DEC HEX
-------------------- --------------------
3735928559 DEADBEEF
So, you can use Oracle as a very expensive calculator – but on the other hand it can save some of your time…
