Paulus’ Blog

If you log on to the computer and you see a message like this:

svchost.exe — application error the instruction at “0×745f2780″ reference memory at “0×00000000″. the memory could not be ‘read’

Chances are that you have corrupted Windows Update data. To fix this problem follow these steps: (more…)

A database object is anything that has a name and a defined structure. Other database objects that are used in Oracle 10g are sequences, indexes, and synonyms.

• A sequence will generate sequential integers that can be used to assist with internal controls or serve as primary keys for tables.
• A database index serves the same basic purpose as an index in a book.
• A synonym is a nick name that is given to an object that may have a complex name. There are two types of synonyms, one being a private, which is used only by an individual on objects they own, and the other being public, which is used by others to access another’s database objects.

(more…)

The keywords that Manipulate data and control transactions are called Data Manipulation Language or DML. With out the DML a database would be useless and a waste.

Inserting Data

Syntax

INSERT INTO tablename [(columnname, …)]
VALUES (datavalue, …);

When inserting data if you are inserting a full row of data, placing data in all columns then you can omit the column names as long as you follow the order of the columns in the table. If there are no constraints that require a value to be inserted into the column you can opt out those values but you must then name the columns you wish to place data in if you either omit a column or change the order of data. Another way of not naming the columns is to insert a NULL into the column.

(more…)

Constraints are used to keep accurate data. In oracle you can apply these policies to a column or table. There are five different types of constraints:

(more…)

When creating tables in Oracle we have to follow some rules in order to successfully create a table:

• Table names and columns can be up to 30 characters long.
• Names of tables and columns cannot have any blank spaces.
• Numbers, underscores, and number signs are allowed in the table and column name.
• Each table that a user owns must have a unique name and each column in that table must have a unique column name.
• You can’t use reserved keywords as a table or column name.

(more…)

With every new operating system comes headaches as we find that our favorite programs or hardware no longer works with it. If you’re like me, you’re probably being forced into using Windows because everyone else does. Then again, if I had Linux installed on my box along side Vista, I’d feel a bit dirty and I’d be using a real boot loader like GRUB. In Vista Microsoft did away with the ntldr.exe and boot.ini files and replaced it with a new program.

Startup Process

After the system gives control to the Master Boot Record, Vista then takes charge of the system and starts itself:

1. The MBR reads the boot sector of the active partition and executes the Bootmgr.exe program.
2. The Boot Manager reads the configuration file and gives the user the choices it that’s contained in that file.
3. Once a choice is selected one of the following is done:

• When starting any edition of Vista, the %SystemRoot%\System32\Winload.exe is executed.
• When resuming Vista from Hibernation the boot manager program executes Winresume.exe which will restore the system to the way it was before it went into hibernation.
• When choosing an earlier version of Windows, the boot manager will locate the ntldr and you’ll have to go through another boot loader.

(more…)