why dont we assign not null constraint as table level constraint.

0 Answers  

---

How to pass a cursor variable to a procedure?

0 Answers  

---

What is catalog in Oracle?

0 Answers   MCN Solutions,

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

how to retrive xml data for using sql query?

3 Answers   IBM, TCS,

---

---

How do you rate yourself in oracle and sql server ?

2 Answers   Keane India Ltd,

---

How index is implemented in oracle database?

0 Answers  

---

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

7 Answers   Cognizant, IBM,

---

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

2 Answers   Wipro,

---

How do you store pictures in a database?

0 Answers  

---

What is the sid in oracle?

0 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---