Answer Posted / vijay kumar jakkam

1. A CHECK constraint evaluates to TRUE when the resulting value of the CHECK constraint expression is unknown, e.g. when the expression contains NULL.

Example: A CHECK constraint that enforces the value of a particular column to be >0 evaluates to TRUE if NULL passed while inserting.
2. CHECK Constraints are not evaluated for delete statements.

Explain cascading triggers.

1118

---

How to write a query with a left outer join in oracle?

1123

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2295

---

How to delete a column in an existing table?

1129

---

What is the difference between sharding and partitioning?

1038

---

How to upsert (update or insert into a table)?

1042

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2196

---

How to store pictures on to the database?

1030

---

What is the difference between count (*), count (expression), count (distinct expression)?

1046

---

How to create an oracle database?

1099

---

What are the restrictions on external table columns?

1107

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2089

---

Is there an oracle sql query that aggregates multiple rows into one row?

1021

---

How to manage transaction isolation level?

1054

---

How to create id with auto_increment on oracle?

1037

---