OraFAQ Forum: SQL & PL/SQL » How is naming Integrity Constants helpful?

Home » SQL & PL/SQL » SQL & PL/SQL » How is naming Integrity Constants helpful? (11g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How is naming Integrity Constants helpful? [message #578072]

Sun, 24 February 2013 04:23

ashishpatel1992
Messages: 38
Registered: February 2013
Location: India

Member

How is naming Integrity Constants helpful?
See example below:-

create table incrr
  (incrid   number(4)   constraint incrid_pk primary key,
   incrdate date        not null,
   incramt  number(8,2) not null
  );

In the above if I don't use incrid_pk it also works.
Then what is the use of incrid_pk ?
Regards,
Ashish

[EDITED by LF: removed huge font formatting, reformatted code, applied [code] tags]

[Updated on: Sun, 24 February 2013 09:47] by Moderator

Report message to a moderator

Re: How is naming Integrity Constants helpful? [message #578073 is a reply to message #578072]

Sun, 24 February 2013 04:26

Michel Cadot
Messages: 54129
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

To easily find it when you search for primary keys or for objects related to your table.
Oracle does not care about the name you give, it is just for you (and the guys that will maintain your database or application).

Regards
Michel

Report message to a moderator

Re: How is naming Integrity Constants helpful? [message #578074 is a reply to message #578073]

Sun, 24 February 2013 04:27

ashishpatel1992
Messages: 38
Registered: February 2013
Location: India

Member

How can I view the constraints defined by user?

Report message to a moderator

Re: How is naming Integrity Constants helpful? [message #578075 is a reply to message #578074]

Sun, 24 February 2013 04:38

dariyoosh
Messages: 229
Registered: March 2009
Location: Iran / France

Senior Member

ashishpatel1992 wrote on Sun, 24 February 2013 11:27

How can I view the constraints defined by user?

Take a look at USER_CONSTRAINTS

Regards,
Dariyoosh

Report message to a moderator

Re: How is naming Integrity Constants helpful? [message #578076 is a reply to message #578075]

Sun, 24 February 2013 04:40

ashishpatel1992
Messages: 38
Registered: February 2013
Location: India

Member

Is it mandatory to have these constraint name unique with respect to all tables under that user.
Regards,
Ashish

Report message to a moderator

Re: How is naming Integrity Constants helpful? [message #578077 is a reply to message #578076]

Sun, 24 February 2013 04:43

dariyoosh
Messages: 229
Registered: March 2009
Location: Iran / France

Senior Member

ashishpatel1992 wrote on Sun, 24 February 2013 11:40

Is it mandatory to have these constraint name unique with respect to all tables under that user.
Regards,
Ashish

All you need to do is try to create a constraint with an already assigned name (to another database object) and see what oracle tells you.

Regards,
Dariyoosh

Report message to a moderator

Re: How is naming Integrity Constants helpful? [message #578078 is a reply to message #578077]

Sun, 24 February 2013 04:52

ashishpatel1992
Messages: 38
Registered: February 2013
Location: India

Member

It says
name already used by an existing constraint
Thank you So Much for help. You are great!

Report message to a moderator

Previous Topic:	FIND INVOICE NOS AGAINST BALANCE VALUE
Next Topic:	Need query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 22:58:38 CDT 2013

Total time taken to generate the page: 0.18447 seconds