• About
  • All Posts
  • The Podcast!
  • 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
  • The Podcast!

Tag: functions

July 3, 2019 Uncategorized

Same dog, different leash – functions in SQL

Let’s start with this somewhat odd looking result. I have an inline function that returns a random number between 0

Continue reading

May 31, 2019 Uncategorized

With and without WITH_PLSQL within a WITH SQL statement

OK, let’s be honest right up front. The motivation for this post is solely to be able to roll out

Continue reading

March 28, 2019 Uncategorized

Do not set DETERMINISTIC on functions unrealistically

I’m feeling very determined on this one. Yes I have a lot of determination to inform blog readers about determinism,

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.

Tweets by connor_mc_d

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • End of an era …
  • Why you keep getting "ORA-01653: unable to extend table"
  • Natural Keys versus Surrogate Keys….Here we are again!
  • No more stale statistics in 19c
  • How to TREAT data in a CLOB as JSON
  • Connection shortcuts with a wallet
  • Don't run tight on PGA
  • Pluggable database and restricted sessions
  • Generating INSERT scripts that run fast!
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 824 other followers
    • Already have a WordPress.com account? Log in now.
    • Learning is not a spectator sport
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar