Answer Posted / madhuri

We can call a procedure into another procedure.

create or replace procedure proc1(empno number) is
begin
proc2(20,'CLERK');
end;

When we execute proc1 as follows
exec proc1(7891);

it will execute proc1 and proc2 as well

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1089

---

Can we call a function containing dml statements in a select query?

979

---

What is the use of desc in sql?

977

---

How is a process of pl/sql compiled?

1160

---

Is sql port 1433 encrypted?

1023

---

What will you get by the cursor attribute sql%rowcount?

1038

---

What is orm in sql?

1047

---

What is sql deadlock?

1141

---

Is sql developer case sensitive?

997

---

how to concatenate two character strings? : Sql dba

1101

---

what is the syntax for using sql_variant_property? : Transact sql

1044

---

Why commit is not used in triggers?

1038

---

What are the most important characteristics of pl/sql?

1157

---

How to select random rows from a table?

1075

---

How do I start pl sql?

947

---