ORATraining Blog

Tweet Unix vi commands quick reference General Notes: 1. Before practicing using this vi tutorial, type the following command followed by a   carriage return: :set showmode 2. vi is not VI. It is case sensitive!!! So make sure Caps Lock is OFF. Requirements: In order to work correctly the vi need correct terminal type (TERM) [...]

Tweet Quick Reference: Unix Commands and options The following format is used for commands: Italic indicates a variable that you supply Bold indicates exactly what you type [ ] Square brackets indicate that the thing which they surround is optionally typed. The square brackets themselves are not to be typed. To display a command description from [...]

Tweet Special commands and characters: Converting DOS commands to UNIX commands There are a few command line questions that are asked very often. These questions, with answers that should be typed at your shell prompt are printed below: DOS                 UNIX dir …………… ls cls …………… clear del …………… rm copy ………….. cp move / rename [...]

Tweet Oracle PL/SQL Quick Reference   PL/SQL Block Structure DECLARE –Optional   –Variables, Cursors, User-defined exceptions BEGIN –Mandatory   –SQL statements   –PL/SQL statements EXCEPTION –Optional   –Actions to perform when errors occur END; –Mandatory

Tweet Oracle SQL Quick Reference SELECT Query Statement SELECT [DISTINCT] {*, column [alias],…} FROM table WHERE condition(s)] ORDER BY {column, exp, alias} [ASC|DESC]] NOTE: Avoid using DISTINCT with large table as it first does sorting of all the rows and then eliminates duplicate rows, so need a full table scan and thus it’s very slow. [...]