Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Photos of an Oracle ACE Award
- Hi all,I mentioned a while back that I was an Oracle ACE. I got the actual OracleACE award in the mail yesterday. I had never seen one so I tookpictures. I figured I would post them in case anyone else is curious asto what it looks like. You can...
- Tags: Ace, Oracle ACE, Oracle Corp., photograph
- Blog posts 2006-09-22
- Katrina - One Year Later
- This is a personal entry and has absolutely no Oracle,database or other technical content. This is more of a mind dump aboutKatrina and life in general. If you don't care to read about Katrina ormy life, please don't read this. This entry is one of my few ramblingrants and it's...
- Tags: Databases, Katrina
- Blog posts 2006-09-22
- EnterpriseDB Wins Best Database Award at LinuxWorld
- EnterpriseDB announced some significant advances with their latest EnterpriseDB Advanced Server release. You can read an article at Sys-Con.They've made several improvements but the three I think most important are the Automated Migration tool, the replication server and the multi-platform Developer Studio.You can get more info about these at...
- Tags: database, EnterpriseDB
- Blog posts 2006-09-22
- Slowing Down to Write a Book
- Well, I'm going to doit. I'm officially writing a book. I've got the publisher. I've got thetopic. And now I've got a deadline.I'll write more about thebook over time but in the short term, that means that time I wouldnormally spend blogging and answering questions on the oracle-sql-llist will be...
- Tags: Blogging
- Blog posts 2006-09-22
- Word Of The Day
- I get a word of the dayemailed to me and they just added an RSS feed. I thought I would passit a long. You can get it here: Word of the Day.BTW,the book is going well. I'm doing more than the words per day I hadplanned. I think it's good...
- Tags: Microsoft Word
- Blog posts 2006-09-22
- Afraid of being fired?
- Hate taking abuse frommanagement but you do anyway? Keep your opinion to yourself when youshould be sharing it? Pretend you're someone your're not just to fitin? All because you're afraid of being fired?Here is an excellent blog entry from the Chief Happiness Officer, How to lose your fear of being...
- Tags: Lewis Cunningham
- Blog posts 2006-09-22
- PL/XML - XML Based Scripting for PL/SQL
- I started working on atask for a project and decided that there were some very goodproperties that I could use to help me teach people PL/SQL and XML. Iexpanded a bit on the idea and ended up with a scripting language,implemented in XML, that can be passed into a PL/SQL...
- Tags: 15:06:59MyValue, PL/SQL, XML
- Blog posts 2006-09-22
- Mini-Tip #8 - Extending XMLType to Access Scalar XPath Functions
- For some reason, the XMLType XPath implementation does not allow scalar results. According to the documentation:EXTRACTXML is similar to the EXISTSNODE function. It applies a VARCHAR2XPath string and returns an XMLType instance containing an XML fragment.Extractwill only return an XMLType. A scalar value would be a function thatreturns a...
- Tags: Extending XMLType, Microsoft Access, XMLType XPath, XPath
- Blog posts 2006-09-22
- Would you like to participate in some on-line Database Training?
- I am putting together a training program.The training is going to be designed specifically for on-line,interactive presentation. I am looking for a few volunteers to sitthrough (well, hopefully participate and ask questions and such) somesessions to help me fine tune it.I would like to have severalpeople at varying levels of...
- Tags: Databases, Broadband Internet, training, database
- Blog posts 2006-09-22
- Oracle Buzz Version 4
- Link to the original post.The Oracle Buzz is my take onthe news, trends and topics that have the bloggers blogging in theworld of databases. I concentrate mainly on the Oracle world but I'llalso cover other topics that interest me.I'm back! As always, Iam looking for feedback. I would like to...
- Tags: Oracle Corp., Oracle Buzz
- Blog posts 2006-09-08
- BADA: Performance Goals - A Parable
- MauDweeb: Database Architects of Dune, Chapter 1Anyroad followed precisely to its end leads precisely nowhere. Climb themountain just a little bit to test that it's a mountain. From the topof the mountain, you cannot see the mountain. from MuaDweeb: Family Commentaries by the Princess Irulan Summoned! Summoned to meet...
- Tags: performance
- Blog posts 2006-09-08
- Software Freedom Day 2006
- Link to the original post.As today in the US is LaborDay, I thought I would draw your attention to an event that celebratesthe free labor so many people give to free software. Software Freedom Day 2006 is September 16.Here's a blurb from the site:SoftwareFreedom Day SFD is a worldwide celebration...
- Tags: Bradenton, F/OSS, site:Software Freedom Day, software
- Blog posts 2006-09-08
- BADA: Responsibilities of a Database Architect
- I would like to ask a favor ofyou. I was planning on writing about the differences between a databasearchitect, a data architect, an information architect, etc. But as Istarted doing that, I figured I should document what I do and what Ithink a database architect is. So that's what I...
- Tags: job, database
- Blog posts 2006-09-03
- Mini-tip #6 - Private Variables
- A member of the oracle-sql-l mail group asked about private variables in procedures and packages and how to go about doing that. I am going to go into this in a lot more detail when I get back to my Learn PL/SQL tutorial. For a short answer though, I...
- Tags: Lewis Cunningham
- Blog posts 2006-09-03
- Mini-tip #7: Quick Access to Oracle Documentation
- Have you ever needed to lookupsomething for Oracle 8.1.7 and couldn't find the documentation? Everwant to compare features between two Oracle versions? Go to Tahiti!Not the island. Well, you can still go to the island but I'm not sure how much documentation they have. I mean http://tahiti.oracle.com/. ...
- Tags: Oracle Corp., Oracle Documentation
- Blog posts 2006-09-03
- Mini-Tip #5: Coalesce()
- I recently wrote about NVL2. A function much like NVL2 is coalesce. Coalesce is of the format COALESCE(expr1, expr2, exprN...)Coalesce returns the first non-null expression in the expression list.Coalesce is different from most SQL functions in that it allows a varying number of expressions.Coalesce is basically a...
- Tags: COALESCE, NVL2
- Blog posts 2006-08-30
- Learn Oracle: Datatypes for SQL and PL/SQL, Boolean and Large Objects (LOB)
- Use the article index for more articles on this subject.BOOLEANABOOLEAN datatype is a native PL/SQL type that lets you signify a TRUEor FALSE condition. A BOOLEAN is NULL until explicitly assigned avalue. A BOOLEAN is assigned like other variables:DECLARE v_bool BOOLEAN; v_bool2 BOOLEAN := TRUE; ...
- Tags: subject.BOOLEANA BOOLEAN, Oracle Corp., PL/SQL, SQL
- Blog posts 2006-08-29
- BADA: Absolutes - Never say never, Never say Always
- Read what BADA means.What do I mean by absolutes?When someone says you should NEVER do something or when someone saysyou should ALWAYS do something. Some things make sense. If your mamasaid you should never run with a sharp stick, she was probably right.Of course if you don't, you'll never win...
- Tags: Goto
- Blog posts 2006-08-22
- Mini-Tip #3: Associative Array - Retrieve and Sort Array Index
- This tip will answer twoquestions I get very frequently. Definitely a FAQ. "How do I retrieveand use the VARCHAR2 index of an associative array?" and "How can Isort a PL/SQL table?" These questions pertain to PL/SQL functionality;not SQL functionality. SORTI'll answer the sortfirst and I'll kind of cheat. When I...
- Tags: Programming languages, Databases, VARCHAR2, PL/SQL
- Blog posts 2006-08-19
- Mini-Tip #4: Open Source Tools for Oracle
- I've written about Open Source and Oracle in the pastbut thought I would remind everyone that open source is a good place togo for new tools. Instead of starting from scratch, it sometimes helpsto see if someone has done something already. My philosophy is to notreinvent the wheel if I...
- Tags: Operating systems, UNIX, open source, Oracle Corp.
- Blog posts 2006-08-19
