A few years back I pondered whether DISTINCT was a bug
My premise was that if you are depending on DISTINCT to return a correct result set, something is seriously wrong with your table design. I was reminded of this again recently when I ran across Kent Graziano's post on Better Data Modeling: Are you making these 3 beginner mistakes in your data models?
Instead of that, you should be defining a natural, or (more...)
Hi All, Last week, I registered my presence at Collaborate’15 in Las Vegas as a speaker, attendee and at Oracle demo booth duty. It was an awesome experience meeting some polished brains and smart minds. After the first day of registration, I attended the #DBIM12c session by Maria Colgan, #DB12c Multitenant by John McHugh and #Exadata session … Continue reading
I love podcasts. I listen to a few good science shows every week and I've been looking for some decent software related shows, and this one hits the subject matter right on the head.
Juergen states he hopes to interview many developers from the APEX team, offering perhaps a recording per month. Not limiting (more...)
We cannot direct the wind… But we can adjust the sails! Are you heading where you want to, or letting the wind blow you about? Talk the helm of your life and set a course. Happy Monday! Kent The Data Warrior P.S. It is almost time for the 2nd Annual World Wide Data Vault Consortium […]
There are some stickers are out there causing quite the sensation
in the Oracle APEX Twitter community. Check it out and join the conversation.
A couple of weeks ago I received my sticker from the master dealer, Juergen
, so I thought I'd share my pimped up laptop, complete with sticker friend.
|Pimp my laptop|
Fun fact: the photo was taken on the same grass that formed my blog's title image.
And now I also learn (more...)
On my play environment I usually use Oracle APEX with the Embedded PL/SQL Gateway, just because it's so easy.
When a new version of APEX is released, just like everybody else, I upgrade my play environment.
After the apexins.sql script is run, I always want to start playing with it immediately. Usually it is at this point where I just see a blank page... scratching my head wondering why it is not running,... having (more...)
Wenn ich an PL/SQL denke, ist meine erste Assoziation dazu der Name Steven Feuerstein. Nun denke ich nicht furchtbar oft on PL/SQL, aber wenn der Herr Feuerstein über ein Thema schreibt, dem ich mit einer gewissen Regelmäßigkeit begegne, dann ist das allemal eine Verlinkung und Zusammenfassung der zugehörigen Artikel wert:
The best Oracle Application Express edition of all times has finally landed.
Info & details in Apex's official blog.
Thanks to everybody who visited my presentation! Here is a link to view and/or download the slide set: http://www.slideshare.net/MishaRosenblum/2015-458-rosenblumpptfinal
Feel free to ask questions!
O Oracle Users Group Portugal tem boas notícias: "Lisboa vai receber no dia 21 de Maio de 2015 uma conferência realizada pelo OUGPT em colaboração com o Oracle OTN no auditório do Instituto Superior Técnico (Campus da Alameda, Centro de Congressos do IST). O painel de speakers para o dia inclui 4 Oracle ACE Directors. Não existe qualquer custo associado para a presença na conferência. Apesar disso o registo é obrigatório
Just been tearing my hair out on some unexpected SQL behaviour in SQL Developer.
Eventually I managed to get to the root cause of the problem as illustrated below.
SQL> var ps number
SQL> exec :ps := 4001644945;
PL/SQL procedure successfully completed.
SQL> select :ps from dual;
SQL Developer v3.2 and v4.0 via “Run As Script(F5)”:
var ps number
exec :ps := 4001644945;
select :ps from dual;
Tonight I stayed up way past my bedtime (well, in the days of writing a book and Kscope presentations, midnight isn't that
I watched and listened to Shakeeb Rahman from the APEX team on an ODTUG webinar
, which was recorded and available for ODTUG members.
I did, however, take some notes. I thought I'd share:
Not shy about reference to Douglas Adams.
Theme can be (more...)
Eine nützliche Ergänzung in 12c, die mir bisher entgangen war, ist das TRUNCATE CASCADE, mit dessen Hilfe man eine Parent-Tabelle entleeren kann und zugleich alle Datensätze in via FK verbundenen Tabellen löscht. Das funktionierte bislang nur mit DELETE - und auf DELETE verzichte ich gerne, wo immer das möglich ist. Dazu ein kleines Beispiel:
drop table child;
drop table parent;
create table parent(
parent_id number primary key
insert into parent(parent_id)
"New in This Release: Added Oracle 12c new features Added EurekaLog exception handling Improved multiple tasks handling" https://support.software.dell.com/sql-navigator-for-oracle/download-new-releases
Instrumentation of PL/SQL code is essential. My favourite tool to instrument PL/SQL is Logger.
Martin Giffy D'Souza wrote a few blogs on how to speed up development with Logger and I want to chime in with my own productivity booster.
What I have written is a PL/SQL package that will generate a Procedure or Function body with all the calls to Logger. This includes all the arguments, or at least the IN and IN/OUT arguments.