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.

how to convert character strings to dates? : Sql dba

1041

---

what is offset-fetch filter in tsql? : Transact sql

931

---

Show the two pl/sql cursor exceptions.

1167

---

What are the types of records?

980

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1123

---

how would you enter characters as hex numbers? : Sql dba

968

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2151

---

How to select random rows from a table?

1062

---

What does count (*) mean in sql?

1555

---

What is compute?

1072

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1028

---

what does the t-sql command ident_current does? : Transact sql

965

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2209

---

Are dml statements autocommit?

1029

---

What is Difference Between Unique and Primary Key Constraints?

1094

---