Oracle Database

Recently I had to drop some foreign key constraints on tables.

Below the SQL, which did the job for me. After 'drop constraint' you have to provide the name of a constraint you want to delete as it is maintained in table all_constraints.

Alter Table
a_table
drop constraint
fk_any_table_ref;

Recently I had to check over and over again, if tables, which I needed for testing are existing in an Oracle database.

Since checking for existance and completion repeatedly involved the same tasks I decided to implement little PL SQL script, which does the task for me.

SQL

If you have to know the current database version, you can get this information using the following SQL.

SQL

1
SELECT * FROM V$VERSION;

 

Subcategories

This category will hold examples for Oracle SQL.

This category will hold Oracle SQL Developer specific articles.

A category holding articles for Oracles programming language PL SQL.