• About
  • All Posts
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists

Tag: array processing

January 15, 2021 Uncategorized

PL/SQL in 21c gets amazing new loop iterators

“It’s a dead language” people said. “There’s never anything new” people said. Well, let me serve those people a slice

Continue reading

April 24, 2020 Uncategorized

SQL Plus and the ROWPREFETCH parameter

Need to get a bunch from rows out of the database? Most people are aware of the ARRAYSIZE parameter to

Continue reading

April 9, 2019 Uncategorized

Bulk processing with FORALL and INSERT-SELECT

I’m sure most of us have read or heard at a conference the benefits of array fetching and array binding

Continue reading

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • Blockchain tables are here in 19c!
  • Archives
  • No more stale statistics in 19c
  • My APEX was fine and then it wasn't
  • Pluggable database and restricted sessions
  • APEX 20.2 comes to town (well, to my PC)
  • How to do a GRANT on an entire schema
  • Extended VARCHAR2 and the hidden LOB
  • Complex materialized views and fast refresh
  • PL/SQL in 21c gets amazing new loop iterators
Blog at WordPress.com.