Answer / abhisekh

we can call a procedure using 2 ways
1.using exec <procedure>
2.using anonymous block< begin <procedure> end;
now coming to ur questions answer. crate a anonymous block and add the statements u wanted to execute first then call the procedure.

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---

What is clause?

0 Answers  

---

How do I run a sql query?

0 Answers  

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

---

What is database migration?

0 Answers  

---

---

What are primary key and foreign key and how they work?

0 Answers  

---

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

---

what is the difference between $message and $$message? : Sql dba

0 Answers  

---

what are the different index configurations a table can have? : Sql dba

0 Answers  

---

What's the difference between inner join and left join?

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

Can we create table in function?

0 Answers  

---