SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Constraints Not found.....

Satyaki_DeMay 24 2007 — edited May 24 2007

Hi!
I've a table in a schema say SCOTT and there is a public synonym witht he same name in HR schema. Now, from HR schema how can i check the constraints details of that table? Because there there is no data in user_constraints or in user_cons_columns regarding this table. Thanks in advance.

Regards.

Satyaki De.

N.B.: if i use toad - it is able show the constraints. My question is - from where it is picking those data.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2007

Added on May 24 2007

4 comments

389 views