OraNA :: Oracle News Aggregator

No matter how many monitors you have or how large they may be, sometimes you just need more real-estate for your coding. You can have a whole lot going on in your IDE, and SQL Developer is no exception. Of course you can always close o…

At the 2011 AUSOUG Conference I gave a presentation on simply called Oracle Apex 4.1 Security.The exciting thing was (well, I thought it was exciting) I gave powerpoint the flick and used Prezi instead. I’ve got oraclenerd to thank for putting me onto …

Today I was chasing the relevant ASCII code for certain characters… I know there are plenty of ASCII tables on the net, but this is an interesting SQL solution, nonetheless.select rownum “dec” ,chr(rownum) “char” ,to_char(rownum,’XXXX’) “he…

Happily I would announce the listing of my upcoming book at PacktPub publishers website. The book is expected to be released by May, 2012. The book is for the Oracle Associate professionals who are aspiring for Professional level exam (1Z0-146 certific…

Just so you don’t think I’m crazy, you should know that I’m a father to a wonderful two year old daughter. She’s awesome, except when she wants to act her age. When we get desperate, we turn on her favorite show. I have seen ab…

Somebody asked for a simple comparison between a PL/SQL pass-by-value function and pass-by-reference procedure, where the procedure uses only an OUT mode parameter to return the result. This provides examples of both, but please note that a pass-by-val…

I had the privilege to be a guest blogger on the ODTUG blog. I wrote about Kscope and my role in putting together the Developer’s Toolbox track as well as why you should attend Kscope. Here is a short excerpt:

This year’s Kscope is a special one t…

From An Expert’s Guide to Oracle Technology
 
Continuing on in my 101 series – I wrote about associative arrays, nested tables and <a href="../../../blogs/oracle-guide/record-types-1

SQL Developer can move data online and offline.Online is really only for small amounts of data (<100mb). For larger sets of data with greater performance and much better logging, the Offline Data Move feature should be used.SQL Developer will create…

Again Oracle shows its commitment to continue investing in PeopleSoft. This time by changing the release model of PeopleSoft Applications Portal, formally known as PeopleSoft Enterprise Portal, by adding Feature Packs. With these Feature Packs customer…

Just finished reading OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide – Packt Publishing.What i liked: the book is accessible to anyone; the examples and their screen casts make easy to see what exactly the author is talk…

In the past week I've been investigating how Oracle fires triggers with the Merge and Multi-Table-Insert statements. Also took a look at 'statement-level constraint consistency' with these two types of statements. My findings are here: ht…

Hans Forbrich, an Oracle ACE Director, talks about his path to becoming a prized speaker at Oracle User Group meetings around the world. http://medianetwork.oracle.com/video/player/961894745001 Enjoy all Saurabh Filed under: Oracle Tagged: Oracle, orac…

There’s always a risk when you go off testing something that you notice some side-effect or issue that turns out to be irrelevant to the main investigation.
I’ve been investigating a performance problem on an insert .. select statement.
For the las…

Hopefully your code is cleaner than what runs through this every morning
I’m not sure if I can help with the mind part, but I can definitely add some perspective on the line numbers. Quickly, let’s define just what the ‘gutter’…

Here are basic instructions for creating a trigger “On Logon”. Sometimes I need to create one on the fly and it is useful to have a template.Read more »

It seems I drafted this one about 18 months ago, worth sharing…Me (back in 2000):”Hi, my name’s Scott. I’m your new developer”My First DBA:”Here’s your db account, just don’t change your password to ‘tiger’”Well, it wasn’t quite like that, but it was…

As promised Oracle is now supplying Oracle Fusion Applications on Windows. Most system administrators and installers will probably say, why is this important? Bringing Oracle Fusion Applications to Windows makes the application more accessible t…

Here is an example of how you can design a kind of “Web” menu with the LAF HTML Map feature Each menu option is symbolized by an image part to render this modern look and feel.

20th century has been highlighted by the two notable insights onto the nature of information. In 1948, Claude Shannon published classic paper “A Mathematical Theory of Communication” suggesting quantitative information measure — entropy — as av…