Blog Archives

Duplicate Oracle Constraints

If you have ever used the Oracle import utility, your database has system generated constraint names (ex: SYS_C00641321), and you did not specify CONSTRAINTS=N during the import then chances are you have duplicate constraints for pretty much every constraint except

Tagged with: , , , , , , ,
Posted in Database Administration

Password Case Sensitivity in Oracle 11g

Oracle 11g now sets the password case sensitivity setting to TRUE by default. If you are running any application that connects to an earlier version of an Oracle database, chances are you are sending the connect string in all caps

Tagged with: , , , , ,
Posted in Database Administration

SQL: Exists Condition

The SQL EXISTS condition is a boolean function that returns true if the condition is met. The syntax is pretty simple: SELECT * FROM TABLE WHERE EXISTS(subquery); Alternatively, you can use NOT EXISTS(subquery). An example of the function is the

Tagged with: , ,
Posted in Database Administration

Error: Please make sure the Twitter account is public.