SQL - Chronicles of Technology

SQL

A collection of 3 posts

Oracle Database: Zoning Conundrum

Oracle Database: Zoning Conundrum

The Oracle Database has long and complicated relations with time-aware data. It has gotten even more interesting in the internet era and global data processing. As usual, it's a story about how a single line of code at the design time could save many work hours in maintenance.

Database: It's Hard to Explain

Database: It's Hard to Explain

When you are enough time in the business, you learn the universal rule of IT: "Computers don't make mistakes, people do." It is especially true for database performance tuning.

Getting `ORA-00933: SQL command not properly ended` due to blank line

What's strange is that a SQL script someone wrote (which apparently was running fine for months) seemed to return an ORA-00933: SQL command not properly ended error when executed through the Linux command line, as shown below: oracle@dbhost:/home/oracle> /u01/sqlplus/instantclient_12_2/sqlplus