Articles tagged Redgate deploy

07 May 2014
07 May 2014

Oracle for Absolute Beginners: Part 6 – Procedures and Functions

0
45
A wise man once said, insanity is doing the same thing over and over again but expecting different results. If that is the case then no one’s saner than a computer programmer*, because programming is executing the same code over and over again and expecting the same results. We’ve already talked about bundling up statements in anonymous PL/SQL blocks; now… Read more
10 December 2013
10 December 2013

Oracle for Absolute Beginners: Part 1 – Databases

0
118
A wise man* once said, an expert is someone who uses big words and acronyms where simple phrases would do just as nicely. So stand back and listen to this: Database, Relational Database, DBMS, RDBMS, SQL, Sub-queries, normalisation. [* that wise man was me.] So now that I’ve established my credentials by bamboozling you with arcane words and capital letters,… Read more
27 June 2013
27 June 2013

Oracle Database 12c New Features – Part I

0
65
During this Oracle Database 12c new features article series, I shall be extensively exploring some of the very important new additions and enhancements introduced in the area of Database Administration, RMAN, High Availability and Performance Tuning. Part I covers: Online migration of an active data file Online table partition or sub-partition migration Invisible column Multiple indexes on the same column… Read more
30 August 2012
30 August 2012

Checking for NULL with Oracle SQL

0
17
The art of doing mathematics consists in finding that special case which contains all the germs of generality. David Hilbert One of the most mindboggling values in the Oracle database is the NULL value. What is NULL? NULL is nothing. NULL is not even the same as NULL. NULL is undefined. But you need to work with NULL values (which are no… Read more