Oracle – Join Tables Without Stating Any Join Columns – NATURAL JOIN

We saw how using USING clause in the joins simplifies the JOIN conditions. We use it like this NATURAL JOIN clause: Today, let us take a  look at another less known join clause – NATURAL JOIN. All it does is on the two tables/views that are joined, it looks for all the matching column names … Continue reading Oracle – Join Tables Without Stating Any Join Columns – NATURAL JOIN

Advertisements

Oracle – Simplify Your Joins – Using “USING” In JOIN Clause?!

Same SQL written in 3 different ways “There are a thousand ways to skin a cat” or so they say. Let us look at just three ways of writing the same SQL and build the case for using the USING clause. The query below is to get the current Oracle session’s effective “parallel” related parameter … Continue reading Oracle – Simplify Your Joins – Using “USING” In JOIN Clause?!

Oracle – Capture OS Command Output Using Oracle External Tables

Case for the OS side: Some things are best done on the OS side and there is no question about that. Case for the DB side: Some things are best done on the database side and there is no question about that either. What if? Some things need the output of one in the other … Continue reading Oracle – Capture OS Command Output Using Oracle External Tables

Oracle – Parallel To PGA (P2P) & Serial To SGA (S2S) – Caching Differences And When Parallelism Is Not The Panacea For Performance!

If you are running into memory issues such as below, there could be several causes but one of the causes is excessive parallelism and exhaustion of PGA memory. “ORA-01034: ORACLE not available / ORA-27102: out of memory / Linux-x86_64 Error: 12: Cannot allocate” Please read on to find out how to resolve this. There are … Continue reading Oracle – Parallel To PGA (P2P) & Serial To SGA (S2S) – Caching Differences And When Parallelism Is Not The Panacea For Performance!

SQL Server: Run A Script In Command Line Mode (SQLCMD) Inside SQL Server Management Studio (SSMS)

In mature IT shops, all deployment scripts in a release are run into the database using command-line batches as opposed to doing it by hand. Error running SQLCMD scripts in SSMS Occasionally, when one is testing a single script within a release to make sure it works, he/she needs to jump to the command line to … Continue reading SQL Server: Run A Script In Command Line Mode (SQLCMD) Inside SQL Server Management Studio (SSMS)