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.

Does group by remove duplicates?

537

---

Is there any restriction on the use of union in embedded sql?

663

---

Can we use ddl statements in stored procedure?

689

---

What is aggregate function in sql?

525

---

How many triggers can be applied to a table?

587

---

---

Is sql a microsoft product?

488

---

What are the sql versions?

509

---

What is field delimiter?

626

---

Explain the the update statement in sql?

562

---

how to use 'mysql' to run sql statements? : Sql dba

528

---

Can we create table inside stored procedure?

524

---

What is information schema in sql?

571

---

How do I upgrade sql?

535

---

Why we use triggers in mysql?

552

---

What found sql?

516

---