Search:

Type: Posts; User: vikram.magoo; Keyword(s):

Search: Search took 0.02 seconds.

  1. Answers
    8
    Views
    108,404

    Oracle Re: How to view constraints?

    you can also use the statement -- select * from all_constraints where table_name ='EMP'; to view the constraints available from other Owners/Users also.
  2. Answers
    8
    Views
    108,404

    Oracle Re: How to view constraints?

    SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME='EMP';
    (This will list you all the constraints from that particular user in which you are logged in.)


    WHERE AS you can also use the following...
Results 1 to 2 of 2
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact