State the difference between implict and explict cursors?
Submitted by: AdministratorImplicit Cursor are declared and used by the oracle internally. whereas the explicit cursors are declared and used by the user. more over implicitly cursors are no need to declare oracle creates and process and closes autometically. the explicit cursor should be declared and closed by the user.
Implicit cursors are used for single row query whereas explicit cursor is used for multiple row query
Submitted by: Administrator
Implicit cursors are used for single row query whereas explicit cursor is used for multiple row query
Submitted by: Administrator
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. |