Answer Posted / roopesh kumar

We can write a procedure with or w/o using parameters.

For procedure the simplest ex. could be like as

SQL> create or replace procedure tr ---calling procedure
2 as
3 begin
4 in_emp; -- Called procedure
5 end;
6 /

in this procedure i am calling another procedure inside
that.

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1089

---

Which is better join or subquery?

1064

---

explain the difference between delete , truncate and drop commands? : Sql dba

1015

---

Why do we use set serveroutput on?

923

---

Write a query to display the current date in sql?

967

---

Why having clause is used in sql?

926

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1536

---

Does db2 use sql?

889

---

What is java sql drivermanager?

1020

---

Does sqlite need a server?

994

---

What is a data definition language?

1027

---

What is the difference between delete, truncate and drop command?

1060

---

What are the three pl sql block types?

946

---

Explain what is a database?

1037

---

Is left join faster than inner join?

1063

---