Answer Posted / sandeep desai

No.
Eg:-
Consider Table emp
Assume there are only 5 records in emp
and in emp_sal column values are (1200,1400,4500,2000).
Now if I try to create a check constraint on emp_sal column
for the range between 2000 and 4000 then an error is thrown
since values below this range also exist in emp_sal column.

What is oracle analytical function?

1032

---

How to add another datafile to a tablespace?

994

---

How to see the table columns used in an index?

961

---

How to store only time; not date and time?

960

---

How data locks are respected in oracle?

1013

---

How to increment dates by 1 in oracle?

992

---

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

962

---

How to grant create session privilege to a user in oracle?

948

---

How to empty your oracle recycle bin?

982

---

Difference between varchar and varchar2 data types?

1118

---

Explain implicit cursor.

963

---

How to rename an index?

997

---

How can windows applications connect to oracle servers?

986

---

Can you create a synonym without having a table?

980

---

What are the common oracle dba tasks?

1072

---