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.

Continue Reading

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.

Continue Reading

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. ;)

Continue Reading

Views

Views have two purposes:

  • Simplify issuing complex SQL queries
  • Restrict users' access to sensitive data.
Views are Database objects and are treated like tables. Unlike tables, views do not store any data. Views simply store a query.

Continue Reading

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.

Continue Reading

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.      

Continue Reading

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
When using a function in a SELECT the output will be modified accordingly but the data will not change in the database unless the function is used in an INSERT statement.

Continue Reading
Close Menu