Author: Randy Sims
Run an Unattended SQL Script from Linux using nohup
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.
Continue Reading...Using Oracle’s srvctl to Complete a RAC Flashback
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.
Continue Reading...Oracle Single Row Character Functions Returning Numeric Values
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 […]
Continue Reading...Oracle Single Row Character Functions Returning Character Values
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 […]
Continue Reading...Dignity
What is dignity? Is it a right or a perspective? It is both. The word “dignity” is overloaded and is the name of two unrelated concepts. The perspective is more about opinion of worthiness. The right is the foundation of what today is called Human Rights. “…Recognition of the inherent dignity and of the equal […]
Continue Reading...Oracle’s SRVCTL: Enable an Instance. Make an Instance Preferred. Check a Service’s Status.
How to use the Oracle Server Control (srvctl) to enable instances, and see configurations and statuses.
Continue Reading...Basic Algebraic Functions
The following is a mini-workout of the basic Algebraic functions found in Oracle 11g. It includes ABS, CEILING, FLOOR, MOD, REMAINDER, NANVL, POWER, ROUND, SIGN, TRUNC and BUCKET_WIDTH. More functions can be found here.
Continue Reading...Oracle srvctl Basics – Listener and Database Commands
When a database is getting started, generally the listener control service (lsnrctl) is started and the database is started by logging into the database and executing the startup command. If you’re in a RAC configuration, you should be using srvctl; this command knows your configuration and works on the entire RAC environment instead of just […]
Continue Reading...Convert Decimal to Other Number Systems
Just for fun, I made a block of code that will convert decimal numbers to any other number system. Maybe I’ll go the other direction next. It’s basically a loop. It takes the remainder of the original number divided by the number system (MOD) and adds that to a string. The string is made by […]
Continue Reading...110-Year-Old Computer that Plays Music: the Marenghi 81-Key Organ
To quote Wikipedia, “A computer is a general-purpose device that can be programmed to carry out a set of arithmetic or logical operations automatically. Since a sequence of operations can be readily changed, the computer can solve more than one kind of problem.” Given the early devices seen over the centuries, I think this is […]
Continue Reading...