Patrick Barel's Avatar

Patrick Barel

@patch72.bsky.social

SQL and PL/SQL (Oracle) geek. Love to build Delphi stuff. Oracle ACED. The views expressed are my own and do not necessarily reflect those of my employer.

576 Followers  |  143 Following  |  19 Posts  |  Joined: 16.08.2023  |  1.8152

Latest posts by patch72.bsky.social on Bluesky

Preview
Oracle Database 23.9 Free multi-platform images now available on gvenzl/oracle-free Oracle Database 23.9 Free multi-platform images are now available on container registries docker.io/gvenzl/oracle-free and ghcr.io/gvenzl/oracle-free. With this release, 23.7 images have now gone into Unsupported. See the support matrix for more information.

Just updated my gvenzl/oracle-free images to #Oracle #Database 23.9 #Free

02.08.2025 18:29 — 👍 18    🔁 5    💬 2    📌 0
Preview
Anatomy of a SQL statement SQL is a declarative, English-like domain language for querying, analyzing, and manipulating data. SQL originated from relational databases but has since seen wide adoption outside of them. Because SQL statements can almost be read as English sentences and its declarative nature, that is, users declare what results they want and not how to get to these results (the latter is the approach of imperative programming languages, such as C, Java, Python, etc), SQL is generally seen as one of the best high-level languages for analyzing data due to its easy-to-learn syntax.

Anatomy of a SQL statement

SQL is a declarative, English-like domain language for querying, analyzing, and manipulating data. SQL originated from relational databases but has since seen wide adoption outside of them. Because SQL statements can almost be read as English sentences and its…

30.07.2025 13:00 — 👍 2    🔁 2    💬 0    📌 0

It will get worse. In India there will be only one 🤔

23.05.2025 03:53 — 👍 3    🔁 0    💬 0    📌 0

I agree with what the author of this post says :)

28.01.2025 20:48 — 👍 6    🔁 1    💬 0    📌 0
Meetup: Ontdek de Kracht van Feature X (exclusieve sessie) | Oracle User Group

🚀 Ready to boost your data integrity like never before?

Discover Feature X of Oracle Database 23ai designed to revolutionize the way you will implement data integrity at our exclusive event.

Seats are limited—unlock the future of data management now: nloug.nl/events/meetu...

Don’t miss it!

08.01.2025 16:21 — 👍 8    🔁 3    💬 1    📌 0
Goeiemoggel! - KPN - TV reclame (2010)
YouTube video by tv commercials Goeiemoggel! - KPN - TV reclame (2010)

youtu.be/9PiQ6G7OohE

24.12.2024 08:13 — 👍 1    🔁 0    💬 0    📌 0

Ik word knetterbek van die sproetjes

24.12.2024 08:12 — 👍 1    🔁 0    💬 1    📌 0

Ik heb hier een sproetje

24.12.2024 08:03 — 👍 1    🔁 0    💬 1    📌 0
Post image

De nieuwste nlOUG Visie staat online!

In deze editie o.a.:

• Nieuwe features Oracle 23ai door Patrick Barel

• Jubileum editie APEX World

• SELECT AI functie van de Oracle DB door Robert Pastijn

Lees hem hier: nloug.nl/nloug-visie-...

20.12.2024 09:43 — 👍 4    🔁 4    💬 0    📌 1
Video thumbnail

Want to check if you can convert a value to another data type in Oracle Database?

Use

VALIDATE_CONVERSION ( <val> AS <data type>, <format> )

If <val> matches the format for the type it returns 1 else 0

The format mask is optional; if you omit this it uses your session's NLS settings

09.12.2024 12:00 — 👍 7    🔁 4    💬 0    📌 0
Preview
Oracle Database 23.6 Free multi-platform images now available on gvenzl/oracle-free Oracle Database 23.6 Free multi-platform images are now available on container registries docker.io/gvenzl/oracle-free and ghcr.io/gvenzl/oracle-free.

#Oracle #Database 23.6 Free multi-platform images now available on gvenzl/oracle-free

08.12.2024 01:41 — 👍 57    🔁 31    💬 0    📌 0
Post image

Almost done packing for the #UKOUG conference in Birmingham.

30.11.2024 07:06 — 👍 25    🔁 0    💬 2    📌 0

Or (and?) use the built in use case domain EMAIL_D when you’re on Oracle 23ai in your datamodel

25.11.2024 11:25 — 👍 5    🔁 1    💬 0    📌 0

That would be a new tier in the ACE program ;-)

25.11.2024 11:56 — 👍 1    🔁 0    💬 1    📌 0
Post image

A little over a week from now I'll be speaking at
#UKOUGDiscover24
in Birmingham (Sunday-Tuesday).

See you there.

25.11.2024 11:18 — 👍 14    🔁 1    💬 2    📌 0
Post image

It's time to write abstracts!!

The call for papers for APEX World 2025, 15th edition is now open!

nloug.nl/en/events/ca...

#CfP #APEXWorld2025 #aw25 #15thEdition #orclAPEX #oracle #CallForPapers @oracleugs @oracleace

21.11.2024 10:58 — 👍 11    🔁 11    💬 0    📌 3
Post image

Are you a nlOUG member??

It’s going to be our 15th APEX World edition in 2025, so we’re going a little crazy...

We’ve got a total of 15 member tickets available for only € 150,00 per ticket.

Go get yours while stock lasts.
nloug.nl/events/apex-wo…

#apexworld2025 #orclapex

18.11.2024 14:35 — 👍 6    🔁 6    💬 0    📌 0

Starter pack of #SYM42 Symposium 42 members

go.bsky.app/AnE4rQH

14.11.2024 19:27 — 👍 16    🔁 10    💬 0    📌 2

Many have found an initial set of accounts to follow by going to this starter pack go.bsky.app/FvKfw4q and click "Follow all"

14.11.2024 19:47 — 👍 6    🔁 2    💬 2    📌 0
Video thumbnail

it's official — 1,000,000 people have joined Bluesky in just the last day!!!

welcome and thank you for being here 🥳

15.11.2024 00:53 — 👍 87480    🔁 8797    💬 2335    📌 1673

Another good Oracle-related starter pack from @gvenzl.bsky.social

go.bsky.app/E5TV5rS

15.11.2024 04:35 — 👍 17    🔁 10    💬 0    📌 0

And here's the APEX Starter Pack:

go.bsky.app/6kaBDaf

Please let me know who else should be added and apologizes if I left you out of the initial group.

14.11.2024 23:39 — 👍 14    🔁 5    💬 6    📌 0

Having left the HellSite for good, I am now here. Feel free to connect with me on technology and for community.

12.11.2024 15:45 — 👍 5    🔁 1    💬 0    📌 0

Don't miss the first Oracle ACE Virtual Conference, where you'll hear amazing
Oracle ACE
speakers on topics such as
23ai for Developers, Analytics, #Java, Oracle Apps, Multicloud solutions, and #OCI.
social.ora.cl/6019SYE5P

09.11.2024 06:28 — 👍 8    🔁 4    💬 0    📌 0

Links didn't work.
Marketplace link:
marketplace.visualstudio.com/items?itemNa...
Announcement blog:
www.thatjeffsmith.com/archive/2024...

18.01.2024 08:40 — 👍 0    🔁 0    💬 0    📌 0
Post image

It's here! @OracleSQLDev extension for VS Code is now available!

To get started, simply search for 'SQL Developer' in the VS Marketplace!

Marketplace link marketplace.visualstudio.com/items?itemName…
Announcement Blog
thatjeffsmith.com/archive/2024/0 

17.01.2024 16:51 — 👍 5    🔁 3    💬 2    📌 0

I will probably check the quizzes, I just don't want to play ranked anymore.

08.01.2024 16:52 — 👍 0    🔁 0    💬 1    📌 0

Today I decided to stop playing the quiz on devgym.oracle.com after playing for over 14 years, when it was the PL/SQL Challenge. Not that I don't like it, I just can't set my mind to it. Hope everybody else will keep playing and learning.

06.01.2024 18:30 — 👍 0    🔁 0    💬 1    📌 0

Have fun. Great tour.

03.12.2023 11:13 — 👍 1    🔁 0    💬 0    📌 0
Post image

Are you attending POUG 2023?

Join me in my session “APEX: Debug like a pro” where I am showing you how I am investigating bugs and errors in Oracle APEX!

ORA-600 #poug2023 #debugging #lowcode @qualogy.bsky.social

16.11.2023 16:04 — 👍 1    🔁 1    💬 0    📌 0

@patch72 is following 20 prominent accounts