FIND-AND-REPLACE SHORTCUTS AND REGULAR EXPRESSIONS

If you are going to work efficiently as a programmer, then your search skills have got to be on point. You need to be able to Ctrl+F and Ctrl+H yourself out of trouble, and quick! When find-and-replace work gets tricky, that’s when you pull out Regular Expressions, the power tool of searching. You can use … Continue reading FIND-AND-REPLACE SHORTCUTS AND REGULAR EXPRESSIONS

Change Oracle’s SQLPLUS EDitor

Not everyone wants to use sqlplus' built in editor. It is a bit of a pain and not at all WYSIWYG. Thankfully, changing sqlplus to use another editor is an easy process where you change the _editor session variable to another value. For a more permanent change, you can alternatively change the setting in the … Continue reading Change Oracle’s SQLPLUS EDitor

Ampersand Substitution and Session Variables

Exam Topic: Restricting and Sorting Data - Use ampersand substitution to restrict and sort output at runtime The Ampersand (&) and Double-Ampersand (&&) are used in oracle as prompts for input. They are called "Substitution Variables." They can be used to input a value or dynamically build or modify a statement at runtime. This allows you … Continue reading Ampersand Substitution and Session Variables

Reading Linux’s TOP Screen

The top command in Linux provides information about the top CPU processess and provides performance information. The processes displayed are sorted by CPU usage with the information updating by default every 3 seconds. Top also displays information about memory and CPU waiting for I/O. Below is a line-by-line explanation of the top screen. To find out … Continue reading Reading Linux’s TOP Screen