GitHub

Cracking the SQL Interview

SQL - Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a ...
shine.com

Difference between SQL and PL/SQL

SQL is a conventional database the language that is used to maintain, create and recover the relational database whereas PL/SQL, Procedural Language extension to SQL, it prolongs SQL and provides ...
GitHub

Exception during insert using executemany() and a PL/SQL statement returns a rowcount of 0

Computronix has recently upgrade cx_Oracle to version 7.1.1 and we have noticed that the rowcount attribute is returning as 0 when a PL/SQL block with a single insert statement is passed into ...
Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...