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 parameter substitution in sql?

528

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

678

---

What are the different types of database management systems?

532

---

what is the different between now() and current_date()? : Sql dba

526

---

What is sql*loader?

576

---

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

530

---

What types of commands can be executed in sql*plus?

554

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3209

---

What is data abstraction in sql?

515

---

describe mysql connection using mysql binary. : Sql dba

552

---

Can we join 3 tables in sql?

499

---

Mention what is the plv (pl/vision) package offers?

643

---

how do you know if your mysql server is alive? : Sql dba

602

---

Why is theta join required?

668

---

Which tcp/ip port does sql server run?

538

---