Interested to Buy Any Domain ? << Click Here >> for more details...
Stored procedure?
- 4 Answers
- 8614 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amit shrivastava
Stored Procedure store in the database as a independent
obejct and can call directly with proc name.
begin
proc_ex (e_name,e_no);
end;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / saleem
Stored procedure is a sequence of statements that perform
specific function.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kranthi
A stored Procedure is the one which is stored in the
database in a compiled format.Can be used directly as it is
in compiled format.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sannidhi84
it is a set of sql statements ...where all dml operations
can be done and dql operations as welll...it is stored in
database as compiled format.
| Is This Answer Correct ? | 0 Yes | 1 No |
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
How to migrate .rdf file from dev instance to test instance?
3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,
what is the prerequisite for defining unit of measure?
suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What is FORWARD DECLARATION in Packages?
6 Answers British Telecom BT, HCL, Tech Mahindra,
hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me
2 Answers Pathway Technologies,
cursor 1 and cursor 2 are there did you open both the cursors at a time or not?
How does accounting occured in Expense Reporting?
What are the different components of soa suite?
what is the defference between credit memo and debit memo
What are the benefits of using soa architecture?
Oracle Apps Technical 
