Commands, SQL Simantics

Change Oracle’s SQLPLUS EDitor

Randy Sims Oracle

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 […]

Ampersand Substitution and Session Variables

Randy Sims SQL Fundamentals I

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 […]

Reading Linux’s TOP Screen

Randy Sims Linux

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.