Oracle REDO – A Basic Explanation

In an earlier post, we saw how Oracle’s UNDO works in very basic terms. REDO is another critical aspect that goes hand in hand with UNDO. Let us get the basics of REDO sorted out here. UNDO and REDO In its most basic sense UNDO is information saved to get back in case a ROLLBACK … Continue reading Oracle REDO – A Basic Explanation

Advertisements

Oracle – Data Dictionary Views – USER vs ALL vs DBA Views – 100 Level Basics

Most of us use data dictionary views on an everyday basis to find things like: In which schema does a table with a certain name exist? What tables use a certain column name? Get the line of code from any and all packages where a string named “EMPLOYEE_NUMBER” is used What privileges does a role … Continue reading Oracle – Data Dictionary Views – USER vs ALL vs DBA Views – 100 Level Basics

Oracle/SQL Server – On the fly data using DUAL for simple SQL tests – 100 level Basics

For SQL Server Although these examples are to be run on Oracle, for SQL Server, simply remove the "FROM DUAL" and ROWNUM references, then replace || (for string concatenation) with "+" and you should be all set! For Oracle While this is an extremely basic tip, it illustrates a few things A basic way to … Continue reading Oracle/SQL Server – On the fly data using DUAL for simple SQL tests – 100 level Basics