Answer Posted / sudhir kumar singh

procedure_name(a in number,b out varchar)
(
script of execution;

)
exec procedure_name(first_parameter,second_parameter);

What is normalization in a database?

622

---

How can you load microsoft excel data into oracle? : aql loader

624

---

Is sql microsoft?

556

---

What is record type in pl sql?

560

---

Is keyword pl sql?

566

---

---

Explain table and field in sql?

599

---

Why do we use function in pl sql?

567

---

How many aggregate functions are available there in sql?

536

---

How does sql store data?

499

---

What is a trigger word?

522

---

What are primary key and foreign key and how they work?

565

---

what is data manipulation language? : Sql dba

541

---

Why is pl sql used?

537

---

Why is nosql good?

607

---

Explain how exception handling is done in advance pl/sql?

563

---