Does a join table need a primary key?

0 Answers  

---

What is date functions?

0 Answers  

---

What is data profiling in sql?

0 Answers  

---

what is sql and plsql

6 Answers  

---

What is trigger and types?

0 Answers  

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---

Can we have two clustered index on a table?

0 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---