October 2015, SQL Simantics

Linux Echo and Reading Files

Randy Sims Linux

Assigning values to variables, using ECHO and reading a file.

Run an Unattended SQL Script from Linux using nohup

Randy Sims Linux

Some scripts take a long time to run. If they are interrupted, you will lose all your work. To get around that, create a bash file to run the script for you, then run the script file with the NOHUP option so it won’t hang up.

Using Oracle’s srvctl to Complete a RAC Flashback

Randy Sims Oracle

A flashback restore point is handy for deployments of new code and testing. Remember: You cannot properly shutdown a RAC database using sqlplus command. Use srvctl commands instead.

Oracle Single Row Character Functions Returning Numeric Values

Randy Sims Oracle

Exam Topic: Using Single-Row Functions to Customize Output – Describe various types of functions available in SQL Single row functions return a result for every row in a result. They can be used in any part of a SQL query, such as the SELECT lists or any part that can use a conditional statement. Oracle 11g has […]

Oracle Single Row Character Functions Returning Character Values

Randy Sims SQL Fundamentals I

Exam Topic: Using Single-Row Functions to Customize Output – Describe various types of functions available in SQL Single row functions return a result for every row in a result. They can be used in any part of a SQL query, such as the SELECT lists or any part that can use a conditional statement. Oracle 11g has […]