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
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…
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
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…
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…
Reposted by Patrick Barel
I agree with what the author of this post says :)
Learn why vector databases, and particularly multi-model databases, have become such a popular component of AI-driven architectures.
Why Vector Databases Are Here to Stay in the AI Age
Learn why vector databases, and particularly multi-model databases, have become such a popular component of AI-driven architectures.
thenewstack.io
January 28, 2025 at 8:48 PM
I agree with what the author of this post says :)
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!
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
🚀 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!
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!
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-...
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
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-...
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-...
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
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
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
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
Reposted by Patrick Barel
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
Or (and?) use the built in use case domain EMAIL_D when you’re on Oracle 23ai in your datamodel
A little over a week from now I'll be speaking at
#UKOUGDiscover24
in Birmingham (Sunday-Tuesday).
See you there.
#UKOUGDiscover24
in Birmingham (Sunday-Tuesday).
See you there.
November 25, 2024 at 11:18 AM
A little over a week from now I'll be speaking at
#UKOUGDiscover24
in Birmingham (Sunday-Tuesday).
See you there.
#UKOUGDiscover24
in Birmingham (Sunday-Tuesday).
See you there.
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
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
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
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
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
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
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
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
Reposted by Patrick Barel
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
Many have found an initial set of accounts to follow by going to this starter pack go.bsky.app/FvKfw4q and click "Follow all"
Reposted by Patrick Barel
Reposted by Patrick Barel
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.
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
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.
go.bsky.app/6kaBDaf
Please let me know who else should be added and apologizes if I left you out of the initial group.
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
Having left the HellSite for good, I am now here. Feel free to connect with me on technology and for community.
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
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
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
Oracle ACE
speakers on topics such as
23ai for Developers, Analytics, #Java, Oracle Apps, Multicloud solutions, and #OCI.
social.ora.cl/6019SYE5P
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
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
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
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
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
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.
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
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
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
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
Thanks for the #oracleace swag @oracleace.
Glad to be part of the program.
Glad to be part of the program.
November 13, 2023 at 4:01 PM
Thanks for the #oracleace swag @oracleace.
Glad to be part of the program.
Glad to be part of the program.
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.
#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
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.
#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.
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
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
📝✨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
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