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 are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1039

---

Is sql procedural language?

962

---

How to avoid using cursors?

1117

---

Is left join same as join?

986

---

What do you mean by stored procedures?

1008

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

971

---

What is string join?

974

---

what are local and global variables and their differences? : Sql dba

1070

---

how many values can the set function of mysql take? : Sql dba

982

---

When can we use the where clause and the having clause?

1016

---

Can we connect to postgresql using sql developer?

1000

---

What is character functions?

1059

---

What is indexes?

1054

---

what is bcp? When is it used?

1104

---

What is clustered and nonclustered index in sql?

939

---