Oracle PL/SQL - Why Cursor Variables Are Easier to Use than Cursors

Interview Question Database For Software Developers

Categories:
    .NET (561)
    C (56)
    C++ (1)
    CSS (83)
    DBA (2)
    General (25)
    HTML (43)
    Java (64)
    JavaScript (97)
    JSP (44)
    JUnit (31)
    MySQL (292)
    Networking (10)
    Oracle (438)
    Perl (8)
    Perl (2)
    PHP (259)
    PL/SQL (137)
    RSS (51)
    Software QA (18)
    Struts (20)
    XHTML (197)
    XML (58)

Atom Atom feed

Index List view

Developer Resources

Java JAR Files

DLL Files

DBA Resources

Software QA Resources

Programming Tutorials

Biotech Resources

Link Directories

Windows Tutorials

Interview Q & A

FYIcenter Forum
[ Home | What's new | What's popular | Add a question ]
Top > Oracle > PL/SQL
Why Cursor Variables Are Easier to Use than Cursors
Why Cursor Variables Are Easier to Use than Cursors? - Oracle DBA FAQ - Working with Cursors in PL/SQL
By: FYIcenter.com

Cursor variables are easier to use than cursors because:

  • Cursor variables are easier to define. No need to give a specific query statement.
  • Cursor variables are easier to open. You can specify the query dynamically at the time of open.

  • Cursor variables can be passed into procedures or functions.
ID: 751 | Rank: 1094 | Votes: 0 | Views: 53 | Submitted: 20070428
Rate this item:
Vote total counts:1
Vote total score:0  :-)
Your vote:
:-(-3-2-1+1+2+3:-)
 

Submit your comment:
Comment:
(< 2048 char.)
Your Name:
  (All fields are required.)
Related Items:
How To Loop through a Cursor Variable
How To Loop through a Cursor Variable? - Oracle DBA FAQ - Working with Cursors in PL/SQL...                                                                                  
Submitted: 20070428
How To Pass a Cursor Variable to a Procedure
How To Pass a Cursor Variable to a Procedure? - Oracle DBA FAQ - Working with Cursors in PL/SQL...                                                                          
Submitted: 20070428
Why Cursor Variables Are Easier to Use than Cursors
Why Cursor Variables Are Easier to Use than Cursors? - Oracle DBA FAQ - Working with Cursors in PL/SQL...                                                                    
Submitted: 20070428
Can DML Statements Be Used in PL/SQL
Can DML Statements Be Used in PL/SQL? - Oracle DBA FAQ - Working with Database Objects in PL/SQL...                                                                          
Submitted: 20070428
Can DDL Statements Be Used in PL/SQL
Can DDL Statements Be Used in PL/SQL? - Oracle DBA FAQ - Working with Database Objects in PL/SQL...                                                                          
Submitted: 20070428
[ Home | What's new | What's popular | Add a question ]

How To Perform Key W...

How To Perform Key Word Search in Tables? - PHP Script Tips - Working with MySQL Database...                                                                      

interview.fyicenter.com/263...

Is the Order of Colu...

Is the Order of Columns in the SET Clause Important? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements...                                      

interview.fyicenter.com/1121...

What Is Union...

What Is Union? - MySQL FAQs - Database Basics and Terminologies...                                                                                                

interview.fyicenter.com/940...

How can you cache di...

How can you cache different version of same page using ASP.NET cache object ?...                                                                                  

interview.fyicenter.com/1632...

Relation between HTM...

What Is the Relation between HTML and XHTML?...                                                                                                                    

interview.fyicenter.com/138...