Andrej Pashchenko 🇺🇦 💙💛 @Andrej_SQL
Database developer, data engineer, Oracle Ace Pro ♠ Born in Ukraine Views are my own blog.sqlora.com Joined November 2017-
Tweets213
-
Followers172
-
Following164
-
Likes802
MERGE ... RETURNING is now supported in #Oracle23ai. In my view, it deserves more visibility in the documentation — it wasn’t easy to find. Even LLMs still claim it doesn’t exist (some even invent error codes). #SQL #MERGE @oracleace blog.sqlora.com/en/merge-and-d…
Ten years after my first post on the quirks of MERGE and ORA-30926, I took a fresh look at how Oracle 23ai handles it. Clearer error messages, improved diagnostics, and fewer unnecessary restarts. Read the new blog post #Oracle23ai #SQL #MERGE @oracleace blog.sqlora.com/en/ora-30926-i…
Did you know that refreshing HCC-compressed materialized views with atomic_refresh=true can multiply storage usage over time? Small details can have massive impacts. Read the new blog post. #Exadata #Oracle #HCC @oracleace blog.sqlora.com/en/when-compre…
Get rows in one table with no match in another with either c1 NOT IN ( SELECT c2 ... ) NOT EXISTS ( SELECT ... where c1 = c2 ) These perform the same in Oracle #SQL ...unless C2 includes NULL values => NOT IN returns no rows! @Andrej_SQL explores blog.sqlora.com/en/not-in-vs-n…
My @AccentureDACH colleague @Andrej_SQL is going to talk about partition exhange at the @Hroug_Croatia #HROUG2024 conference @oracleace
Partition Exchange Reloaded by @Andrej_SQL at #hroug2024.
Everything you should know about block corruptions in #Oracledatabase with @CGohmannDE at #hroug2024
On this #JoelKallmanDay, I would like to follow up on my last year's post, comparing #SQL’s NOT IN and NOT EXISTS, focusing on their usage, interchangeability and some myths about performance differences. blog.sqlora.com/en/not-in-vs-n… #Oracledatabase
And if you want to use your existing views and let SQL macros "inject" parameter, you can check the second part (blog.sqlora.com/en/parameteriz…) of this post and also @StewAshton 's post: stewashton.wordpress.com/2024/04/24/sql…
And if you want to use your existing views and let SQL macros "inject" parameter, you can check the second part (blog.sqlora.com/en/parameteriz…) of this post and also @StewAshton 's post: stewashton.wordpress.com/2024/04/24/sql…
I am absolutely thrilled to be presenting at the #HROUG2024 for the first time. Thanks @Hroug_Croatia for accepting my talks. In just two weeks! See you there! @oracleace
There have been some changes and improvements to the Online Statistics Gathering for Bulk Loads over the last few years. Here is the new blog post: #oracledatabase @oracleace blog.sqlora.com/en/online-stat…
Join AOUG Anwenderkonferenz 2024 next week for many great sessions presented by Oracle ACEs 👉 @alexnuijten @Ambili_Thots @Andrej_SQL @JrgDoppelreiter @martinberger_ch @Mirela_RoOUG @RoelH @rsantrod @oraclesean @stefanoehrli social.ora.cl/60105VSQq #OracleACE
As a data engineer, do I have to worry about optimizer statistics? In the second part is a typical example of why the performance immediately after loading the data can be suboptimal if you don't take care of the stats. #oracledatabase @oracleace blog.sqlora.com/en/object-stat…
I will talk about optimizer statistics at #AOUG Conference on June 17th, in particular what my responsibilities as a data engineer are. I think it's very important that it's not seen as just a DBA's job. Here is just one simple example of why: blog.sqlora.com/en/object-stat… @oracleace
Der Call for Papers für die DOAG 2024 Konferenz + Ausstellung ist eröffnet! Bis zum 3. Juni könnt ihr ab sofort eure Beiträge einreichen und das Programm der großen Anwenderkonferenz aktiv mitgestalten. Wir freuen uns auf eure Einreichungen! #DOAG2024 scomp.ly/PbORz5G
Thanks @DOAGeV and organizing team for this awesome 10th #apexconn24 conference. And thanks to all attendies for your attention and feedback. I hope @josifabr and I could convince a few more people to check out #sqlmacros
Ready for crime investigation session at #apexconn24 with @monika_mitura @oracleace
Ella Martinez @EllaMartin67
145 Followers 235 Following Chief Executive Officer | Financial Innovation Expert \ Partner of a medical device company,\Wine collector,
Oliver Berger @OliverBergerBY
224 Followers 160 Following IT professional Dipl. Inf. - sportsman - curious mortal - EV Enthusiast
E. Yescas C. @yescas123
153 Followers 1K Following Working on warehouse automation software business since it was a futuristic thing to do. Personal account.
Diego Armando Acosta @diegomalaver87
0 Followers 87 Following
Quanwen Zhao @quanwen_zhao
648 Followers 619 Following Being fond of communicating Oracle Tech with some domestic and overseas guys, is @oracleace alumni and any opinions are my own.
Michael Stoelting @mstoelting
61 Followers 47 Following
Cristian Echenique @cechenique2
99 Followers 214 Following Ing. Civil Informático, mitad chileno y mitad brasilero.
Maryse Zemlak @MaryseZeml78863
3 Followers 297 Following
Con @sudera_
13 Followers 488 Following
Annie Salazar @ajsaccount2
851 Followers 7K Following I am a management consultant who specializes in computer systems. I also teach business school.
Victoria @DyjairsUkdcAOn
27 Followers 710 Following
Nelson Calero @ncalerouy
1K Followers 1K Following Database Consultant. Father, non stop learner, speaker. Software Engineer, OCP, Oracle ACE Director, Oracle Principal Consultant @Pythian, @UYOUG Leader
Zoran Tica @zoran_tica
293 Followers 322 Following ♠ Oracle ACE Pro | Database & APEX Specialist | OCP Certified | Blogger & Conference Speaker | IT Enthusiast
deepa rao @deepajrao
22 Followers 150 Following
Suresh @Suresh95420497
7 Followers 99 Following
Sai Penumuru @sai_penumuru
3K Followers 1K Following Shaping the Future with Oracle Cloud and Multicloud Solutions | Principal Director at Accenture | President - All India Oracle Users Group | Oracle ACE Director
Avim Mate 💱 @mate_avim
407 Followers 2K Following learning and living...seeing and showing...scaring and facing... understanding and accepting...walking and talking...meeting and siting...loving and loving...Hi
mpapec @mpapec2010
283 Followers 342 Following
Chloe @Chloe_11798
142 Followers 107 Following @PasqualeBruniOF #CulinaryArts #AdventureTravel #FloralDesign
Osman DINC @InsaneDBA
219 Followers 1K Following I love and tame databases and share my knowledge on https://t.co/kDxrln8QHP
Zx Academy @zx_academy
166 Followers 2K Following Welcome to ZX Academy, we are the leading online training provider in India. We offer corporate training and individual online training.
Paulzip @paul_zip
57 Followers 170 Following
Ging Zabala @gingzabala
39 Followers 137 Following
Sabin @sabin230
39 Followers 697 Following
Philipp Hartenfeller @phartenfeller
1K Followers 577 Following 🖥️ Web & DBs 📝 Blog: https://t.co/m5qCJz18U4 💼 Product Lead @united_codes ♠️ Oracle ACE Pro 🛠 #orclapex
Jim Dickson @JimDick82249292
2 Followers 41 Following
Henrik Bachmann @hba69
51 Followers 536 Following Informatiker, Computer Scientist, Troubleshooter, Magdeburg, FCM, SCM, #orclAPEX
Kalle Anka @wmcessan
40 Followers 2K Following
Pamela @shortinopamela7
229 Followers 3K Following
Muhammad Waseem @mwaseem830
37 Followers 619 Following
Oracle ACE Program @oracleace
38K Followers 774 Following Recognizing the tech community for their amazing contributions. Learn more about the ACE Program @ https://t.co/ZtLFzdvOj5
JoergSobottka @JoergSobottka
666 Followers 476 Following Undercover DBA, Oracle ACE Pro, sports, travelling, photography, SCF, family. Born at 326ppm CO2. Write about environmental change, soccer and Oracle/SOUG.
Meinams Geor @MeinamsG
33 Followers 586 Following
Carolin Krützmann @CaroHagi
482 Followers 182 Following #orclapex, #wit, Selbstständige IT-Consultant, Meetups HH, DOAG Regio HH, Oracle ACE Pro :)
leroux.divine @DivineLero37782
5 Followers 312 Following
Sabine Heїmsath 🇺... @oraesque
4K Followers 4K Following Database Developer, Freelancer, bearer of the Dark Spade (aka Oracle ACE ♠), #DOAGeV member and delegate. I ❤️ #SQLDev #orclapex #plsql #yessql 🇬🇧 sie|she
TD @taraldesai
293 Followers 880 Following
Valério Almeida @xirulavga
242 Followers 1K Following
Mahir M. Quluzade @marzade
769 Followers 734 Following Database Specialist. Board Member of Azerbaijan Oracle User Group, Speaker, Author, Blogger
Jan Claas Behrends @jcbehrends
16K Followers 1K Following History prof @viadrina Russia & Ukraine. #Ostpolitik @NewEuropeU @OstausschussSK Football & cycling. All tweets private. Слава Україні!
Marie-Agnes Strack-Zi... @MAStrackZi
199K Followers 3K Following MdEP | Mitglied im FDP-Präsidium | Vorsitzende @fdp im @Europarl_DE | Vorsitzende Verteidigungsauschuss @EP_Defence | @EP_ForeignAff & @EP_Industry | Bikerin
Quanwen Zhao @quanwen_zhao
648 Followers 619 Following Being fond of communicating Oracle Tech with some domestic and overseas guys, is @oracleace alumni and any opinions are my own.
Michael Stoelting @mstoelting
61 Followers 47 Following
layla @pilatesdev
83K Followers 373 Following software engineer + product manager on the @oracleLiveSQL team at @oracle 🧡 new mom 🍼 opinions = my own
Con @sudera_
13 Followers 488 Following
Dejan Topalovic 🤝 @oradeto
544 Followers 551 Following Oracle Consultant 🤓 Oracle Certified Master 🍻 Oracle ACE Associate
Zoran Tica @zoran_tica
293 Followers 322 Following ♠ Oracle ACE Pro | Database & APEX Specialist | OCP Certified | Blogger & Conference Speaker | IT Enthusiast
Nelson Calero @ncalerouy
1K Followers 1K Following Database Consultant. Father, non stop learner, speaker. Software Engineer, OCP, Oracle ACE Director, Oracle Principal Consultant @Pythian, @UYOUG Leader
Sai Penumuru @sai_penumuru
3K Followers 1K Following Shaping the Future with Oracle Cloud and Multicloud Solutions | Principal Director at Accenture | President - All India Oracle Users Group | Oracle ACE Director
Gianni Ceresa @G_Ceresa
1K Followers 398 Following Oracle ACE Director ♠, Analytics & EPM Consultant, owner of DATAlysis LLC, having fun with raspberry pi and a lot more... (@ gianniceresa on bsky)
Mirela Ardelean @Mirela_RoOUG
834 Followers 351 Following Founder and board member of RoOUG (Romanian Oracle User group); PL/SQL, APEX, Forms developer; Board member of EOUC; ORAWORLD chief-editor; ACED SYM42
Sandesh Rao @sandeshr
4K Followers 5K Following Machine Learning and AI at Oracle. Amateur photographer , reader , traveller. Opinions expressed here are my own and not my employer’s
Oracle User Groups @oracleugs
6K Followers 1K Following Applications and Infrastructure Community https://t.co/qlkCvEnszA
DataVaultAlliance @DV2Alliance
208 Followers 57 Following DVA is lead by Dan Linstedt, creator and inventor of Data Vault. "DATA VAULTS DONE RIGHT, EVERYWHERE, EVERY TIME.®"
Vlad Mihalcea @vlad_mihalcea
89K Followers 137 Following @Java Champion, author of High-Performance Java Persistence and @Hypersistence Optimizer. Blogging at https://t.co/GWdHta4mMO
chet justice @oraclenerd
3K Followers 282 Following dad, oracle (database) enthusiast, nerd, wannabe triathlete
Osman DINC @InsaneDBA
219 Followers 1K Following I love and tame databases and share my knowledge on https://t.co/kDxrln8QHP
Dimitri Gielis @dgielis
4K Followers 359 Following Loves building database apps and help others to become successful with Oracle APEX. Founder of https://t.co/yd6QHamX3A. Oracle ACE Director.
Rustam Mehmandarov @rmehmandarov
4K Followers 890 Following Passionate computer scientist. One of @Java_Champions, @GoogleDevExpert for Cloud, Docker Captain. Public speaker. Ex-leader of JavaZone and Norw. JUG – javaBin
Аlina Yurenko 🇺�... @alina_yurenko
8K Followers 721 Following Ukrainian. Love tech, compilers, and open source. Developer Advocate for @GraalVM at @Oracle. Ambassador of snacks and not running.
ORAWORLD e-Magazine @ORAWORLD_Mag
304 Followers 100 Following ORAWORLD e-magazine reports on events in the Oracle and IT world and covers current topics in the international user group network.
Lothar Flatz @LotharFlatz
882 Followers 250 Following Performance Architect, Oracle ACE and Oak Table Member
Dear DBA Frank @fdernoncourt
1K Followers 581 Following Senior Data Administrator @capgemini Views my own. I share tips and info on Postgresql, SQLServer, MongoDB and the Oracle database.
nlOUG @nl_OUG
905 Followers 329 Following The official twitter account of the Dutch Oracle Usergroup
Henrik Bachmann @hba69
51 Followers 536 Following Informatiker, Computer Scientist, Troubleshooter, Magdeburg, FCM, SCM, #orclAPEX
Maik Becker 🇺🇦 @beckerman_maik
371 Followers 178 Following #plsql guy • #orclapex enthusiast • love working with great people • conference speaker • Oracle ACE • developer & manager at @TRIOLOGY_GmbH • tweets are my own
Kai Donato @_KaiDonato
796 Followers 537 Following Department Manager APEX & JavaScript @ MT | Part of Hyand | ♠️ Oracle ACE Director | DOAG Themenverantwortlicher | Podcast: @devsontape
Mir Sayeed Hassan @mirsayeed
554 Followers 2K Following Oracle ACE Pro ♠ | Sr. Oracle DBA | OCP (12C/11g/10g/9i) | Oracle Cloud Infrastructure (OCI) Certified Foundations Associates | Blogger | Author | Speaker.
Erik van Roon @evrocs_nl
1K Followers 249 Following Oracle DB Dev Oracle ACE Pro ♠️ Symposium42 Rambling fool By default assume I'm not serious Tweeted opinions are the one & only truth, and probably unfounded
kirvirvi 💚🌻 @kirvirvi
394 Followers 659 Following husband, father, oracleNinja ... Database Administrator for Oracle, MySQL, Mariadb and MS SQL and PowerGoogler
Oracle ACE Program @oracleace
38K Followers 774 Following Recognizing the tech community for their amazing contributions. Learn more about the ACE Program @ https://t.co/ZtLFzdvOj5
Oracle Database @OracleDatabase
188K Followers 220 Following Available on-prem or in the cloud, #OracleDatabase enables you to simplify relational #database environments and reduce management workloads.
Martin Bach @MartinDBA
5K Followers 602 Following Product Manager at Oracle. Technology enthusiast. Author, blogger, speaker. Ace Director alumnus, ex Enkitec. I work for Oracle but do not speak for them.
Carolin Krützmann @CaroHagi
482 Followers 182 Following #orclapex, #wit, Selbstständige IT-Consultant, Meetups HH, DOAG Regio HH, Oracle ACE Pro :)
SYM_42 @sym_42
207 Followers 84 Following It's better on: Bluesky @sym42.bsky.social Symposium 42 - The user community for Oracle-&-beyond, totally independent from all vendors Created by the community
Thomas Jäger @jaegerthomas2
45K Followers 249 Following Professor für Internationale Politik und Außenpolitik an der Universität zu Köln
Jayson Hanes #orclAPE... @JaysonHanes
2K Followers 1K Following APEX Senior Principal Product Manager for the Americas at Oracle; Drone Enthusiast; my tweets and posts online are my own and not of my employer.
Uwe Küchler - now at... @oraculix
410 Followers 402 Following Twitter already was a dumpster fire, but X is just plain toxic. Left for good.
Philipp Hartenfeller @phartenfeller
1K Followers 577 Following 🖥️ Web & DBs 📝 Blog: https://t.co/m5qCJz18U4 💼 Product Lead @united_codes ♠️ Oracle ACE Pro 🛠 #orclapex
SQL.ProductManager.Or... @thatjeffsmith
20K Followers 2K Following 🌟 SQL ⭕ Oracle 📊 Databases 🏋️♂️ Weights, poorly 🥃 Bourbon 🕸️ REST API 🙊 Product Manager 🤡 Annoying people online Words are mine.
Andrii Melnyk @MelnykAndrij
189K Followers 34 Following Proud Ukrainian Diplomat🇺🇦Ambassador to the UN🇺🇳Vice Foreign Minister (2022-23). Ex-Botschafter in Deutschland🇩🇪LL.M.(Lund).Ph.D.(Kyiv) Ukraine will win✌️
Adrian Cantrill @adriancantrill
23K Followers 364 Following #bitcoin Posting mainly on nostr https://t.co/JqYnpHcfCs (privacy focused and censorship resistant) AWS Technical Trainer @ https://t.co/eR6AY24r8U
Julian Dontcheff @JulianDontcheff
2K Followers 204 Following Distinguished Product Manager at Oracle - JSON and PL/SQL
Davor Ranković @Davorranko
176 Followers 113 Following
Florian Feicht @FlorianFeicht
161 Followers 135 Following Head of Delivery - Platform Factory at Trivadis Germany GmbH, Munich
Daniele Massimi @MassimiD
267 Followers 457 Following Oracle Consultant, Oracle Certified Master 11g+12c, Platform Architect, Exadata SpecialistTrends for United States
You might like
