Python3 with Oracle Database
Installation These instructions are for Mac OS: First install homebrew. Never use sudo for brew. Install Python3. The installation comes…
Simply Explaining Technology
Installation These instructions are for Mac OS: First install homebrew. Never use sudo for brew. Install Python3. The installation comes…
Error Message What it means This error occurs if a wrong value is passed when converting a number or string…
Decode function has the same functionality as an IF-THEN-ELSE statement. It is present in Oracle 9i and above. It has…
A package is an encapsulated collection of related PL/SQL types, objects, procedures, and other program objects. Packages have a package…
Changing case To change the first letter of the word to cap, use the inicap function. Use upper to covert…
Procedural Language extension of SQL (PL/SQL) combines SQL with procedural programming features such as looping, conditionals, and reusable blocks. PL/SQL…
The most commonly used set operators in Oracle are: union intersect minus Union Union combine results returned by two or queries…
NVL function NVL function can be used to substitute a value when null in encountered. It has the following syntax:…
If you want to list tables in MySQL, you simply type the following command: Oracle does not provide such a…
There are two ways of adding a leading dollar sign to numbers in Oracle. You can either define the column…