Money is defined in Oracle with the Currency data type.

More Questions from Managing Databases with Oracle

• Oracle commands, column names, table names, view names and all other database elements are case sensitive.
• When you type Start FILENAME, the statement in your file will be executed automatically.
• If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.
• The only time that case matters is inside quotation marks of strings.
• Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
• Oracle does NOT support a CASCADE UPDATE constraint.
• You can use the DROP statement to remove structures from the database.
• SQL*Plus is a text editor.
• When you type into SQL*Plus and press enter, the statement will be finished and executed.
• Oracle directly supports the definition of surrogate keys.

Discussion & Comments