Explain the two type of Cursors?
Submitted by: AdministratorThere are two types of cursors, Implicit Cursor and Explicit Cursor.
PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.
Submitted by: Administrator
PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.
Submitted by: Administrator
cursor-->1>implicit
--->2>explicit
implicit-->provided by oracle (when dml statements are executed , there are some attributes to check status of cursor eg. %found,%notfound,%rowcount,%isopen )
explicit -->user defined(user defined, syntax-->
cursor cursor_name is select statement)
Submitted by: Bhaskar Choudhary
--->2>explicit
implicit-->provided by oracle (when dml statements are executed , there are some attributes to check status of cursor eg. %found,%notfound,%rowcount,%isopen )
explicit -->user defined(user defined, syntax-->
cursor cursor_name is select statement)
Submitted by: Bhaskar Choudhary
Read Online Oracle PL-SQL Job Interview Questions And Answers
Top Oracle PL-SQL Questions
☺ | Explian rowid, rownum?what are the psoducolumns we have? |
☺ | what is the starting oracle error number? |
☺ | What is difference b/w stored procedures and application procedures, stored function and application function? |
☺ | In a Distributed Database System Can we execute two queries simultaneously? Justify? |
☺ | Name the tables where characteristics of Package, procedure and functions are stored? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |