Define Normalization with example?

1 Answers  

---

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

---

Explain implicit cursor.

0 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

does the query needs a hint to access a materialized view?

1 Answers  

---

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

What is a OUTER JOIN?

1 Answers  

---

How to Remove the 3rd highest salary person record from table?

9 Answers   HCL, IBM,

---

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers  

---

What is a package in oracle?

0 Answers  

---

Explain cascading triggers.

0 Answers  

---

How to define a procedure inside another procedure?

0 Answers  

---