https://www.oraclenerd.com/2010/02/obiee-singledetail-record-view.html
ORACLENERD: OBIEE: Single/Detail Record View
Recently, I've been searching for a Single Row/Detail type report in Answers. Sadly, there isn't one so named. Here's what I could find ...
oraclenerdobieesingledetailrecord
https://www.oraclenerd.com/2009/08/writing-maintable-code.html
ORACLENERD: Writing Maintainable Code
The last few years I've inherited quite a bit of code. The vast majority of it reads terribly. I get newbies; those who have yet to find th...
oraclenerdwritingmaintainablecode
https://www.oraclenerd.com/2010/07/obiee-gotcha-5.html
ORACLENERD: OBIEE: Gotcha #5
Or the CHAR edition. A report writer asked me why this report isn't returning any rows. So I brought up the report, ran it, then grabbed t...
oraclenerdobieegotcha
https://www.oraclenerd.com/2010/09/oow-2010-fun-with-pictures.html
ORACLENERD: OOW 2010: Fun with Pictures
On Saturday night John, Ben, and I ran into Dan Norris at the Urban Tavern, the bar in the Hilton. After scaring away the rest of his team,...
fun withoraclenerdoowpictures
https://www.oraclenerd.com/2008/05/blogging-safely.html
ORACLENERD: Blogging Safely
Jake from AppsLab left a link in the comments to my previous post, Lessons Learned . The link was to an article about Mark Jen, who was f...
oraclenerdbloggingsafely
https://www.oraclenerd.com/2009/01/database-views-love-em-or-leave-em.html
ORACLENERD: Database Views: Love 'em or Leave 'em?
A view in Oracle is essentially a query you can store in the database. I use them quite heavily in my own systems. There are a few reasons ...
database viewsoraclenerdloveemleave
https://www.oraclenerd.com/2009/04/shut-your-mouth.html
ORACLENERD: Shut Your Mouth!
Those of you who know me, know that I have a tendency to talk a bit. I've been counseled by many (wife, friends, co-workers, etc) to keep m...
oraclenerdshutmouth
https://www.oraclenerd.com/2010/04/collaborate-day-4-wrap-up.html
ORACLENERD: COLLABORATE: Day 4 Wrap Up
The day started out with the realization that I pulled off the best (COLLABORATE - self annointed) prank ever. Twitter was...all atwitter a...
oraclenerdcollaboratedaywrap
https://www.oraclenerd.com/2013/03/analysis-tools.html
ORACLENERD: Analysis Tools...
I've taken on an effort to port a custom data integration (PL/SQL, Java, etc) application. In that regard, I'm doing a fair amount of an...
oraclenerdanalysistools
https://www.oraclenerd.com/2009/10/starting-overagain.html
ORACLENERD: Starting Over...Again.
On Friday I was told, " They're [things] just not working out... " and let go from my job. The job counter was up to a whopping 189 days th...
starting overoraclenerd
https://www.oraclenerd.com/2011/10/good-dba-bad-dba-deadlock.html
ORACLENERD: Good DBA, Bad DBA, Deadlock
By Enrique Aviles A few days ago a fellow DBA asked me to review an email he received from a developer. In the email, the developer explai...
oraclenerdgooddbabaddeadlock
https://www.oraclenerd.com/2008/11/my-virtual-column-failure.html
ORACLENERD: My Virtual [Column] Failure
Well, I wouldn't really say a failure , but it's certainly been a trial. We're trying to create a new process that will detect fraud. Much ...
oraclenerdvirtualcolumnfailure
https://www.oraclenerd.com/2009/02/ora-08177-cant-serialize-access-for.html
ORACLENERD: ORA-08177 can't serialize access for this transaction
We've been getting this error recently and we are in the process of researching the problem. I figured I might as well share some of my refe...
oraclenerdserializeaccesstransaction
https://www.oraclenerd.com/2009/05/collaborate-09-convert-forms-to-apex.html
ORACLENERD: COLLABORATE 09: Convert Forms to ApEx
David Peake Oracle Application Express 3.2 Forms Conversion Stupid laptop battery. This would have been done during. Anyway, it was a tad d...
oraclenerdcollaborateconvertformsapex
https://www.oraclenerd.com/2011/09/obiee-startstop-individual-components.html
ORACLENERD: OBIEE: Start/Stop Individual Components (Manually)
Previously I wrote about how to start and stop individual components via Enterprise Manager. This time, I'm going to run through the manua...
start stopindividual componentsoraclenerdobieemanually
https://www.oraclenerd.com/2010/12/professionally-speaking.html
ORACLENERD: Professionally Speaking...
Last year I submitted an abstract to ODTUG on using social media to increase productivity. It was one of those whims as the deadline for su...
oraclenerdprofessionallyspeaking
https://www.oraclenerd.com/2009/08/oraclenerd-t-shirts.html
ORACLENERD: ORACLENERD T-Shirts
Thanks to Justin , Jake , Billy ( twice ) and everyone else who has taken up "my" cause. If you don't know what the cause is, you've probab...
oraclenerdshirts
https://www.oraclenerd.com/2011/03/expert-oracle-apex.html
ORACLENERD: Expert Oracle APEX
I'm a bit of a fan of APEX; haven't used it consistently in a while but I think it's a great tool. I've annoyed many managers/DBAs about get...
oraclenerdexpertapex
https://www.oraclenerd.com/2007/12/
ORACLENERD: December 2007
oraclenerddecember
https://www.oraclenerd.com/2010/03/dbatables-vs-dbaobjects.html
ORACLENERD: DBA_TABLES vs DBA_OBJECTS
oraclenerddbatablesvsobjects
https://www.oraclenerd.com/2009/06/oracle-concepts.html
ORACLENERD: Oracle Concepts
Years and years of reading AskTom , if there's one thing that I really come away with, it's read. RTFM. Specifically though, he's telling ...
oraclenerdconcepts
https://www.oraclenerd.com/2009/05/collaborate-09-other-blogs.html
ORACLENERD: COLLABORATE 09: Other Blogs
I found a whole bunch of other blogs about COLLABORATE 09 (shocker, I'm not the only one), so I figured I would publish them here as well. T...
oraclenerdcollaborateblogs
https://www.oraclenerd.com/2007/09/
ORACLENERD: September 2007
oraclenerdseptember
https://www.oraclenerd.com/2009/05/burnout.html
ORACLENERD: Burnout
After about 5 years of near constant activity I'm finally beginning to feel the effects. In 2004 I started a business. I would work over 10...
oraclenerdburnout
https://www.oraclenerd.com/2009/05/
ORACLENERD: May 2009
oraclenerdmay
https://www.oraclenerd.com/2009/12/my-ebs-install-saga.html
ORACLENERD: My EBS Install Saga
(Yes, it is sad that I am writing this on New Year's Eve...I'm on a mission at this point and nothing will stop me). So I've been trying to ...
oraclenerdebsinstallsaga
https://www.oraclenerd.com/2009/03/how-to-populate-your-time-dimension.html
ORACLENERD: How To Populate Your TIME Dimension
Yesterday I wrote about the Datawarehousing TIMES table. Today I populated it. I modified it for my own purposes naturally, specifically...
how toyour timeoraclenerdpopulatedimension
https://www.oraclenerd.com/2010/09/oow-2010-schedule-part-i.html
ORACLENERD: OOW 2010: Schedule - Part I
I spent some time last night working with the Schedule Builder, which was surprisingly nice. Mostly focusing on OBIEE, OBIA, Datawarehousin...
oraclenerdoowschedulepart
https://www.oraclenerd.com/2008/12/exception-handling-wtf.html
ORACLENERD: Exception Handling WTF
In homage to Oracle WTF . Trying to remove references for a table that no longer exists (a view was created in it's place), I found this lit...
exception handlingoraclenerdwtf
https://www.oraclenerd.com/2009/04/keep-it-down.html
ORACLENERD: Keep it Down
I've tired (for the moment anyway) of adding Part II, III, etc. to the titles. So I'm going with a whole new name. This is a followup to la...
keep itoraclenerd
https://www.oraclenerd.com/2010/08/sql-developer-turn-off-autogenerate.html
ORACLENERD: SQL Developer: Turn Off "Autogenerate GROUP BY"
This is more for me since I seem to install it quite regularly. I've been snagging the SQL from OBIEE query logs (nqquery.log), which doesn'...
sql developerturn offoraclenerdgroup
https://www.oraclenerd.com/2008/11/flashback-database.html
ORACLENERD: FLASHBACK DATABASE
I've used Oracle's flashback technology to restore data, but I never realized that it was possible to flashback the objects as well. Typica...
oraclenerdflashbackdatabase
https://www.oraclenerd.com/2012/06/kscope-2012-advanced-registration-ends.html
ORACLENERD: KScope 2012 Advanced Registration Ends June 9th!
It's almost here. Kscope 2012 . Just 18 more days. What's that? You're not going? Need to justify the trip? Check out the bottom of the re...
advanced registrationoraclenerdkscopeendsjune
https://www.oraclenerd.com/2009/08/rowtype.html
ORACLENERD: %ROWTYPE
The %ROWTYPE attribute provides a record type that represents a row in a table (or view). The record can store an entire row of data selecte...
oraclenerd
https://www.oraclenerd.com/2010/06/obiee-parse-nqquery-log.html
ORACLENERD: OBIEE: Parse NQQuery Log
It's been quite some time since I've dabbled in Java, thankfully JDeveloper makes it pretty easy for me. I've been annoyed at how often I ha...
oraclenerdobieeparselog
https://www.oraclenerd.com/2009/07/oracle-getting-started.html
ORACLENERD: Oracle: Getting Started
A friend of mine recently expressed interest in learning Oracle. Here's what I sent him: Start here: Oracle Concepts Guide - http://download...
oraclenerdgettingstarted
https://www.oraclenerd.com/2010/03/1z0-052-preparing-database-environment.html
ORACLENERD: 1Z0-052 - Preparing the Database Environment
Main Identify the tools for Administering and Oracle Database Oracle Enterprise Manager Toad DBA Suite for Oracle SQL*Plus RMAN SQL Develope...
the databaseoraclenerdpreparingenvironment
https://www.oraclenerd.com/2009/10/followup-question-for-mr-ellison.html
ORACLENERD: Followup Question for Mr. Ellison
In my first year in IT, I was fortunate enough to be sponsored by my employer to go to Oracle OpenWorld. This was way back in 2002. Hard t...
oraclenerdfollowupquestionmrellison
https://www.oraclenerd.com/2010/01/obiee-connect-to-remote-rpd.html
ORACLENERD: OBIEE: Connect to Remote RPD
There is occasion were you will not have physical access to the machine which hosts your RPD. How to connect? First create a new ODBC Data S...
connect tooraclenerdobieeremoterpd
https://www.oraclenerd.com/2009/06/etcfstab-help.html
ORACLENERD: /etc/fstab help!
Most of you know I'm a Linux n00b. I have no apologies for that...at least I'm trying right? I unsucessfully attempted to install Oracle on...
oraclenerdetcfstabhelp