General Directions for Personal Oracle 8
To get started once Personal Oracle 8 (PO8) has been installed,
go to where ever you have placed the program and open the Oracle 8 Navigator.
This will take you to the files associated with PO8.
Next you will want to create a new user profile, unless you want
to simply use one of the profiles provided. I would suggest creating a
new profile to help familiarize you with the system (see New Users).
After creating your profile you will want to create a project
for whatever you are working on (see New Projects).
Once the project has been created you can fill that project
with tables and views. Tables are the objects used in PO8 to store
the information of your database (see New Tables).
When creating
tables there are several differing values types that can be assigned.
Here is an explanation of those values:
- "Char
- Alphanumeric data at least 1 character long and no more than 255 characters. Use this for fields that have a combination of characters and numbers, such as addresses.
- Date
- Oracle includes as part of the date the century, year, month, day, hour, minute, and second.
- Long
- Variable length alphanumeric strings up to 2 gigabytes in size.
- Long Raw
- Binary data up to 2 gigabytes in size.
- Number
- Stores numeric zero, positive, or negative fixed or floating point data. Use this for fields that will only contain numbers.
- Raw
- Binary data up to 255 bytes in size.
- RowID
- Hexadecimal string representing the unique address of a row in a table.
- Varchar2
- Alphanumeric data at least 1 character long and no more than 2,000 characters long. This is the same as the CHAR field except it accommodates more text input. You can use this field for entering memos or paragraphs."
Copyright © 1998, Oracle Corporation
Once Tables have been defined a view can then be defined off of a table.
A view is the object that PO8 uses to display a query. This query is
usually some form of an SQL statement (see New Views).
Using SQL and PL/SQL in your database design: Using SQL and PL/SQL
Next you may want to add Functions to your database: Functions
Return to Oracle Help Page