DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: simple question

  1. 01-05-2001, 01:24 PM #1
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    a very basic question, when we do any select does Oracle open implicit cursors?
    Reply With Quote Reply With Quote
  2. 01-05-2001, 01:29 PM #2
    pwoneill
    pwoneill is offline Senior Member
    Join Date
    Jun 2000
    Posts
    417
    According to [url]http://www.fortunecity.com/skyscraper/oracle/699/orahtml/ioug/tunplsql.html[/url] yes. According to memory yes. However I don't know how good either of them are :)
    Reply With Quote Reply With Quote
  3. 01-05-2001, 01:51 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yes, any DML statement will open an implicit cursor,
    Jeff Hunter
    Reply With Quote Reply With Quote
  4. 01-05-2001, 07:34 PM #4
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    It is always better to write "EXPLICIT CURSOR" rather than a simple SQL statement (implicit cursor).
    In implicit cursor Oracle has to do 2 pass , one for fetching the data and other for checking error.
    Reply With Quote Reply With Quote
  5. 01-05-2001, 10:05 PM #5
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Well I mean normal query, not in PL/SQL. I guess in normal queries all cursosr are implicit
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width