Patrick Barel
banner
patch72.bsky.social
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.
Reposted by Patrick Barel
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…
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.
www.geraldonit.com
July 30, 2025 at 1:00 PM
Reposted by Patrick Barel
I agree with what the author of this post says :)
January 28, 2025 at 8:48 PM
Reposted by Patrick Barel
🚀 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!
Meetup: Ontdek de Kracht van Feature X (exclusieve sessie) | Oracle User Group
nloug.nl
January 8, 2025 at 4:21 PM
Reposted by Patrick Barel
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-...
December 20, 2024 at 9:43 AM
Reposted by Patrick Barel
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
December 9, 2024 at 12:00 PM
Reposted by Patrick Barel
#Oracle #Database 23.6 Free multi-platform images now available on gvenzl/oracle-free
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.
geraldonit.com
December 8, 2024 at 1:41 AM
Almost done packing for the #UKOUG conference in Birmingham.
November 30, 2024 at 7:06 AM
Reposted by Patrick Barel
Or (and?) use the built in use case domain EMAIL_D when you’re on Oracle 23ai in your datamodel
November 25, 2024 at 11:25 AM
A little over a week from now I'll be speaking at
#UKOUGDiscover24
in Birmingham (Sunday-Tuesday).

See you there.
November 25, 2024 at 11:18 AM
Reposted by Patrick Barel
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
November 21, 2024 at 10:58 AM
Reposted by Patrick Barel
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…#apexworld20252#orclapexex
November 18, 2024 at 2:35 PM
Reposted by Patrick Barel
Starter pack of #SYM42 Symposium 42 members

go.bsky.app/AnE4rQH
November 14, 2024 at 7:27 PM
Reposted by Patrick Barel
Many have found an initial set of accounts to follow by going to this starter pack go.bsky.app/FvKfw4q and click "Follow all"
November 14, 2024 at 7:47 PM
Reposted by Patrick Barel
it's official — 1,000,000 people have joined Bluesky in just the last day!!!

welcome and thank you for being here 🥳
November 15, 2024 at 12:53 AM
Reposted by Patrick Barel
Another good Oracle-related starter pack from @gvenzl.bsky.social

go.bsky.app/E5TV5rS
November 15, 2024 at 4:35 AM
Reposted by Patrick Barel
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.
November 14, 2024 at 11:39 PM
Reposted by Patrick Barel
Having left the HellSite for good, I am now here. Feel free to connect with me on technology and for community.
November 12, 2024 at 3:45 PM
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
social.ora.cl
November 9, 2024 at 6:28 AM
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 
January 17, 2024 at 4:51 PM
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.
January 6, 2024 at 6:30 PM
Reposted by Patrick Barel
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
November 16, 2023 at 4:04 PM
Thanks for the #oracleace swag @oracleace.
Glad to be part of the program.
November 13, 2023 at 4:01 PM
Reposted by Patrick Barel
Breaking! News Flash!

#ODTUG #Kscope24 Call for Abstracts is now open!

kscope24.odtug.com/page/kscope2...

Want to share your knowledge in Music City Nashville next July?

Time to write your abstracts, then, and submit them now.

You have until Sunday December 10th.
November 8, 2023 at 9:38 AM
Reposted by Patrick Barel
📝✨Agenda announcement! ✨📝

We're happy to announce the agenda for the first-ever Database Circle Conference in Zurich! 💬

Have a look at the fantastic speaker line-up, and get your ticket today! 🎫

swissouc.ch/events/dcc20...
#SwissOUC #DCC2024 @oracleace
Agenda - Swiss Oracle User Community - SwissOUC
The agenda of the Database Circle Conference 2024, hosted in the Oracle office at The Circle in Zurich on 30-31 January 2024.
swissouc.ch
November 1, 2023 at 10:53 AM