Answer / Shamim Ahmad

In PL/SQL Developer, you can run a SQL query by typing the query into the SQL work sheet and clicking 'Run' or pressing F5.

what is denormalization. : Sql dba

1 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

What is the difference between an inner join and an outer join?

1 Answers  

---

Why do we use partitions in sql?

1 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?

2 Answers  

---

What is a database? Explain

1 Answers  

---

What is the difference between row level and statement level trigger?

1 Answers  

---

What is the difference between view and stored procedure?

1 Answers  

---

What is the cause of mutating table error and how can we solve it?

1 Answers  

---

How run sql*plus commands that are stored in a local file?

1 Answers  

---

What are keys in sql?

1 Answers  

---

Difference between table function and pipelined function?

1 Answers  

---