Answer Posted / neeraj siddhey

Overloading: Multiple subprograms of the same name

• Enables you to use the same name for different
subprograms inside a PL/SQL block, a subprogram, or a
package

• Requires the formal parameters of the subprograms to
differ in number, order, or data type family

• Enables you to build more flexibility because a user or
application is not restricted by the specific data type or
number of formal parameters

Note: Only local or packaged subprograms can be overloaded.
You cannot overload stand-alone subprograms.

Why do we need a foreign key?

1014

---

What is a ddl command?

1003

---

Can we enter data in a table in design view?

910

---

What is package in pl sql with an examples?

967

---

What are the various restrictions imposed on view in terms of dml?

906

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

955

---

Explain the the update statement in sql?

986

---

what is 'mysqlimport'? : Sql dba

973

---

Can a foreign key be a duplicate?

858

---

What is a common use of group by in sql?

994

---

Does varchar need length?

929

---

Is there a 64 bit version of ssms?

893

---

The select into statement is most often used to create backup copies of tables or for archiving records?

1000

---

How is data stored on a disk?

961

---

Why use truncate instead of delete?

957

---