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.

How do I clear the screen in sql plus?

553

---

What is the difference between having clause and where clause?

572

---

What is a pl/sql block?

595

---

Write a sql query to convert all character to uppercase after hypen.

962

---

What is trigger in sql? Explain

538

---

---

What does count (*) do in sql?

528

---

How do I create a sql database?

526

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

579

---

What are the different dcl commands in sql?

565

---

What is sql query limit?

510

---

Can we perform dml on view?

556

---

What is a temporal table?

497

---

How to execute a stored procedure?

565

---

How do I truncate a sql log file?

540

---

How insert into statements in sql?

595

---