Psychic Intuition
Have you ever spoken to someone who knew what you were trying to say before you could finish your sentences? Or, a person who knew what you were going to…
Psychic Feeling
Psychic feeling is the easiest to access and interpret. You know that feeling when you're about to do something, and it doesn't feel right? When you feel that something wonderful is going to happen and eventually it does? These are examples of psychic feelings. People who have a natural psychic feeling gift may have these in the personality profile:
- You trust your feelings implicitly
- You can usually sense when something is wrong with someone, and are ready to help.
- You are concerned for and about other people.
- You want others to be emotionally at ease and expect them to be as caring towards you as you are for them.
Gentoo CD Burning
In Windows CD burning is taken for granted. You can either burn a CD by using the Windows CD burning engine or by popping the software that came with the…
Formatting Output
Introduction
Querying a database is just half of the battle. The other half is making the data that is pulled out of the table look pretty. Reports are used for those non-techie, higher ups that like it when things look pretty.Debugging With Eclipse and PHPdbg in Linux
p.code { background: black; color: lime; } tr { background: black; color: lime; } table { border-width: thin; border-color: #00FF00; size: 12pt; width: 100% } div.indent { margin-left: 1.5em; width: 100%; } Using a debugger to help find errors will save you a consider amount of time. Eclipse is a great IDE because not only is it platform independent, but you can use it to program in many different languages. The features and plugins seem endless which is an added bonus. The main reason why I like it is that it works on Linux. ;)
Views
Views have two purposes:
- Simplify issuing complex SQL queries
- Restrict users' access to sensitive data.
IVMan Automounter in Gentoo
Introduction Linux is great in the respect that you have COMPLETE control over everything you do on the system. You can even control the mounting of drives. However, sometimes you…
Rearming Windows Vista
Introduction
At work we have a Core 2 demo running Windows Vista. This demo is not connected to the network because we don't want people coming in and changing the background image to display something obscene or pornographic. There is a neat little trick that I found one day while trying to figure out how I could reset the time until the user had to activate Windows Vista.Subqueries and Merges
HTML Source EditorWord wrap Sub queries come in handy when you want to find a record but need to know what exactly to look for. For example, if you want to find all the items that are more expensive than a specific item. Instead of issuing two SELECT statements, you can use sub queries to find the answer in just one query. When designing Sub queries, the first query that is designed is the sub query. In order to execute sub queries correctly, you must determine what it is that you are looking for. After successfully testing the sub query, it is this that will be passed as input to the parent query or the outer query.
Selected Single-Row Functions
A function is a block of predefined code. Single-row functions return only a single row for each record processed. These functions include functions that deal with characters to dates.
| Type of Functions | Functions |
| Case conversion | UPPER, LOWER, INITCAP |
| Character manipulation | SUBSTR, INSTR, LENGTH, LPAD/RPAD, RTRIM/LTRIM, REPLACE, TRANSLATE, CONCAT |
| Numeric | ROUND, TRUNC, MOD, ABS |
| Date | MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, TO_DATE, ROUND, CURRENT_DATE |
| Regular expressions | REGEXP_LIKE, REGEXP_SUBSTR |
| Other | NVL, NVL2, TO_CHAR, DECODE, SOUNDEX, TO_NUMBER |