Answer Posted / venkat

A forward declaration looks like the package definition
part but is inside the bode.

e.g.

procedure A is
begin
B;
end A;

procedure B is
begin
null;
end B;

will not work, because during call to B B is still unknown
(1 Step compiler) therefore we need a forward declaration:

procedure B;

procedure A is
begin
B;
end A;

procedure B is
begin
null;
end B;


now we can compile

explain the difference between bool, tinyint and bit. : Sql dba

995

---

Can we insert in view in sql?

1054

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

971

---

how many sql dml commands are supported by 'mysql'? : Sql dba

1120

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1047

---

Can we rollback after truncate?

1029

---

How many types of primary keys are there?

1033

---

Enlist some predefined exceptions?

1055

---

What are all the common sql functions?

1014

---

What is snowflake sql?

1069

---

What is the difference between sum and count in sql?

984

---

What is the difference between instead of trigger and after trigger?

1007

---

What is a sql select statement?

1034

---

What is union and union all keyword in sql and what are their differences?

1100

---

Explain the insert into statements in sql?

1005

---