Creating a user

Like table names and columns, a user name must follow the same rules. There is one minor difference. A user name can contain a dollar sign.

CREATE USER username
[ IDENTIFIED BY password ]
[ PASSWORD EXPIRE ]

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

svchost.exe -- application error the instruction at "0x745f2780" reference memory at "0x00000000". the memory could not be 'read'

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

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.

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

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:

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

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.