Skip to content
Oracle Alchemist

Oracle Alchemist

Steve Karam’s Blog

  • Oracle
  • Fun
  • Technology
  • Development
  • Big Data
  • NoSQL

Month: September 2006

The Final Tip is Coming Soon

September 26, 2006 Steve Karam News Leave a comment

All, Sorry about the cliffhanger on the final tip of my five part series; the Windows installation my DB was on crashed, and I have to recover the OS so I can get the database back up and running. That’s why I just love the Mac. 😉 There will be

Continue reading

Trick #4 – Pull XML with DBMS_XMLGEN

September 23, 2006 Steve Karam News, Oracle 40 comments

Wouldn’t it be fantastic if you could simply pull data from the database in XML? Many shops use XML for data transfer, web services, reports, and more. Oracle’s XML Publisher product can retrieve XML from an HTTP feed and use it to generate rich reports with graphs, images, and other

Continue reading

Trick #3 – Store Any Data with AnyData

September 22, 2006 Steve Karam News, Oracle 3 comments

Today’s (well, yesterday’s really) trick deals with the storage of data. Let me first say that the methods I’m about to show you are NOT useful for where clauses or in normal database design. However, they can be very useful when you need a reference table that can store anything

Continue reading

Oracle Tricks – Many Apologies

September 22, 2006 Steve Karam News Leave a comment

It seems I’ve run out of time in the day…I had hoped to provide an article today on Trick #3, yet work has piled up and I was not able to get it done. Rest assured, despite my previous article, that I did not spend all day playing with my

Continue reading

New Toy! The 80GB iPod

September 21, 2006 Steve Karam Fun, News, Technology 4 comments

I had made a post about the 80GB iPod, how much I loved it, and how great it was, and now suddenly it’s deleted. Ah well, c’est la vie, no? Anyways, I don’t remember everything that was there, but suffice it to say that the iPod is amazing. You can

Continue reading

Trick #2 – Rewrite a Query at Runtime

September 20, 2006 Steve Karam News, Oracle 3 comments

There are many Oracle tools that can wreak havoc on an unsuspecting DBA or developer, but all in all they are for the common good. Though Oracle never puts procedures in place that are made for practical jokes, the DBMS_ADVANCED_REWRITE package comes close. DBMS_ADVANCED_REWRITE allows you to transform queries on

Continue reading

Trick #1 – Copying Users the Right Way

September 19, 2006 Steve Karam News, Oracle 19 comments

Yesterday I announced that I would be doing a five day series entitled “The 5 Oracle Tricks You Never Knew.” Today’s trick is pretty simple, and it allows you to copy user accounts from one instance to another with the same password, grants, roles, etc, without using the exp/imp tools.

Continue reading

The 5 Oracle Tricks You Never Knew

September 18, 2006 Steve Karam News, Oracle 3 comments

Hello all!  Over the next few days I’ll be updating my blog with 5 Oracle tricks that you may not even know about.  They’re all pretty neat, and actually useful to a DBA (one of them is even useful for practical jokes)! These tips will be presented daily in the

Continue reading

I am finally back!

September 7, 2006 Steve Karam News Leave a comment

It has been quite a while since I made a post, but things have been extremely hectic! I took a road trip with my wife and two kids to Oklahoma City from Virginia Beach…this was a three day drive for us, as kids always slow you down as well as

Continue reading

Network

Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On Linkedin

Series

  • LabAlchemy
  • Hadoop Streaming
  • Cloudera Hadoop Training
  • Optimizing WordPress
  • Adventures of Ace, DBA
  • Grow Your Career
  • Database Diversity

Oracle Blogs

  • Amardeep Sidhu
  • Bertrand Drouvot
  • Bobby Curtis
  • Brian Pardy
  • Chet Justice
  • David Aldridge
  • Dimitri Gielis
  • Doug Burns
  • Jonathan Lewis
  • Kellyn Pot'Vin
  • Kevin Closson
  • Kyle Hailey
  • Marco Gralike
  • Oracle Base
  • Osama Mustafa
  • Pete Finnigan
  • Radio Free Tooting
  • Richard Foote
  • Tim Hall

Network

Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On Linkedin

Series

  • LabAlchemy
  • Hadoop Streaming
  • Cloudera Hadoop Training
  • Optimizing WordPress
  • Adventures of Ace, DBA
  • Grow Your Career
  • Database Diversity

Oracle Blogs

  • Amardeep Sidhu
  • Bertrand Drouvot
  • Bobby Curtis
  • Brian Pardy
  • Chet Justice
  • David Aldridge
  • Dimitri Gielis
  • Doug Burns
  • Jonathan Lewis
  • Kellyn Pot'Vin
  • Kevin Closson
  • Kyle Hailey
  • Marco Gralike
  • Oracle Base
  • Osama Mustafa
  • Pete Finnigan
  • Radio Free Tooting
  • Richard Foote
  • Tim Hall
WordPress Theme: Tortuga by ThemeZee.