Jul 5 2012, 02:52 PM
Hi All ,
I was wondering with dba_constraints and i found unexpected result shown as below
select constraints_name, constraint_type from dba_constraints
i jst want to know that what is this system generated constraints ?
Jul 6 2012, 09:49 AM
>> i jst want to know that what is this system generated constraints ?
Your query is not complete enough to show the full details, but they look like "check" constraints".
Run the script here:http://www.dba-oracle.com/t_dba_constraints.htm
Here is what a check constraints does:http://www.dba-oracle.com/t_oracle_check_constraint.htm
Jul 13 2012, 06:01 AM
Dear Sir ,
Thanx for reply
you are right that these constraints are of "Check" constraints .
But i havent created them ,
then why these have been created ??
please reply ....
Jul 13 2012, 09:39 AM
>> why these have been created ??
They may be part of the Oracle data dictionary, you need to dig deeper to see!
1 - Query dba_constraints to get the table name
2 - Run dbms_metadata to get the table definition, and the check constraoints will appear. Here's how:http://www.dba-oracle.com/art_builder_get_schema_syntax.htm