Answer Posted / saleem

1) Implicit: declared for all DML and pl/sql statements.
By default it selects one row only.
2) Explicit: Declared and named by the programmer.
Use explicit cursor to
individually process each row returned by a
Multiple
statements, is called ACTIVE SET.
Allows the programmer to
manually control explicit cursor in the
Pl/sql block
a) declare: create a named sql area
b) Open: identify the active set.
c) Fetch: load the current row in to variables.
d) Close: release the active set.

CURSOR ATTRIBUTES
a) %is open: evaluates to true if the cursor is open.
b) %not found: evaluates to true if the most recent fetch
does not return a row
c) %found: evaluates to true if the most recent fetch
returns a row.
d) %row count: evaluates to the total number of rows
returned to far.

Example for cursor:
1) Declare
Vno emp.empno%type;
Vname emp.ename %type;
Cursor emp_cursor is
Select empno,ename
From emp;
Begin
Open cursor;
For I in 1..10 loop
Fetch emp_cursor into vno,vname;
Dbms_output.putline(to_char(vno) ||? ?||vname);
End if;
E nd;

2) Begin
Open emp_cursor;
Loop
Fetch when emp_cursor % rowcount >10 or

Emp_curor % not found;
Bdms_output_put_line(to_char(vno)||? ?||
vname);
End loop;
Close emp_cursor;
End;

CURSOR FOR LOOP
A) cursor for loop is a short cut to process explicit cursors
B) it has higher performance
C) cursor for loop requires only the declaration of the
cursor, remaining things like opening, fetching and close
are automatically take by the cursor for loop

Example:
1) Declare
Cursor emp_cursor is
Select empno,ename
From emp;
Begin
For emp_record in emp_cursor loop
Dbms_output.putline(emp_record.empno);
Dbms_output.putline(emp_record.ename)
End loop
End;

What is a flexfield? List out its types.

1170

---

How can you achieve loose coupling in soa framework?

1226

---

In sequence i want to 11 and 15th values how we will write?

2077

---

In support project one ticket alloted which steps follows manualy tell me ?

2663

---

What are the benefits of using soa architecture?

1251

---

Can u give the Documentation of Custom.pll in oracle apps

3478

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2266

---

tell my any difficult situtation you solved in your experience in your company?

2318

---

Which oracle apps version you are very confident in?

1209

---

What is instead of trigger in where we will use?

1176

---

Can you explain the difference between architecture followed in 10g & 11g?

1070

---

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

1066

---

what are the different transaction clauses in AR?

2121

---

please send me forms, xml pulisher questions,answers

2113

---

tell me the scenarios of the independent in reports

2626

---