Interested to Buy Any Domain ? << Click Here >> for more details...
What is implicity cursor . When it fires . For which
statement it will fire(Insert/update/delte).
What is the attribute of implicity and explicity cursor
oracle 9i.
What is the Rec cursor.
- 2 Answers
- 7989 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
oracle automatically creates area for DML operations
programmer ill not have control for this cursor.
%found,%notfound,%rowcount,%isopen
Explicit cursor is user has to declare and open and
fetch for DML sql statment into this cursor explicit cursor
attributes are
sql%found,sql%notfound,sql%rowcount,sql%isopen
refcursor is datatype,a variable created based on such a
datatype is generally called cursor variable associated
with different queries at run-time.,by using this variable
capability to pass result sets between subprograms.
| Is This Answer Correct ? | 3 Yes | 0 No |
Form development process?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
What is the use of format trigger?
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
The report output is 10 pages then how many times between pages report trigger will fire?
Is that Possible To create package Overloading , If Yes Give any Examples
Who information?s?
How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
Exception Handilings?
what are the prerequisite set ups for inter organization transaction?
The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.
How can we import the data into a database using sql * loader?
Oracle Apps Technical 
