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 ...
GitHub

README.md

tePLSQL is a template engine written completly in PL/SQL, generate text output (HTML web pages, e-mails, configuration files, source code, etc.) based on templates. Templates are written with embebed ...
Ars Technica

TSQL: Possible to add a single hard coded row to a SELECT statement that returns rows

Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?<BR><BR>Example:<BR>I want to populate a drop down list with <BR>SELECT ...
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 ...