what is auto increment? : Sql dba

0 Answers  

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

What are the sql commands?

0 Answers  

---

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

---

what is denormalization. : Sql dba

0 Answers  

---

---

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?

4 Answers   KPIT,

---

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

---

What is Raise_application_error ?

1 Answers  

---

How do we tune the code?

2 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

Why use subqueries instead of joins?

0 Answers  

---

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

---