| Need help - 3 questions pls. [message #369883] |
Wed, 01 November 2000 22:53  |
Sonali Panda
Messages: 4
Registered: November 2000
|
Junior Member |
|
|
1. Is it possible to search & manipulate LONG columns via PL/SQL?
2. Can we use implicit & explicit cursors interchangeably?
3. What is the advantage of using named notation in passing parameters to procedures?
|
|
|
|
| Re: Need help - 3 questions pls. [message #369890 is a reply to message #369883] |
Thu, 02 November 2000 15:12  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
1. Yes, one can search & manipulate LONG columns via PL/SQL. See the PL/SQL scripts section for some examples.
2. Yes, you can use implicit & explicit cursors interchangeably.
3. Paramaters can be specified in any order if you use the named notation.
Hope it helps.
Best regards.
Frank Naude
|
|
|
|
| Re: Need help - 3 questions pls. [message #369893 is a reply to message #369883] |
Thu, 02 November 2000 19:45 |
Sonali Panda
Messages: 4
Registered: November 2000
|
Junior Member |
|
|
Dear Frank,
Thanks for your reply.
Can you please give me an example how we can use implicit & explicit cursors interchangeably? I think it means instead of implicit cursors we can use explicit and implicit cursors instead of explicit. Thanks again.
|
|
|
|
| Re: Need help - 3 questions pls. [message #369894 is a reply to message #369883] |
Thu, 02 November 2000 19:45 |
Sonali Panda
Messages: 4
Registered: November 2000
|
Junior Member |
|
|
Dear Frank,
Thanks for your reply.
Can you please give me an example how we can use implicit & explicit cursors interchangeably? I think it means instead of implicit cursors we can use explicit and implicit cursors instead of explicit. Thanks again.
|
|
|
|
| Re: Need help - 3 questions pls. [message #369901 is a reply to message #369894] |
Fri, 03 November 2000 13:33 |
Amit Chauhan
Messages: 74
Registered: July 1999
|
Member |
|
|
Hi,
Below is an example, First am printing using explicit cursor and then later as implicit cursor :
DECLARE
cursor c_emp IS
select empno, ename
from emp;
l_empno emp.empno%TYPE;
l_ename emp.ename%TYPE;
BEGIN
-- Explicit Cursor
OPEN c_emp;
LOOP
FETCH c_emp INTO l_empno, l_empname;
EXIT WHEN c_emp%NOTFOUND;
dbms_output.put_line (l_empno ||' '||l_empname);
END LOOP;
CLOSE c_emp;
-- Implicit Cursor
FOR c_rec IN c_emp LOOP
dbms_output.put_line (c_rec.empno||' '||c_rec.ename);
END LOOP;
END;
Hope it helps
Thanks
Amit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
