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 an oracle and why it is used?

1127

---

How to load data from external tables to regular tables?

1039

---

Is java required for oracle client?

971

---

What is a data dictionary and how can it be created?

1116

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2280

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1665

---

What is integrity and what is constraint??Explain with example

2257

---

6. Display the client name and order date for all orders using the traditional method.

2289

---

What is system tablespace?

1074

---

How to define a sub function?

1107

---

How to define an oracle cursor variable?

1008

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2165

---

What is an Oracle Instance?

1104

---

How to define a variable to match a table column data type?

967

---

What is materialized view in Oracle?

1059

---