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;
- Hits: 9889
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.
- Hits: 6060
If you have to know the current database version, you can get this information using the following SQL.
SQL
- Hits: 9200
Subcategories
Oracle SQL Article Count: 8
This category will hold examples for Oracle SQL.
Oracle SQL Developer Article Count: 4
This category will hold Oracle SQL Developer specific articles.
Oracle PL SQL Article Count: 6
A category holding articles for Oracles programming language PL SQL.
Page 3 of 6