Software is art

The world needs software. Software needs you.

Tuesday, May 7, 2013

How to get the details about any constraint in Oracle XE?


When you do some SQL statement in oracle, it throw an exception when your statement violate some constraint. But the error doesn't show about what table the constraint is related, showing just the constraint name.

To show the constraint details just execute the follow sql statement:

SELECT CONSTRAINT_NAME, TABLE_NAME FROM USER_CONSTRAINTS WHERE CONSTRAINT_NAME='FK1_MY_CONSTRAINT_NAME';

Posted by ed at 1:26 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: oracle

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Ads

Blog Archive

  • ►  2014 (1)
    • ►  January (1)
  • ▼  2013 (8)
    • ►  July (5)
    • ▼  May (2)
      • Design is more about words than images?
      • How to get the details about any constraint in Ora...
    • ►  February (1)
  • ►  2012 (5)
    • ►  September (1)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  January (1)
  • ►  2011 (9)
    • ►  November (9)
Simple theme. Powered by Blogger.