Oracle

This web page contains survival notes on Oracle. As I get a chance I will place my survival notes here. I am not an Oracle jock at all!

Download Oracle (Under construction....)
- www.oracle.com
  - Click the "Downloads" tab.
  - If Export Validation passes you will get an email with info to continue your download.
    Now wait on the email (it may take some time).
    Warning: You may have to wait 1 to 2 days for the email!
    Subject Line was: Export Validation Hold Cleared Notification
  - Next time you do to download you will need to create an Oracle account and then you can download.
  - Downloads to: c:\temp\_is10E\Oracle Database 10g Express Edition.msi - 208Meg.
    (Note: You have to run the setup.exe!)
Oracle Database 11g Release 2 Express Edition Released - 32-bit Oracle Database 11g Release 2 Express Edition (XE) is a free, small-footprint database with an MSI-based install. The new production release is built on the latest Oracle Database technology, supporting up to 11GB of user data. .NET programmers can use XE as their development and test database.
- http://www.oracle.com/technetwork/database/express-edition/downloads/index.html - Download Oracle DB XE
- http://www.oracle.com/technetwork/database/express-edition/overview/index.html - Info on Oracle DB XE
Temp Tables
- http://www.indiana.edu/~dss/Services/DataWarehouse/Oracle/TemporaryTables/tmptab.html

Topic

Notes

TAB Table

List Tables in a Database

List Tables in Database

List Structure

List the Structure of a Table

For Oracle: (desc TAB;)

Operators

Comment

Tables

Temporary Tables

Temp Tables

create global temporary table tmptable (myvarchar1 varchar(10) NOT NULL) - suppose to work in Oracle 8.1 or greater. Got this from a friend.

Date

Dates

sysdate - the current system date.
select to_char (mydate, 'yyyymmdd') from mytable1
Converts a date to 'yyyymmdd' format

Functions