Answer Posted / rajesh venati

A Procedure is a Named Pl/Sql program. Procedures are used
for to perform a particular task. Overloading concept is not
allowed in standard alone procedures.

Then go for Packages, package is grouping the collection of
database objects like procedures, functions, type, variable,
cursors and exception etc... Here overloading concept is
valid, we can define same name for database objects with
different type of parameters or data types.....

I believe this is useful.................

Explain what is dbms?

1114

---

What is denormalization in a database?

1103

---

How do I filter in sql profiler?

1044

---

How do you explain an index number?

1180

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1888

---

what is self-join? : Sql dba

1232

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1486

---

What is the location of pre_defined_functions.

1204

---

What are the different types of dbms?

1058

---

What is trigger in sql and its types?

1107

---

How do we accept inputs from user during runtime?

1114

---

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

1238

---

How to change the order of columns in Oracle SQL Plus ?

1100

---

Can we use ddl statements in stored procedure?

1188

---

How subquery works in sql?

1122

---