Skip to content
  • Oracle
  • About
  • Oracle
Search
Close

– nice theory…

– Good and not so good ideas on software development and Oracle databases in particular

Category: Built-in functionality

Proxy user logon #JoelKallmanDay

October 11, 2022 NiceTheoryVidarLeave a comment

Are you using proxy logon when connecting to your Oracle database? Why not?

Read More »

Find bad performing queries or code with PL/Scope

November 30, 2018December 4, 2018 NiceTheoryVidar5 Comments

On our production system we’ve enabled the collection of PL/Scope metadata. Since this is a SmartDB/PinkDB-application (business logic and queries in the database), this makes it really easy to find, inspect and modify the source code of queries that doesn’t run efficiently. Now it’s even easier using reports in Oracle SQL Developer.

Read More »

Scripts from my PL/Scope presentation at Code One

October 22, 2018 NiceTheoryVidarLeave a comment

Thanks to all of you that attended my PL/Scope session at Code One in San Fransisco!

You can find the scripts from my presentation about using PL/Scope to find your way through a PL/SQL code base in my github repository here: https://github.com/nicetheory/PL-Scope

Read More »

Where the partitions have no name

September 20, 2018September 20, 2018 NiceTheoryVidarLeave a comment

Working on a routine for dropping old partitions from a log table, I realized that I don’t have to know the name of the partition I want to drop. I can just specify a value for the partition key and Oracle resolves the partition for me. Here’s how.

Read More »

Matching strings with a combination of tools

February 28, 2018February 28, 2018 NiceTheoryVidarLeave a comment

I had a case where I had to match some names and needed to find a set of ways to clean and match strings. The solution I ended up with was a combination of regular expressions, the NLSSORT-function and the UTL_MATCH-package with the Jaro-Winkler algorithm.

Read More »

TRIM: More than meets the eye

January 18, 2018January 19, 2018 NiceTheoryVidarLeave a comment

I’ve always just used the TRIM-function to remove leading and trailing spaces. While going through Markus Winands presentation “Four* Major Database Release of 2017 in Review” on SlideShare.net, I realized that the TRIM function can do more than just remove spaces.

Read More »

Categories

  • Oracle (29)
  • PL/SQL (11)
  • Optimization (9)
  • Coding practice (7)
  • PL/Scope (7)

Tags

  • Oracle (16)
  • PL/SQL (11)
  • SmartDB (9)
  • 12c (6)
  • PL/Scope (6)

Year

  • 2022 (2)
  • 2021 (1)
  • 2020 (1)
  • 2019 (3)
  • 2018 (13)
Blog at WordPress.com.
Back to top
  • Follow Following
    • - nice theory...
    • Already have a WordPress.com account? Log in now.
    • - nice theory...
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar