Documentation and Books

Recent site activity

Databases‎ > ‎

Oracle Database

What is the Oracle Database?


My tutorials :

None

3rd party tutorials :

None

Software and downloads :

Benthic Software
Benthic Software produces high quality tools for Oracle databases. Our products are high performance Windows programs that are designed to be both powerful and easy to use.

Toad
With Toad, developers and database administrators can use a familiar, proven tool to manage Oracle databases. Quest Software has an established track record for proven solutions that simplify, automate and improve the quality of application and database development. You can rely on Quest to provide you with an intuitive, graphical tool with all the features required to satisfy your growing Oracle needs.

TOra
Powerful software package licensed under the GPL license.

General questions and answers :

None

Common problems and solutions :

Techniques and common solutions:

The explanations below are kept simple on purpose, for more advanced features of these statements take a look at the original documentation. (references to the original documentation are included with the simple explanations)

DDL ( Data definition language (Wikipedia) )

How to create a user?
How to change the password of a user?
How to drop a user?
How to create a table?
How to remove a table?
How to add a comment on a table?
How to add a column to a table?
How to add a comment on a column?
How to modify a column?
How to remove a column?
How to add a primary key?
How to rename a primary key?
How to add a foreign key?
How to rename a foreign key?
How to add a unique constraint?
How to add a check constraint?
How to add an index?
How to remove an index?
How to remove a constraint (PK, FK, Unique)?
How to disable / enable a constraint (Primary key, Foreign key, Unique)?
How to create a synonym?
How to drop a synonym?
How to create a procedure?
How to drop a procedure?
How to create a function?
How to drop a function?
How to create a trigger?
How to drop a trigger?
How to create a sequence?
How to drop a sequence?
How to create a DBMS Job?
How to change an existing DBMS Job?
How to remove a DBMS Job?


DML ( Data Manipulation Language (Wikipedia) )

SQL-Plus

SQL

How to copy data from one table to another (within the same database)?
How to see the explain plan for a SQL statement in for example SQL-Plus?
How to calculate the difference between two date columns?
How to calculate the difference between sysdate and a date in the past (without the time)?
How to remove duplicate rows from a table?
How to use IF-THEN-ELSE constructions in a SQL query?
How can i see the current open sessions?
How can i test a string for numeric values?
How can i test a string for alphabetic values?
How can i test a string for alphanumeric values?
How can i resolve to which instance i am connected?
What is the difference between a varchar column that contains an empty string or a NULL value?
How to convert between decimal, hecadecimal, octal, binair within SQL?
How to convert NULL to some default value in the result of my query?
How to use the sequence object within SQL?

PL/SQL

Other

Project site & reference documentation: