Devel. + PL/SQL tools
JDeveloper, Forms, Designer,…
When you write a lot of code, no matter what sophisticated framework you use, there are pieces of code that you end up writing over and over again (especially when using Java). Writing logging code in Java is a good example. A common pattern is to initialize a static logger variable in every class you want to log something. Fortunately, JDeveloper has a feature called “Code Templates” that can make your life a lot easier! I have seen several blogs that explain how to use Code Templates for logging code (I saw one from as early as 2006; the feature itself has actually been available since 2004!). But still a lot of people are not aware of this feature (or perhaps simply forget to use it).
Hereby, for those who want another look or for people to share, my presentation content “Creating Structure in Unstructured Data” given during the Hotsos 2013 Symposium on Monday morning.
I use subquery factoring a lot, to make my SQL queries easier to write. This basically means that most of my queries these days start with WITH rather than SELECT. (this feature was introduced in the 9i release of the Oracle Database).
Today I was wondering whether I can also use subquery factoring in INSERT statements. You probably are familiar with INSERT statements that go like:
INSERT INTO <tablename>
FROM … [rest of the query]
Such statements allow us to quickly and in a focused way load a table with records read from other tables (or PL/SQL Table Functions).
The question I had was: can I use WITH <subquery> as <alias>[, <subquery> as <alias>] SELECT value1,value2 from subquery,…. [rest of the query] inside an INSERT statement.
Best way to find it out – try and do it.
While working on a Web application that required some page to report data aggregated on several levels of time period – by month, quarter or year – I ran into a very handy way to use the TRUNC function. I was not aware of this usage until now – and since I make it a point to encourage my colleagues to write a blog article on anything new they uncover – no matter how trivial it may seem or how strong the feeling that surely everyone already knows about that – I must play by my own rules and tell you about it.
The challenge I was facing can easily be translated into this question: write a SQL query that reports on the number of employees hired per month (or quarter or year). In fact, use a bind parameter that drives the aggregation level – i.e. the Month, Quarter or Year.
Taking the well known EMP table as the target system, this challenge means that all employees hired in the same Month (or Quarter or Year) should be aggregated in the same group. That in turn means that the aggregation should take place by the MONTH (or QUARTER or YEAR) component of their HIREDATE. Instead of fiddling with TO_CHAR using different date identifiers (which also have been an option) it turns out to be More >
Van 3 tot en met 7 maart vindt in Irving, Texas, het internationale Oracle performance Hotsos Symposium plaats. Dit jaar belooft het symposium een garantstelling voor inhoudelijk hoogstaande presentaties en discussies, want naast presentaties van Tom Kyte, Cary Millsap, Maria Colgan en Steven Feuerstein over performance, worden er ook onderwerpen behandeld zoals Big Data, noSQL, XML, Statistische toepassingen met betrekking tot performance, beheer in de (Oracle) Cloud, Exadata en Oracle 12c onderwerpen.
Het event “Hotsos Revisited 2013″ gaat in de herhaling op 2 april met de presentaties van de Nederlandse sprekers… (more…)
The Oracle ACE directors and Java champions are organizing an evangelist event called ‘OTNYathra 2013’ between 15th & 27th February 2013. The event is sponsored by the Oracle Technology Network. I will be one of the speakers on this tour – presenting two or three presentations at each of the six host cities for this tour:
Other speakers on this tour will cover topics such as ADF, LDAP, OVM, Oracle Enterprise Linux, RAC and Clusterware, BigData, Essbase and OBIEE, APEX, EPM and Hyperion. Speakers include Java Champion and Oracle ACEs and ACE Directors such as Harshad Oak, Hans Forbrich, Edward Roske, Murali Vallath, Vivek Sharma.