Answer Posted / aleena

PROCEDURE:

cannot return a value

SYNTAX:
CREATE PROCEDURE procedure_name [argument datatype]
AS
BEGIN
sql statements
END;
/

FUNCTION:

returns a value

SYNTAX:

CREATE FUNCTION function_name [argument[IN] datatype]
RETURN datatype
AS
BEGIN
sql statements
END;
/


PACKAGES

Pakages are groups of functions,procedures,sql blocks
goruped together in a single unit.

there are two parts to creating a PACKAGE --1>CREATE
PACKAGE & 2> CREATE PACKAGE BODY

SYNTAX :
CREATE PACKAGE :

CREATE PACKAGE package_name
AS

FUNCTION function_name(datatype);
PROCEDURE procedure_name (datatype);
.......
.......(sql/plsql statements )
........
END;

CREATE PACKAGE BODY :

CREATE PACKAGE BODY packagebody_name
AS
FUNCTION function_name (datatype)
RETURN datatype
AS
.....
.....
.....
END function_name;
PROCEDURE procedure_name (datatype)
AS
......
.....
.....
END procedure_name
END PACKAGE;

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2021

---

How many segment are present in Oracle Manufacturing

2266

---

default triggers available for reports

2162

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2059

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2101

---

What is the difference between recovery and restoring of the oracle database?

1155

---

What is the difference between oracle media recovery and crash recovery?

1126

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2470

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2268

---

How would you go about increasing the buffer cache hit ratio?

2551

---

What is the importance of batch source set up in ar? : oracle accounts receivable

1201

---

how to replace not in with not exist?

3671

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4396

---

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2149

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2419

---