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 is the difference between microsoft sql and mysql?

709

---

What is pl sql and why it is used for?

799

---

How do you remove duplicate records from a table?

679

---

how to enter characters as hex numbers? : Sql dba

748

---

How do you write a complex sql query?

779

---

---

How do I find sql profiler?

683

---

What are the different type of joins in sql?

722

---

How can triggers be used for the table auditing?

755

---

How do I create a sql script?

761

---

Can we use pl sql in mysql?

711

---

What is trigger in pl sql with examples?

722

---

what is 'mysqld'? : Sql dba

706

---

What is a data definition language?

791

---

What is a sql*loader control file?

790

---

what are string data types? : Sql dba

701

---