Robuta

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