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;

Last Updated: 07 July 2014

Hits: 8909

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

Last Updated: 04 January 2018

Hits: 5008

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

SQL

SELECT * FROM V$VERSION;

Last Updated: 30 July 2015

Hits: 8418