Answer Posted / rabindra nath das

i declare 4 procedure in package specification but in package
body i write only 3 procedure. is it complie??//w
------------------------------------------------------
Ans:-It will show you 'Warning: Package Body created with compilation errors.'
PLS-00323: subprogram or cursor'4thpackage name' is declared in a package specification and must be defined in the package body

because in package specification you are define 4 package
so you need to define 4 package under package body.

What do you understand by pl/sql records?

526

---

how to show all tables with 'mysql'? : Sql dba

597

---

What are the advantages of indexing?

513

---

What mean sql?

576

---

What is the difference between a primary key and a unique key?

552

---

---

What is sqlerrd?

521

---

What is a natural join?

508

---

Is t sql a programming language?

538

---

What is oracle and pl sql?

656

---

What are the most important characteristics of pl/sql?

569

---

Is sql microsoft?

539

---

Explain mutating table error.

638

---

How do you concatenate in sql?

544

---

Is grant a ddl statement?

449

---

What is row_number () in sql?

533

---