conditions mentioned in the CHECK constraint must be a boolean exp,they c

What are the Limitations of a CHECK Constraint ?

Question Posted / priyanka

5 Answers
19030 Views
I also Faced
E-Mail Answers

Answer Posted / priyanka

conditions mentioned in the CHECK constraint must be a
boolean exp,they cannot be subqueries or sequences n
cannot include the SYSDATE,UID,USER, USERNV SQLfunctions

Is This Answer Correct ?

13 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a table index in oracle?

1067

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1810

Is oracle a relational database?

870

What is the difference between translate and replace in oracle?

1112

How to delete all rows a table in oracle?

1008

What are the attributes of cursor?

988

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2995

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1895

What is oracle join syntax?

941

What is the oracle implicit cursor?

998

What happens if you lost a data file?

978

Will you be able to store pictures in the database?explain.

928

How to commit the current transaction in oracle?

1042

How to revoke create session privilege from a user in oracle?

960

Explain a data segment?

1015