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: 9604

Stored Procedures and Functions are sometimes referred to as Stored Procedures. The difference between Stored Procedures and Functions is simple. Functions have to return values, Stored Procedures do not return anything. They just do stuff.

Stored Procedures do not execute DDL Statements. Creating database objects like tables at runtime is a bad idea since this should be defined by a datamodel. If you try to create a Procedure with DDL Statements it will not compile.

Last Updated: 15 January 2016

Hits: 5805

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: 9011