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;

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1003

---

How many segment are present in Oracle Manufacturing

2053

---

What is chargeback invoice? How do we create it? : oracle accounts receivable

1045

---

Explain the use of table functions.

2078

---

as a technical developer in oracle applications which type errors feced in your experience sofar

2108

---

What is an Oracle database Full Backup?

856

---

What is auto invoicing? Explain : oracle accounts receivable

808

---

What is an Oracle database Partial Backup?

920

---

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1992

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1006

---

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

1855

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1030

---

which one is currently in used software cmpanies.

1883

---

8. Supporting AP, AR and GL?

2063

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1792

---