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.
By Paulus, 19 February, 2007
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.
By Paulus, 14 February, 2007
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:
Constraint | Abbreviation | Description |
PRIMARY KEY | _pk | This is a unique field that is not allowed to have null values. |
FOREIGN KEY | _fk | This constraint is placed in the "many" table.
By Paulus, 14 February, 2007
When creating tables in Oracle we have to follow some rules in order to successfully create a table:
By Paulus, 7 February, 2007
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. |