Which of the following is the correct syntax to declare explicit cursor?

90. Which of the following is the correct syntax to declare explicit cursor?

  1. CURSOR IS name
    SELECT statement;
  2. CURSOR name is
    Statement SELECT;
  3. Name IS CURSOR
    SELECT statement;
  4. CURSOR name IS
    SELECT statement;

Answer: D)

CURSOR name IS
SELECT statement;

Explanation:

The correct syntax to declare explicit cursor is –

CURSOR name IS
SELECT statement;

Comments and Discussions!





Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.