General discussion

  • Creator
    Topic
  • #2185538

    An Expert’s Guide To Oracle

    Locked

    by lewisc1 ·

    blog root

All Comments

  • Author
    Replies
    • #3050007

      On The Lighter Side – What I like about blogging

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’m an optimist and I was raised to not say anything if I couldn’t say something nice. Now that’s not to say I’m going to say something nice if I don’t have something nice to say. I just won’t say…

    • #3050008

      Prototype – Week 1

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      You unlock this data with the key of Oracle. Beyond it is another dimension – a dimension of indexes, a dimension of queries, a dimension of code. You’re moving into a land of both performance and maintenance, of money and…

    • #3050009

      Sorcerer of OO – Part 4

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Final part of a 4 part series on objects in Oracle. This entry concentrates on creating object tables and object views.

    • #3050010

      Stumble Upon Anger

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This entry is not about Oracle or databases. If you like to surf the web or if you blog, you’ll enjoy reading this….

    • #3050011

      Oracle and Multi-Core Chips

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      EWeek and other media outlets are reporting that Oracle has changed (or is clarifying) its licensing with multi-core CPUs….

    • #3050003

      Prototype – Week 2

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is a quickie entry. I’m troubleshooting a new error. In some ways week 2 is better than week 1. At least I have all of the data loaded now….

    • #3050004

      Prototype Week 3 – A New Beginning

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The week has really just begun but my current project started to really take off on Saturday. I’m knee deep in queries and tuning at this point. When last I wrote, I was having a dreaded ORA-00600. I’m still getting…

    • #3050005

      Prototype – Week 3, part deaux

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Wow. Friday is finally here. The testing is almost done. Isn’t it? Oh. I need to extend for another week to do additional memory sizing tests? IBM is going to love hearing that….

    • #3050006

      Can you beat this?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’ve never seen a memory configuration like this and probably never will again. I just had to post this. If you have a bigger memory pool, post your startup stats….

    • #3049999

      Merge (AKA Upsert) – A Definition in Plain English

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The basic Data Manipulation Language (DML) commands that have been in use over the years are Update, Insert and Delete. They do exactly what you expect: Insert adds new records, Update modifies existing records and Delete removes records….

    • #3050000

      The Weekend of ORA-01122

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Well, has it really been a month of testing already? How long have I been doing this? Let’s see, about 3 weeks before ODTUG and 3 weeks after preparing for the prototype and then 4 weeks navigating around various bugs…

    • #3050001

      Prototype – Week 4, The End

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I was just re-reading my previous post and I don’t think I ever said WHY I was doing this prototype. I mean, this was a huge investment of my time as well as support from several SAs and one of…

    • #3050002

      Oracle and XML In Action – A Real World Example

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’ve written some in the past about Oracle and XML. A couple of days ago, some coworkers had a requirement and I created a simple example to show them one possible solution. I thought I would share that here. The…

    • #3049997

      EnterpriseDB General Availability

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      EDB 2005 is now in general availability. I downlaoded it Wednesday night and installed it Thursday….

    • #3049998

      Telecommuting Questions

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hi all. While I was working on my prototype recently, I spent a lot of time telecommuting. I had a better connection (no proxy) and a faster computer at home. I find that I really enjoyed working from home and…

    • #3067205

      Developing with Open Source and Oracle

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I was recently thinking about Oracle and PHP. Actually I was thinking
      about Oracle and open source in general. The link to the left there
      used to be to Oracle’s Open Source Developer center. Anyway, that got
      me to thinking…

    • #3068232

      A Busy Week

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hi all. This is going to be a busy week for me….

    • #3068233

      Learn Oracle – What is Oracle?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Quick overview of what a database is and what Oracle is. A quick description of Oracle’s toolset.

    • #3067818

      Oracle 10g vs PostgreSQL 8 vs MySQL 5

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Article comparing the ease of installation between Oracle 10g, MySQL 5.0 and PostgreSQL 8.0.

      • #3063722

        Oracle 10g vs PostgreSQL 8 vs MySQL 5

        by chilango02 ·

        In reply to Oracle 10g vs PostgreSQL 8 vs MySQL 5

        I like the evaluation method shown there –of course, extending it to
        many other aspects such as cost, standards-compliance, functionality,
        available support…

        But, to really be useful for an actual decision, I strongly recommend
        to add a weighting value for each one of the factors. Is the ease of
        installation a key aspect t for my specific needs? Then I assign it a
        value of 10; Cost is not so important? Let’s give it a 7; Ease of
        installation is not important at all, so I give it… a 0? a 1?

        That way you will have not a generic table, but one that pretty much gives the answers that your project is asking for.

    • #3066573

      Introduction to Basic SQL, Part 1

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Discussion about basic SQL commands.

    • #3046982

      A New House, Pneumonia, TOAD and Katrina

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Well, I have Internet access again. We moved into our new house on Sunday. I owe it all to a bunch of friends who got together and helped us move. It was only about 50 miles but we sure own…

    • #3055650

      A Personal Update on Katrina

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Thank you for all of your comments. I appreciate them. I have not heard from any of my family in New Orleans or Mississippi. I’ve been calling every number I know….

    • #3055175

      Good News in Spite of Katrina

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I found my Mom! Actually, she found me. She called me last night from West Monroe, La. On Monday, the hurricane hit and by noon, the water was waist high in her house. She grabbed my nephew and they hiked…

    • #3064638

      TOAD User Group Conference/Meeting/Training

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I recently had the opportunity to attend a one-day TOAD user group in Tampa, FL. I was afraid it would either just be a marketing ploy or that it would be so basic that I wouldn’t find it useful. In…

    • #3065805

      TOAD User Group Conference/Meeting/Training, Part 2

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I recently had the opportunity to attend a one-day TOAD user group in Tampa, FL. I was afraid it would either just be a marketing ploy or that it would be so basic that I wouldn’t find it useful. This is the second and final part.

    • #3059824

      News

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is a quick update on my take about some of the recent news from Oracle and some of my opinions about Katrina and its aftermath….

    • #3054389

      Why PHP?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Oracle, the database, already supports PL/SQL. It also supports Java internally. Using ODBC, JDBC or OCI, it supports most other languages. So why make a big deal out of PHP support? What’s so great about PHP? What is ZEND? I…

    • #3062984

      Oracle Collections: A Definition in Plain English Part 1

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’m back. Sorry to be such a slacker lately. Things have just been really busy around here. I finally have my home network back up (mostly, I lost a web server) after the move. I really like my new house…

    • #3060986

      TOAD for MySQL Review

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      A review of the Toad For MySQL Freeware IDE.

    • #3073629

      My Guilty Pleasure

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      It’s the weekend so I’m writing about fun stuff. Not Oracle. Not that Oracle can’t be fun. Saturday night was the perfect night to get some writing done. My son was in bed; my wife was watching her shows in…

    • #3073212

      Oracle Collections: A Definition in Plain English Part 2

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      In part 1 of this series I covered Associative Arrays and Record types. Today I will be covering Varrays and Nested Tables….

    • #3066217

      Looking for a job?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      A good friend and coworker of mine gave his resignation notice recently. He’s going to be going to a great job that I think will challenge him and give him some super opportunities. I wish him the best! That got…

    • #3070203

      My Final Update on Katrina

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is just a note about how everyone in my family is faring after Katrina and Rita. Is this the year of the catastrophe? The last 12 months have been awful. From the tsunami last December to the floods in…

    • #3069687

      Oracle Collections: A Definition in Plain English Part 3

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      In part 1 of this series I covered Associative Arrays and Record types. In Part 2, I covered Varrays and Nested Tables. Today I will be covering Sparse Arrays, Bulk Collect and the FORALL command….

    • #3068748

      Just the FACTA Please

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is just a head’s up for those of you in the US. Have you heard of FACTA, the Fair and Accurate Credit Transactions Act? At it’s most basic, it means you get a free credit report, from the three…

    • #3068686

      I am doing a Reverse Ask Tom

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Instead of providing an interesting solution to a SQL question, I’m looking for a solution to an interesting SQL query. heh…

    • #3058068

      I have my answer! I think.

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Welcome to AnswerLewis. Last week I asked a question. This week I think I have the answer….

    • #3071084

      EnterpriseDB, InnoDB and Oracle

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is just an update on EnterpriseDB. It’s been a while since I posted anything (EDB General Availability). This is just a quick update and some info from Andy Astor, the CEO of EnterpriseDB, on the acquisition of InnoDB by…

    • #3044690

      My Philosophy of Interviewing

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      In May, I posted an entry, How to Interview an Oracle Developer. This was a popular entry back then and seems to keep coming up, even now. Yesterday I got a comment on it from a reader, rash. Based on…

    • #3043723

      Correction to my Analytic Answer

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      So close and yet so far. On October 13, I posted a question. I followed that up with an answer. Turns out, that answer was incomplete….

    • #3046235

      VMWare Player – How sweet it is!

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Have you heard about the VMWare player? VMWare Player allows you to run a pre-built virtual machine on any windows or Linux PC….

    • #3045667

      Oracle 10gR2 RAC on VMWare – A First Look

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Yesterday I wrote about finding VMWare Player, VMWare Player – How sweet it is, a free virtual machine for running pre-built environments. I installed it and played with the browser appliance while I downloaded the pre-built Oracle 10gR2 RAC on…

    • #3115312

      Oracle Express – EDB Killer?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Just about everybody is blogging about Oracle 10g Express, the new free version of Oracle (still in beta). The first I saw is here on Wim Coekaert’s blog: oracle express edition. It looks like Oracle express is almost exactly what…

    • #3114957

      Ralph Kimball – Real-time Data Warehouse Design Challenges

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I “attend” webinars on a somewhat frequent basis. I can usually catch them around lunch time (I’m on the east coast), and since I don’t have to travel it sometimes works out better than a live, in person seminar. Of…

    • #3116687

      EDB and Oracle XE Article

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Just another quick note about EDB and Oracle XE. The Java Developer’s Journal has an article that kind of ties into my entry a few days ago, Oracle Express – EDB Killer?….

    • #3137804

      XE: On Railroad Barons and a definition of Crippleware

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I want to thank IT Toolbox’s resident PostgreSQL guy, Josh Berkus, for a great history lesson, Of Railroad Barons and Crippleware. An interesting read….

    • #3135742

      Oracle RAC & Grid Tuning with Solid State Disk, A Review – Part 1

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Oracle RAC & Grid Tuning with Solid State Disk, sub-titled: Expert Secrets for High Performance Clustered Grid Computing is a pretty specific book covering RAC and how it can make the most of Solid State Disk (SSD). The goal of…

    • #3118355

      Oracle RAC & Grid Tuning with Solid State Disk, A Review – Part 2

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is the second and final part of a review of Oracle RAC & Grid Tuning with Solid State Disk, sub-titled: Expert Secrets for High Performance Clustered Grid Computing, a part of the Rampant Press, Oracle In-Focus series….

    • #3119999

      Railroad Barons, Follow-up Cubed

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is a response to a response to a response to an entry by Josh Berkus. To me, this thread (or debate or whatever) is exactly what blogging is all about: sharing differing viewpoints and opinions. In this particular debate,…

    • #3131702

      XML and OO in Oracle, A Scenario

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’m battling the flu this week and have not been able to write much. I hope this entry will make sense to someone not enjoying a fever. I was laying around thinking about XML and how my current project is…

    • #3132345

      IBM Viper: XML Technology in DB2

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      IBM announced a new version of DB2 called Viper. It looks like it’s mostly a response to XML DB. It stores XML natively and you can access XML with SQL and XQuery. It also looks like it has optimizations and…

    • #3123745

      The largest commercial Linux data warehouse in the world runs Oracle Database

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I found an interesting article, World’s largest commercial Linux data warehouse runs Oracle Database. It’s interesting to note that the current record holder is a 100 Terabyte database. They say that’s triple the previous record holder, which was also Oracle….

    • #3113992

      SAP CEO on Oracle

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Just read this article in networkworld. It’s an interview with the CEO of SAP. He talks about Oracle and several other topics. I thought it would be of interest to many of you….

    • #3123122

      Binary XML – Compressing, Encrypting and Encoding Data in Oracle

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      In this entry, I’m going to cover how to encode, compress and encrypt a text string for inclusion in an XML document. XML by its definition is a human readable, text format. It is a series of fields (elements) and…

    • #3123203

      Hardware Upgrades at Home

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Christmas comes early for me this year. And strangely enough, it was dying computers that started it all. When I made the move to my new house, one of my older servers died. Not long after that, the wife’s laptop…

    • #3128022

      Help me out – take a poll

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      When I moved into my house, before I had my broadband account setup, I noticed that my wife had her laptop running and was surfing the internet. After a little research, I found that there was a linksys router running…

    • #3127835

      Oracle Buzz, Episode 1 – Podcast

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Oracle Buzz Episode 1, Nov 2005 The Oracle Buzz is my take on the news, trends and topics that have the bloggers blogging in the world of databases. I concentrate mainly on the Oracle world but I’ll also cover other…

    • #3129841

      Accessing Multiple XE Databases from a single machine

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I was asked by a friend of mine how he could access the XE databases that he has. There’s one on a server, one on a co-worker PC and one on his desktop. All of them are called XE. He’s…

    • #3121053

      Answers: Security and Garbage Collection

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      It was a very busy week and weekend for me so instead of finishing the database links article I’m writing, I thought I would try to answer some questions that have been posted to some of my past articles….

    • #3121322

      XE, XML and WebDAV – Access your XML data in Oracle XE

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The question I probably receive most is how to create XML so that it can be accessed via ftp, http or even from the desktop and tools like MS Word. XML DB can do this and it’s pretty easy to…

    • #3125228

      Cryptography in the Database

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      There is a new security book out called Cryptography in the Database: The Last Line of Defense. It’s written by Kevin Kenan and published by Addison-Wesley Professional….

    • #3197576

      Oracle Buzz, Episode 2 – Does it ever get any easier?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The Oracle Buzz is my take on the news, trends and topics that have the bloggers blogging in the world of databases. I concentrate mainly on the Oracle world but I’ll also cover other topics that interest me. I’m back!…

    • #3196656

      Database Links: A Definition in Plain English

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      What is a Link? A database link is the way Oracle allows you to connect from one database to another. There are several types of links and I will discuss each of those. Database links are also used in heterogeneous…

    • #3198452

      Merry Christmas and Happy Holidays

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Whatever your holiday of preference, I hope you have a great one. My family (wife and 2 year old son) and I are leaving today to go for a visit to New Orleans. It’s our first time back since Katrina…

    • #3083586

      Back in Town

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hi all. Thanks for your comments and emails during the holiday. I had a very busy vacation. It was non-stop from the day we got there to the day we left. I’m working on a podcast about my trip and…

    • #3081019

      Review: Oracle Streams, High Speed Replication and Data Sharing, Part 1

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This entry is the first of a two part review of the book Oracle Streams, High Speed Replication and Data Sharing by Madhu Tumma. In this review, I will list what topics are covered by this book, a chapter by…

    • #3094395

      2006 Has Arrived! Tell me what you want to see (and hear)!

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Happy New Year! 2005 had its ups and downs but overall was a pretty good year for me. One of the best things was this thing called blogging. I hope you’re finding this site useful. My goal is to provide…

    • #3095403

      Review: Oracle Streams, High Speed Replication and Data Sharing, Part 2

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This entry is the second of a two part review of the book Oracle Streams, High Speed Replication and Data Sharing by Madhu Tumma. In the first part, I included the topics covered and the chapter by chapter overview of…

    • #3078098

      Growth in 2006: A New Job(s) and My First Presentation, and some Poll Results

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Today’s entry is all about growth in 2006. Where will the career go this year; what do I need to do to make it happen; and what will we make of this blog….

    • #3080098

      Been a Busy Week

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hi all. Work and side projects have me overwhelmed this week. As I mentioned earlier this week, I’m working on a couple of presentations. Of course work seems to keep intruding on all of my fun….

    • #3077607

      Claiming My Blog For Technorati

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Technorati Profile I’m doing to for Technorati. I thought I had already done this but it appears it didn’t take. Thanks, LewisC…

    • #3079282

      Forget About TNS: Connect To Oracle Using Easy Connect

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Have you ever needed to get to a database but didn’t have the TNS entry for it? Would you like to connect to a database and have no idea what TNS, or more importantly the TNSNAMES.ORA file, is? Today’s entry…

    • #3097101

      Oracle Databases: Starting a Career, Part 1

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The question I am asked most frequently, by far, is how to go about starting a career in the Oracle world. This entry starts a new series of articles about how to go about learning Oracle and starting a new…

    • #3097817

      ODTUG: Desktop Conference

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The Oracle Developer Tools User Group (ODTUG) is putting on a virtual conference called Desktop Conference 2006. The conference is sponsored by the BI/DW SIG and it runs Feb 21-23. I will be making a couple of presentations. I’ll be…

    • #3258611

      Oracle Databases: Starting a Career, Part 2

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      So you want to learn “ORACLE”. What exactly does that mean? What do you WANT to do?…

    • #3109783

      Oracle Databases: Starting a Career, Part 3

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      In this, the third part of this series, I will answer a few more FAQs. I will follow this entry with one more on this topic and then I will move back to my technical articles….

    • #3109379

      Is it TOra, TOAD or a little bit of both?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      TOra is an open source, Linux and windows database IDE that functions a lot like TOAD. Several of my co-workers really like it, mainly because it runs under Linux, which TOAD does not….

    • #3134053

      Friday already?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      How did that happen? There I was just minding my own bidness, when work jumped up and smacked me with the busy stick. Which is better than the time I got hit with the ugly stick but that’s another story….

    • #3134996

      Want a FREE VMWare Server?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      VMware cuts VMware Server price to zero VMWare is releasing a free, entry level virtualization product for Windows and Linux….

    • #3093443

      How to Ensure a Strong Oracle Password

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Sophos recently blogged about weak passwords and the hashing mechanism in Oracle. Today I wanted to discuss how easy it is to ensure strong passwords in your database….

    • #3133048

      ODTUG Kaleidoscope 2006

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I had an abstract accepted for ODTUG Kaleidoscope 2006 in Washington DC in June….

    • #3092321

      Oracle BI/DW Blog

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Today I read a post by Mark Rittman that reminded me why I make his blog a regular read. Today he wrote about Understanding Oracle OLAP Memory Management. It’s a fairly brief post considering he discusses the PGA, SGA, UGA,…

    • #3253922

      Oracle Announces Layoffs

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      News from CNET: Oracle outlined its integration plans for Siebel Systems on Thursday, with 2,000 job cuts among the most notable tasks at hand. It goes on to say that most of the layoffs will be Oracle people, not Siebel:…

    • #3253921

      Oracle 3rd Quarter Looks Good

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Yahoo posted a reuters article on an Oracle Filing with the SEC, Oracle sees third-quarter revs up 17 pct to 19 pct….

    • #3253720

      Oracle Buying into Open Source?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Business week has a great article, Oracle’s Open-Source Shopping Spree. In the article it talks about Oracle buying three different open source software companies, the biggest of which may be JBoss. I didn’t know any of the three were on…

    • #3090950

      Flashback 1999: Dell to sell Oracle database appliances

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      A database appliance? From Oracle? I must have slept through that announcement!…

    • #3091626

      Oracle Databases: Starting a Career, Part 4

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Now that you know where to start, what you want to do and you have some beginning steps, what is the secret to getting the job? I’ll do my best in today’s post to answer that question. This is the…

    • #3080730

      Building an XML Utilities Package, Requirements

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I am frequently asked different questions about PL/SQL, XML, getting started, methodologies, etc and have decided to bring all of that together into a set of posts. I will build a utility package to help me debug and test my…

    • #3252076

      Flashback 1987: What will 2007 be like?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Unrelated to Oracle and databases but somewhat related to technology in general: Madville ran an article today, OMNI Poll: What will 2007 be like? (From 1987). It’s an opinion poll by Omni magazine from 1987. It’s neat how right and…

    • #3090648

      New Version of Oracle SQL Developer (Raptor) Available

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Oracle SQL Developer, i.e. Raptor, Early Adopter Release 4.1 was posted on Feb 17. SQL Developer is the new Oracle SQL and PL/SQL GUI….

    • #3101392

      ODTUG Desktop Conference

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hey, if you enjoy my blog, please nominate me for the IT Toolbox Community Choice Awards. It only takes a minute or so. Unfortunately, I will be out of town with no internet access during the voting period. The ODTUG…

    • #3103075

      My XE Presentation

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Well, the presentation is over. I hope people enjoyed it. I can’t tell; there’s not much feedback in a virtual conference. I really thought a virtual conference would be better for a first timer like myself but now I think…

    • #3101711

      Oracle 10g Security and Audit Presentation

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I just finished my second, and final, presentation for the ODTUG Desktop Conference 2006: Implement Security and Audit in Oracle 10g . Well, I have to say I think yesterday went better than today. I asked for open audio to…

    • #3101067

      Oracle Supports MS-SQL Server

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I never thought I would say this but it looks like Oracle Enterprise Manager can now manage SQL Server, BizTalk, Commerce Server and Active Directory. Check out the EWeek article, Oracle Adds .Net, Windows Server Support to Enterprise Manager….

    • #3273707

      Taking a vacation

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hello everyone. My wife and I are taking a much needed vacation. This time there are no relatives to go see or conferences to attend. We’re heading out to the caribbean for 7 days on Legend of the Seas….

    • #3085584

      Back From Vacation

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’m back! What a great vacation. If you’re in the market for a cruise I can definitely recommend Royal Caribbean and its 7-day western Caribbean trip. Take a look at some pictures. I’m going to be posting a day by…

    • #3085516

      Is an open source release “news”?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’m catching up on all the news I missed last week and ran across this essay: “Software released under an open source license” is no longer news. An interesting read. I like his comment about open source databases….

    • #3086110

      Oracle XE: Read my article at OTN

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I have an article on the OTN XE Home page, Oracle Database 10g Express Edition: Not Just for Learners. How cool is that!…

    • #3266764

      Building an XML Utilities Package, XML Debugger Part 1

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Today we’ll start designing and coding our package. We need to remember to start simply and build it up as we go along. The design itself can be grown as issues arise. On a project involving multiple platforms and tens…

    • #3267565

      Oracle XE: Read my article at OTN, Part Deaux

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I know I’m tooting my own horn, but my article, Oracle Database 10g Express Edition: Not Just for Learners is now on the main OTN homepage. In my previous entry about the article, I said “How cool is that!” This…

    • #3149926

      BEPELL, BEOPLE or BIPPLE? The Oracle Architect Forum

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Inquiring minds want to know: Is BPEL pronounced Bepell (like spell
      but with a BE), Beople (like people with a B) or Bipple (like nipple
      with a B)? The answer is below.

      Yesterday I had the opportunity to attend the Oracle Architect Forum
      in Tampa, FL. The forum was hosted by Oracle at the beautiful Hyatt
      near the Tampa Airport. I’d guess there were about 50 people in
      attendance.

      Here’s some info from the invite:

      To view the rest of this article, Navigate to BEPELL, BEOPLE or BIPPLE? The Oracle Architect Forum

      Thanks,

      LewisC

    • #3150942

      Oracle Data Vault

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I just ran across this post from EWeek, Oracle Locks DBAs in the Vault.
      A quick read of it shows that it’s a security add on to restrict DBA
      access to privacy data. A solution for audit requirements for things
      like Sarb-Ox and HIPAA.

      A look at the Oracle Database Vault page on OTN, adds some more context:

      What is Oracle Database Vault?

      You can read the rest of this blog entry at Oracle Data Vault.

    • #3161689

      Get the XML out of your database, via HTTP

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I recently wrote about getting the XML out of your database using a less preferred method (UTL_FILE). Today, I am going to show you how to do it via one of my preferred methods. Of course the easiest method is just to return an XMLType from a stored procedure and let the calling routine figure out what to do with it. Instead of that way though, I’ll show you how to do it via HTTP. It’s all completely built into 10g and is super easy to use.Read the rest of this blog.

    • #3146113

      Dynamic Paging, Calling Oracle XML From Java

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Last week I wrote about how to dynamically get paged results from a stored procedure using either a ref cursor or an XML document. Rakesh wrote and asked to see an example of a call using Java. So that’s what I wrote.I think the code is pretty much self-explanatory. I used jDeveloper to compile this. It’s a console app that connects to the HR account of an Oracle XE database and returns some employee last names. Read the rest of this article.

    • #3156678

      What is the difference between Oracle, SQL and PL/SQL?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Recently, Sudhat read my Introduction
      to Basic SQL
      and had this to say:

      The article is very interesting. Too Good!

      And also please describe what is the difference between SQL and Oracle and PL/SQL.

      Sudhat, thanks for the comments. I
      love to hear feedback.

      And your question is a common one so I
      thought I would address it as a blog entry instead of a reply to your
      comment. I’m going to expand on it a little bit also. In addition
      to SQL and PL/SQL, I hear people refer to SQL commands so I am going
      to address the question, “What is the difference between SQL,
      SQL Commands and PL/SQL.”

      Read the rest of this article.

      Thanks,

      LewisC

    • #3166284

      And you thought your commute was bad!?!?!?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Non-oracle post here.

      How would you like to drive 370 miles to work. That’s TO work. You would then turn around and drive back home in the evening. 740 miles per day. 7 hours a day in traffic. And the guy who has to do it says: “To me, this is not that long a commute,” he added. “It’s just something I do to go to work.”

    • #3166282

      BEPELL, BEOPLE or BIPPLE? The Oracle Architect Forum

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Inquiring minds want to know: Is BPEL pronounced Bepell (like spell but with a BE), Beople (like people with a B) or Bipple (like nipple with a B)? The answer is below.

      Yesterday I had the opportunity to attend the Oracle Architect Forum in Tampa, FL. The forum was hosted by Oracle at the beautiful Hyatt near the Tampa Airport. I’d guess there were about 50 people in attendance.

    • #3166281

      No ODTUG Conference For Me This Year

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      It’s with sadness that I have to announce that I will not be able to attend or present at ODTUG this year. It’s something I have been planning since last year (when they asked for abstracts). It’s something I still hope to do in the future and hopefully my inability to attend this year won’t be held against me in the future.

    • #3166280

      TBTF: The Man From NASA

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I had an invite from Oracle to attend a luncheon with the Tampa Bay Technology Forum (TBTF) to listen to Russell Romanella, the Director of the Space Station Processing Directorate at Kennedy Space Center, speak about NASA, the space shuttle program and going to Mars.

    • #3166278

      Need Input: Oracle SCM and .Net SOA

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hi all,

      I have a couple of issues in my new job. I’d like to hear from some of you and get your thoughts and ideas. Specifically, the questions are about database change control and SOA using .Net.

    • #3166277

      Yahoo Answers! WTF?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I stumbled across a beta site for Yahoo Answers. Apparently it’s a site where you can ask a question and really smart people will answer you. From the blurb on the about page:

      What is Yahoo! Answers?

      Yahoo! Answers is a place where people ask each other questions on any topic, and get answers by sharing facts, opinions, and personal experiences.

      Ok. So I decided to ask about Oracle. More specifically, I did a search on the keyword Oracle to see what others hav

    • #3166276

      Dynamic Paging of Data for Java and .Net

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The last couple of weeks have been really head’s down for me. I’m learning a new application, a new database (including a data warehouse) and learning how .Net can integrate with Oracle as a robust architecture for application development.

      Anyway, a common need for Java and .Net is the need to page through result sets. Paging in .Net is particularly important when running on 32 bit windows. The executable that runs the server can only address 2GB of memory. If you have 1

    • #3166275

      Dynamic Paging of Data, Retrieve XML instead of REF CURSOR

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      A couple of days ago I wrote about paging through data using a REF CURSOR and dynamic SQL. Today I’m going to expand on that. Instead of using a REF CURSOR, it would be nice to pull back an XML document with just the subset of records the REF CURSOR would normally provide.

    • #3166274

      Dynamic Paging, Calling XML From Java

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Last week I wrote about how to dynamically get paged results using either a ref cursor or an XML document. Rakesh wrote and asked to see an example of a call using Java. So that’s what I wrote.

    • #3166273

      Presenting XML and SQL Analytics

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The Suncoast Oracle User Group (SOUG) First Annual Tech Day is over. I had presentations on XML in Oracle and SQL Analytics in 10g. It was a great day and I think most people felt it was a truly worthwhile day. Attendance was good at about 175 people. It was a free day so I’m not sure why more people didn’t show up.

    • #3166272

      Oracle is the Database Top Dog!

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      According to Tom Taulli at The Motley Fool, Oracle leads the database pack at almost 50% of the market. IBM is at 22% and Microsoft is at 15%. This is according to IDC and Gartner. I haven’t seen the actual report yet.

      And while Open Source is growing, I think it will still be a while before it catches Oracle. Of course as an investing oriented site, they need to mention the “storm clouds on the horizon.” But, the sky isn’t fall

    • #3166271

      Would you like to Podcast?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hi all,

      I’m thinking about getting back on a regular schedule for podcasting. I just recently did one (which will be published soon) and have been doing some thinking.

      From previous podcasts, one of the comments I got was that I should add a co-host and get some outside participation. So that’s what I’m doing. I’m looking for people to participate in a monthly Oracle Buzz podcast.

      I’m looking for three different kinds of participants.

      OP/ED

      Do you have a rant? Do you absolute

    • #3164991

      Not Oracle Related – I hate lovebugs!

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      How, you might ask, can someone hate something with the name “Lovebug”? Oh, let me count the ways.

      First off, I’m pretty sure the latin name for these things are “insectus paininthebutticus”. These bugs are a type of fly. At this time of the year they get the, ummm, urge to procreate. Two of them, I assume male and female, attach themselves to each other by the, uhhhh, I’ll leave the exact parts un-named. They fly around, attached to each other, mindlessly smashing into stuff. They are li

    • #3164341

      Introduction to Basic SQL, Part 2 – Joins

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      In my last article, I introduced you to some basic SQL commands and some new concepts, mainly the data dictionary. Today we will get a little further into basic SQL by joining two tables in a single select statement.
      In the last article, I glossed over the difference between a view and a table, so I would like to clarify that here. A table is the basic storage for your data in the database. A table is made up of rows and columns. A view is a stored query that appears to be a table. For example:

      Create view abc as select * from all_tables;

    • #3143510

      Introduction to Basic SQL, Part 3 – Complex Joins and Sub-queries

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      In my previous article, I covered SQL Joins with two tables. Today, I will cover joining tables with three or more tables and using sub-queries to join. I’ll also throw in some details about the UNION clause and show other places a sub-query might be used.

    • #3143509

      Oracle and Open Source DBs

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is an article from ZDNet Asia, Open source shapes up as rival to Oracle. It’s a good read and kind of relates to my entry, Oracle is the database top dog.

      It’s a good read. Based on technology though, I still can’t understand why reporters and the rest of the media keep insisting that MySQL is a competitor

    • #3144194

      Ray Lane on Web 2.0

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Ijust read an article on Business Week Online, A VC’s View of Web 2.0. The sub heading is: “The day of giant corporate software packages is over, says Oracle vet Ray Lane. The future lies in bottom-up, user-driven services.” Ray is an ex-president and ex-COO of Oracle.

      I didn’t realize he had gone to work for a VC firm. He has some good thoughts on Web 2.

    • #3144997

      Celebrate Moon Day, July 20 or 21

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Have you ever heard of Moon Day? Read an editorial by Sheila Williams from Asimov’s, Moon Day. If you’re not a fan of science fiction (is that possible?), don’t worry, this is an editorial not a science fiction story.

      I’d like to believe that it’s science fiction that it has been 33 years since anyone walked on the moon. Sadly, that’s a fact.

      I remember watching a moon landing (I don’t know which) on a giant console TV when

    • #3145466

      Oracle Buzz Episode 3, VLDB and the Oracle Partitioning Option

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The Oracle Buzz is back! This time it’s coming to you from ITtoolbox.com as a Premium Blogcast sponsored by Oracle Corporation.

      The Oracle Buzz is my take on the news, trends and topics that have the bloggers blogging in the world of databases. I concentrate mainly on the Oracle world but I’ll also cover other topics that interest me.

      In this episode I concentrate on Very Large Databases

    • #3164780

      Generate XML Schemas for your Data

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      A reader recently asked:

      Hi,

      We are using Oracle eBS and 9i (XML DB not installed), and need to generate XSDs from the client site using SQLPlus. DTDs are currently generated from the client: the SQLPlus script calls a database package that creates a bunch of DTDs from a table that describes all parameters/tags of the XML in a manager-to-employee-nested way. Now, instead of changing the source (1 gazillion lines of code..) to a produce XSD syntax, I guess t

    • #3155649

      DB2 Security Glitch Makes IBM Whine

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      EWeek reports DB2 Crack Let’s in Attackers Without Database Credentials. This is a vulnerability that let’s anyone with network access to the database (i.e. any remote user) bring it down or run database code.

    • #3154932

      Oracle: The biggest Linux vendor you

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      TMCNet has a really good article, Oracle: The biggest Linux vendor you’ve never heard of. I knew Oracle invested heavily in open source but I didn’t realize to what extent. I certainly didn’t realize what they’ve contributed to the Linux kernel. It makes sense.

      From the article:

    • #3268563

      Oracle: The biggest Linux vendor you

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      TMCNet has a really good article, Oracle: The biggest Linux vendor you’ve never heard of. I knew Oracle invested heavily in open source but I didn’t realize to what extent. I certainly didn’t realize what they’ve contributed to the Linux kernel. It makes sense.

      From the article:

    • #3268561

      Bill Gates Leaving Microsoft

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I was really expecting to see more blog entries about this. Since no one has posted about it, I thought I would.

      Bill Gates has decide to leave MS. He’s going to stay on a part-time basis and will stay on the board but will no longer be the Chief Architect.

    • #3268562

      Sweet, sweet numbers for Oracle

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Justin Kestelyn, Oracle Technology Network Editor-In-Chief, just posted a blog entry, Preliminary Financial Results Out.

      New License Revenues Increased 32%. That exceeds previous guidance.

      He has a link to the numbers. Check out his entry.

      LewisC

    • #3145951

      Oracle: The biggest Linux vendor you

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      TMCNet has a really good article, Oracle: The biggest Linux vendor you’ve never heard of. I knew Oracle invested heavily in open source but I didn’t realize to what extent. I certainly didn’t realize what they’ve contributed to the Linux kernel. It makes sense.

      From the article:

    • #3142010

      Oracle: The biggest Linux vendor you

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      TMCNet has a really good article, Oracle: The biggest Linux vendor you’ve never heard of. I knew Oracle invested heavily in open source but I didn’t realize to what extent. I certainly didn’t realize what they’ve contributed to the Linux kernel. It makes sense.

      From the article:

    • #3141814

      Oracle Magazine Profile

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’m rich and famous! Well, maybe just famous. Not really famous maybe, but I am in the July/August Oracle Magazine. The electronic version isn’t out yet but I got my hard copy today. When they post the July issue online, I’ll add a link.

      I have a profile in the peer section. The picture is from my trip to Belize this past March. I was in the jungle on the way to a cave excursion.

      You can

      This post originally appeared on an external website

    • #3269503

      H-1B Pay Drags Down Salaries

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      So says a recent article at ddj.com. In the article, H-1B Drags Down All Salaries author David Roman describes the way US Department of Labor calculates and tracks wages.

    • #3143948

      Oracle: The biggest Linux vendor you’ve never heard of

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      TMCNet has a really good article, Oracle: The biggest Linux vendor you’ve never heard of. I knew Oracle invested heavily in open source but I didn’t realize to what extent. I certainly didn’t realize what they’ve contributed to the Linux kernel. It makes sense.

      From the article:

    • #3142245

      ITtoolbox CEO Dan Morrison Talks About Web 2.0

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The CEO of ITtoolbox.com is interviewed by JDJ.

      A couple of lines from the interview:

      I came up with the idea for ITtoolbox while working on my first job out of college at Ernst & Young as a software consultant.

      I hate him.

      I think someone looking to get into the online community space would be wise to focus on creating value for people. There is a great deal of innovation going on with personal publishing and collaboration tools. However, I believe

    • #3142116

      Oracle XE Presentation at the SOUG

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’m going to be presenting on Oracle XE tomorrow, June 22, at the Suncoast Oracle User Group (SOUG). You can get info at the SOUG meeting page.

      I will be doing the same presentation I made for the ODTUG Desktop Conference earlier in the year. Because I have more than an hour, I am going to have a lot more hands on demo’ing. I’ll also put ApEx and SQL Dev

    • #3270518

      Interesting SQL Question, Pivot 1 column into multiple rows

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This effort is an example of how I decompose a problem and some fun SQL tricks. Not tricks, I guess but maybe a creative use of SQL.

      A couple of days ago, a question was posted on one of the itToolbox.com email groups:

      From: Brat
      Subject: [oracle-sql-l] COnverting one field into multiple rows

      Message:

      How do I parse this one field in a table into multiple rows:

      Field 1

      1,2,3,4,56

    • #3112403

      SQL Question: Pivots, Analytics and the judicious use of Row_Number()

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      A few days ago I answered a question from brat about converting 1 field into multiple rows. We solved that question but now we want to handle multiple rows in our source table.

      Just a note of warning. This article will really make a lot more sense if you follow along in SQL*Plus, TOAD or some other tool and if you run through the other article first.

    • #3111745

      The Joys of Public Presentations

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I wrote recently that I would be presenting to the Suncoast Oracle User Group.

      I did that last Thursday. Oh what a day it was.

      It started off as a very long day. I went into work early so I got up about 1 ? hours earlier than I normally do. I worked a full day and then drove for an hour from Bradenton, through St Pete and into Tampa where the

       This post originally appeared on an external website

    • #3113136

      Oracle Content Database and Oracle Records

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Here’s a news story that completely slipped by me. Oracle has released a couple of new tools for content management, Oracle Content Database and Oracle Records.

      This is an interesting article from ZDNet but doesn’t give a lot of info. I’ll have to do a little bit more research into them. Just from this article, I’m thinking they are based on iFS?

      It sounds like they already have some customers for them.

    • #3111312

      Independence Day

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      On Tuesday, July 4th 2006, the United States of America celebrates its independence. Over 200 years ago, a new nation was born. It created itself out of colonialism and made its own destiny on the world stage.

      Whether you look to the US as a model to copy or as something less desirable, it’s impossible to deny the world changed when it was born. And whether you agree with the current government or its policies, the world was made a better place because of its birth. The US and the democrati

    • #3113473

      Interview with Larry Ellison

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      The Telegraph.co.uk just released an interview with Larry Ellison, A winning strategy based on innovation.

      It’s a good interview and shows some of his thinking with all of the recent acquisitions.

      I’ve heard plenty of Oracle competitors say things like “Oracle has bitten off more than they can chew” or that “Oracle can’t integrate everything they’ve bo

    • #3168646

      Oracle: what you need to know

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I was researching something for a different article and ran across this old article from vnunet.com, Oracle: what you need to know.

      I like the occasional (voluntary) flashback. This one (Feb 1999) has a neat timeline of Oracle high-lights. I love reading these old articles. I like old advertisements too.

      Sometimes it’s good to be reminded that it was not that long ago that we were running DOS 3.3 on a 286.

      A f

    • #3166846

      SQL Question: When the Pivot data contains a Key Column (and character data at that!)

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I recently wrote about pivoting (or is it unpivoting?) some data. A new wrinkle has been added.

      Let’s say that the data now looks like this:

      INSERT INTO X ( FIELD1 ) VALUES ( 'row1,1,2'); 
      INSERT INTO X ( FIELD1 ) VALUES ( 'row2,2,3'); 
      INSERT INTO X ( FIELD1 ) VALUES ( 'row3,4,5,6'); 
      

      This post originally appeared on an external website

    • #3209773

      Learn PL/SQL: Structure and Comments

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’m going to be expanding my
      entries on learning Oracle to include PL/SQL. I’ve already written a
      few entries about basic SQL. Today I start writing about basic PL/SQL.
      I’m going to keep these entries bite-sized and never more than 2 or 3
      topics per entry. Today is a discussion of the structure of PL/SQL code
      and how to comment your code.What is PL/SQL?

      This post originally appeared on an external website

    • #3209771

      Learn Oracle: Article Index

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’ve written quite a few
      tutorial type entries in the last year and a half. You can find them if
      you search but I thought it would be easier to post an index of links
      that I can keep updated. This post is also a good place to
      request particular topics. Post a comment describing what you’re
      looking for and I’ll add it to the queue of articles I plan to write.In
      the index below are links to the tutorial type posts that I have done
      and a road map of articles I plan to write. I’ll be updating the road
      map over time also. I plan to write on topics other than those outlined
      here. The road map only covers those articles I think of as tutorial
      oriented.

      This post originally appeared on an external website

    • #3209769

      I am an Oracle ACE!

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hi. My name is LewisC and I’m an Oracle ACE. How cool is that! I like the sound of it.

      Andrew Clarke recently posted On Becoming an Oracle ACE.
      The way I ended up an ACE was a little bit different than his. I did a
      little bit of all the things he mentions except write a book (and hey,
      maybe that’s in the future).

      I also did not realize that APC
      and Andrew Clarke were the same person. I’ve seen APC in the forums a
      lot. APC has 5,743 posts since 2003. Amazing. I won’t mention how many
      I have. It’s not even statistically significant next to that.

      I
      like his article and particularly agree with one comment he makes: If
      the activity is not meaningful to you irrespective of ACE-hood then you
      probably won’t make the grade anyway.

      I’m not saying that if
      you want to be an ACE you shouldn’t set out to be an ACE. A lot of
      newbies might accidentally be helped along the way. But if you really
      don’t enjoy answering questions and helping people out (at least when
      it comes to Oracle), you probably won’t last long enough to become an
      ACE.

      And when I mention answering questions, I don’t mean, “Dude, RTFM!”. That’s not an answer.

      Read the rest of this post

    • #3211022

      Oracle SQL Developer: New Article on OTN

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I have a new article on OTN. Making the Most of SQL Developer Reports.

      The article walks through creating both very simple and somewhat complex reports. It also covers adding bind variables, customizing the bind dialog and creating drill down reports.

      SQL Developer has a lot of report development functionality and I think it will just get better over time. Setup is really minimal (just need to unzip and connect to a database) and if you can write basic SQL you can write basic reports. The more complex SQL you can write, the more complex your reports can get.

      There are a lot of users that should never get near a tool like SQL Developer (more for their sanity than anything else) but it’s a great new tool (free at that) for power users and analysts in addition to developers and DBAs.

      I also like my mini-bio at the bottom. It’s the first article I’ve had published that mentions my ACE-hood. heh

      Read the rest of this article.

    • #3208476

      Learn PL/SQL: Declaring Variables, Named vs Anonymous Blocks

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is part 2 of a series on learning PL/SQL. If you are new to PL/SQL, you should read part 1 first.

      Also, check out the Article Index.

      Declaring Variables

      We’ve
      spoken about the declaration section of a PL/SQL block. The declaration
      section is the first section of a block. In the declaration section you
      will identify a variable (give it a name), declare the datatype,
      optionally declare it as a constant and optionally assign it a value.

      I’m
      going to discuss PL/SQL datatypes in detail in a future article. For
      now, don’t worry so much about the data types as about the format of
      the declaration.

      Read the rest of this post!

    • #3208475

      Learn Oracle: Datatypes for SQL and PL/SQL, Numbers

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Datatypes are a subject that
      confuses many people. There are many types and many sub-types. A type
      is a basic datatype like NUMBER. A sub-type is derived from a type. An
      INTEGER is a sub-type of NUMBER. A sub-type usually add a constraint to
      a type and that creates the new sub-type; for INTEGER, only whole
      numbers are allowed.

      In 10g, the five numeric types that you
      will most commonly use are: NUMBER, PLS_INTEGER, BINARY_INTEGER,
      BINARY_FLOAT and BINARY_DOUBLE. You would declare and use any of these
      in the same manner, although the BINARY_FLOAT and BINARY_DOUBLE add a
      few extra features that I cover below.

      Read the rest of this post!

    • #3208474

      Learn Oracle: SQL and PL/SQL Datatypes, Strings

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      There are several types of character data types for your use in SQL and PL/SQL. Unlike the NUMBER data type, there are some differences between SQL and PL/SQL character types.

      I
      won’t cover LOB (Large Objects) in this article. It could be argued
      that a CLOB is nothing but a large string, but I will write a special
      article to cover CLOBs, BLOB, and BFILEs.

      Today I am going to
      cover the three primary character types and talk a little about about
      their differences and about some sub-types.

      Read the rest of this post!

    • #3215156

      Looking for a co-worker.

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I won’t normally use this blog
      as a job board but I need some help and I would like to make sure I get
      someone good. And if you read this blog, you must be good! 😉

      Are you a hard-core PL/SQL developer? Are you great with complex SQL? Do you know XMLType and the XML APIs inside and out? Do you want to work in sunny Bradenton, Florida?

      I
      don’t yet have rates or anything but the approvals are coming. At this
      time, I cannot say what this will pay. I just don’t know at the moment.

      I’m designing an interface for a business intelligence application. We’re running on a fairly large, fairly
      complex data warehouse. It’s not the biggest I’ve worked with, nor the
      largest, but it provides plenty of challenges.

      I need to finish
      by the end of the year. And that means I need a hard core PL/SQL
      developer who is also very comfortable with XML. I would prefer someone
      who is comfortable with SQL Analytics but if you are good with SQL, you
      can pick up the analytics and if I have to, I can write the complex
      queries. I’m more concerned with the person knowing PL/SQL and XML
      inside and out.

      It’s looking like a 3-4 month contract. It is
      NOT a perm position at this time but if you work out well, I will try
      to make it so. Doesn’t mean it will happen, just that I can try. I
      personally feel that this is a position that should be perm but I’m not
      the guy that gets to make that decision.

      This is also an on-site position. No tele-commuting. This position will report to the development manager.

      So,
      if you have these skills and live in or around, or would like to live
      in, Bradenton, Florida; send me an email and your resume. I will
      respond to all (I hate when people don’t respond. That is so rude.).
      Please put “DEV RESUME” in your subject so that your email doesn’t get
      eaten by the spam monkey. If you don’t hear from me after a few days, assume that the spam monkey ate it and try again.

      My email is lewisc and the host is rocketmail dot com.

      BTW,
      we also need a really good C# developer that has Oracle experience. If
      you have deep, n-tier C# on Oracle experience, you can send me your
      resume for that, I can pass it on to the appropriate people. 5-years of
      OO and .Net are required.

      Thanks,

      LewisC

      • #3276961

        Looking for a co-worker.

        by welshbilly ·

        In reply to Looking for a co-worker.

        Hi Lewis,

        Although I don’t have the skills you are looking for, if you require a general dogs body, someone to make tea/coffee or just peal you a grape I would love to make the move from the UK to sunny Florida! As anywhere sounds more appealing than working in a basement.

        Good luck with your search.

        🙂

      • #3276954

        Looking for a co-worker.

        by lewisc1 ·

        In reply to Looking for a co-worker.

        I’ve often thought about hiring a grape peeler but just don’t have the budget (or enough grapes). 😉

        LewisC

    • #3213268

      Learn Oracle: Datatypes for SQL and PL/SQL, Dates

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Use the article index for more articles on this subject.

      Oracle
      10g provides three types of date related datatypes: date, timestamps
      and intervals. Today I will be talking about all three of these.

      DATE

      The
      DATE datatype is a datetime datatype. It stores a date and a time. The
      date portion is based on the number of days since January 1, 4712 BC.
      The time portion is based on the number of seconds since mid-night.

      A date field is declared as a variable name followed by the DATE keyword:

          v_date_field DATE;

      There is no “correct” format for a date. The format is determined by several variables. At the database
      level, you can set the NLS_DATE_FORMAT. Regardless of how the default
      is set in your database, you should always make sure you explicitly use
      a date format mask when converting.

      I will cover conversion
      functions for all data types in a future article but I think this is
      important.

      If you need to compare a date to a literal, make sure to use
      a date format mask. You could say:

      WHERE date_field = ’01-01-1999′

      or you could say:

      WHERE date_field = to_date(’01-01-1999′)

      I
      would consider both of those bad programming practices.

      The first is
      allowing an implicit conversion between character and date and both of
      them are assuming some kind of default date format. A better practice
      would be to use:

      WHERE date_field = to_date(’01-01-1999′, ‘DD-MM-YYYY’)

      And
      that leads us to why we use a DATE instead of a character field or a
      numeric. I’m often asked about best practices with dates and times. For
      some reason I have never understood, some people feel that storing
      dates and times as characters and numbers is better than allowing
      Oracle to handle that data in a native format. Call me lazy, but if
      Oracle can do it for me, I am going to let it.

      Read the rest of this post

    • #3276879

      Using a PL/SQL Table in SQL

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      A friend of mine called a few
      days ago with a question. He wanted to populate a PL/SQL table and use
      it to compare to some other data via a NOT IN subquery. He was having a
      problem getting the data into the nested table and wasn’t sure how to
      access it from SQL after he did.

      Because
      he had the question and was having a problem implementing it, I figured
      others might have the same issue. I wrote a very simple script showing how this can be done and thought I would post it here for you.

      I am creating a test table and inserting some data. He was having an issue with a date field so that’s what I’ll use here.

      Read the rest of this post.

      http://blogs.ittoolbox.com/cgi-bin/mt/mt-tb.cgi?tb_id=8980

    • #3231507

      Mini-tip #1 – Getting rid of spaces after TO_CHAR

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Today, I’m going to give you an Oracle tip to get rid of spaces after you’ve used TO_CHAR.

      If I run this script:


      select to_char(1234.89, '$999,990.00') num_format
      from dual
      /

      select to_char(SYSDATE, 'Day, Month DD, YYYY') date_format
      from dual
      /

      I get:

      NUM_FORMAT  
      ------------
      $1,234.89

      1 row selected.

      DATE_FORMAT
      -----------------------------
      Friday , August 14, 2006

      1 row selected.

      Do you notice the lead spacing in the first statement and the odd spacing in the second?

      Read the rest of this post

    • #3277308

      Mini-Tip #2 – NVL2()

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      NVL2 is a neat little SQL function that I think is underused. It seems to me it could have a better name.

      The
      format is NVL2(expr1, expr2, expr3). What it does is if expr1 is NULL,
      it returns expr3. If expr1 is NOT NULL, it returns expr2.

      An IF statement to do the same would look like:

      IF expr1 IS NULL
      THEN
        expr3
      ELSE
        expr2
      END IF

      Read the rest of this post.

    • #3229618

      Mini-Tip #3: Associative Array – Retrieve and Sort Array Index

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This tip will answer two
      questions I get very frequently. Definitely a FAQ. “How do I retrieve
      and use the VARCHAR2 index of an associative array?” and “How can I
      sort a PL/SQL table?” These questions pertain to PL/SQL functionality;
      not SQL functionality.

      SORT

      I’ll answer the sort
      first and I’ll kind of cheat. When I ask what kind of table they’re
      using the answer is usually either an INDEX BY table with an integer
      index or a nested table. The values of the table are usually a
      key->value pair like this:

      TYPE r_places_i_lived IS RECORD ( 
        unique_key VARCHAR2(10), 
        data_value VARCHAR2(50) ); 

      TYPE a_places_i_lived IS TABLE OF r_places_i_lived 
         INDEX BY BINARY_INTEGER; 

      v_places_i_lived a_places_i_lived;

      NOTE: If the unique_key field is not really unique, my solution will not work. This only works when the key is unique in the PL/SQL table.

      My
      suggestion is to change the structure of the table from BINARY_INTEGER
      to VARCHAR2 and make the unique_key the index variable.

      Read the rest of this post.

    • #3229611

      Mini-Tip #4: Open Source Tools for Oracle

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I’ve written about Open Source and Oracle in the past
      but thought I would remind everyone that open source is a good place to
      go for new tools. Instead of starting from scratch, it sometimes helps
      to see if someone has done something already. My philosophy is to not
      reinvent the wheel if I can avoid it.

      Here are a few open source tools that might help you:

      DBAShell

      DBAShell, by Crispin Bivans, is a project based around Shell functions and scripts designed to make it easy for DBAs to use Databases in a command line environment. Currently supported is
      Oracle with ksh and bash on AIX, Solaris, Linux. The code base itself
      is 3 years old and has been in use in Production environments all of
      that time.

      Features include:

      Read the rest of this post.

    • #3201837

      BADA: Absolutes – Never say never, Never say Always

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Read what BADA means.

      What do I mean by absolutes?
      When someone says you should NEVER do something or when someone says
      you should ALWAYS do something. Some things make sense. If your mama
      said you should never run with a sharp stick, she was probably right.
      Of course if you don’t, you’ll never win the Great Sharp Stick Race!

      So what would be an absolute? How about GOTO? I have said, “Never use GOTO. Never, Ever.” I’m probably right. If a developer handed me a piece of code and it had GOTO in it, that developer better
      have a really good reason. It would take convincing that using GOTO is
      a good idea. But the point is that I would be willing to hear the point
      of view.

      And that is the point of this entry. When you start
      making absolute statements, you start closing your mind. After doing
      something for a while, it’s natural to feel like you are pretty much
      “in the know”.

      You already KNOW how to do that, why would you
      listen to another approach? You know your way works. You’ve probably
      tested several different ways over the years and know which one is
      easier to maintain or which one performs better. You researched it. You
      implemented it. You’re probably right. Probably.

      It’s even
      harder when people start coming to you as “The Expert”. You’ve done
      this before. You have the inside scoop. If you have several years of
      experience, people shouldn’t argue and nitpick every suggestion or
      decision you make. But if someone comes to you, regardless of their
      experience level, you should keep an open mind. I have to admit that I
      sometimes have trouble with this. It does require effort at times.

      Read the rest of this post.

    • #3282466

      Learn Oracle: Datatypes for SQL and PL/SQL, Boolean and Large Objects (LOB)

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Use the article index for more articles on this subject.

      BOOLEAN

      A
      BOOLEAN datatype is a native PL/SQL type that lets you signify a TRUE
      or FALSE condition. A BOOLEAN is NULL until explicitly assigned a
      value. A BOOLEAN is assigned like other variables:

      DECLARE
        v_bool BOOLEAN; 
        v_bool2 BOOLEAN := TRUE; 
        v_bool3 BOOLEAN := FALSE;
      BEGIN 
        v_bool := TRUE;
      END;

      A
      BOOLEAN can also be assigned by a boolean expression. Instead of type
      two statements, you can combine it into a single statement:

      DECLARE 
        v_bool BOOLEAN; 
        v_num NUMBER := 1;
      BEGIN  
        v_bool := (v_num = 1);   

        — Is equivaqlent to 
        IF v_num = 1 
        THEN 
          v_bool := TRUE; 
        ELSE 
          v_bool := FALSE; 
        END IF;
      END;

      You use a BOOLEAN just like you would use a boolean expression.

      Read the rest of this post.

    • #3284912

      Mini-Tip #5: Coalesce()

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      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 big IF statement:

      Read the rest of this post.

    • #3284410

      Mini-tip #6 – Private Variables

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      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 replied like this:

      It’s really very simple.If you have this package:

      Read the rest of this post.

    • #3284409

      BADA: Responsibilities of a Database Architect

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I would like to ask a favor of
      you. I was planning on writing about the differences between a database
      architect, a data architect, an information architect, etc. But as I
      started doing that, I figured I should document what I do and what I
      think a database architect is. So that’s what I have below.

      The
      problem is that I haven’t been an information architect or really any
      other kind of architect. I guess based on particular tasks I could be
      called a data warehouse architect or a BI architect but I think those
      jobs were still a database architect with a concentration on data
      warehousing and BI.

      So here’s the favor. If you have a job, say
      developer or DBA, and your job intersects what I have below, could you
      post a comment and let me know where it intersects? Also, if you think
      I left something out or if I included something I shouldn’t, I’d like
      to hear about that also.

      Lastly, if you are an architect (any
      kind), I would like to hear what your job is. Could you post a job
      description or maybe post where and how your job is different than a
      database architect?

      Read the rest of this post.

    • #3284408

      Mini-tip #7: Quick Access to Oracle Documentation

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Have you ever needed to lookup
      something for Oracle 8.1.7 and couldn’t find the documentation? Ever
      want 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/. The Oracle Documentation site.

      Sure, you can get the documentation at otn.oracle.com. Trust me, I spend a LOT of time at OTN. But sometimes I just want to jump right into the docs.

      Tahiti does that! It has database docs from 8.1.7, 9, 9.2, 10.1, 10XE and 10.2 It also has application server and collaboration suite docs.

      At the very bottom the page is a link that takes you to the OTN page for documentation. You can get 8.0 and 7.3 and other non-terminal release documentation.

      These
      links are great when you’re at a client site or a co-worker’s desk who
      hasn’t already downloaded all of the documentation. You do download it
      right? 😉

      Take care,

      LewisC

    • #3201235

      Software Freedom Day 2006

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Link to the original post.

      As today in the US is Labor
      Day, I thought I would draw your attention to an event that celebrates
      the free labor so many people give to free software. Software Freedom Day 2006 is September 16.

      Here’s a blurb from the site:

      Software
      Freedom Day (SFD) is a worldwide celebration of Free and Open Source
      Software (FOSS). Our goal in this celebration is to educate the
      worldwide public about of the benefits of using high quality FOSS in
      education, in government, at home, and in business
      — in short, everywhere! The non-profit company Software Freedom
      International provides guidance in organizing SFD, but volunteer teams
      around the world organize their own SFD events to impact their own
      communities.

      In my area, the Suncoast Linux User Group (SLUG? ugh) is hosting spots in Tampa and Bradenton. I might head out to the books a million in Bradenton. I don’t really need an excuse to spend a couple of hours there.

      The
      site has more info, forums, some pictures from past years and a listing
      of all the participating teams. Kind of a neat concept. It looks like
      this is the third year but it’s the first I’ve heard of it.

      Take care,

      LewisC

      • #3227497

        Software Freedom Day 2006

        by apotheon ·

        In reply to Software Freedom Day 2006

        Conveniently, the 16th is the date of a Talk Like a Pirate Day party I’ll be attending (yes, I know, TLaPD is the 19th, but that’s a weekday, so the party is the 16th). Everyone’s supposed to be attired in pirate garb. I’ll be there dressed as a Software Pirate.

        The 13th of September was Programmer’s Day this year (Programmer’s Day happens on the 256th day of every year), which prompted someone on the ruby-talk list to remark that software pirates throw exceptions because of too many arrrrrrgs. Hah.

        By the way, while I’m currently a resident of northern Colorado, I moved here from Florida and was a frequent attendee of Tampa and St. Pete meetings of SLUG. A few people there should still remember me (by the name Chad). In particular, Mario, Dylan, and Tina are likely to remember me pretty well, if they’re still attending the meetings.

      • #3227388

        Software Freedom Day 2006

        by lewisc1 ·

        In reply to Software Freedom Day 2006

        I don’t often type LOL, but <i>software pirates throw exceptions because of too many arrrrrrgs</i>  Had me LOLing.  heh

        Thanks for the post.  It was pointed out to me that the Bradenton event was last year.  This year it’s over at MOSE in Tampa.  My mistake.

        Thanks for the post.

        LewisC

    • #3201234

      Oracle Buzz Version 4

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Link to the original post.

      The Oracle Buzz is my take on
      the news, trends and topics that have the bloggers blogging in the
      world of databases. I concentrate mainly on the Oracle world but I’ll
      also cover other topics that interest me.

      I’m back! As always, I
      am looking for feedback. I would like to hear from anyone with an
      opinion, good or bad. I apologize in advance for any sound issues. My
      skills with sound engineering are completely accidental.

      It’s
      been a while. I’ve changed the format somewhat. I also tried to keep
      the time down. This one runs just about 20 minutes. I talk briefly
      about the two links below and then I have an interview with Thomas
      Roach, President of the Suncoast Oracle User Group. I finish it up with
      a guest who sings us a song.

      Subscribe to the Oracle Buzz.

      Download The Oracle Buzz Version 4.

      Version 4 Topics:

      IOUG Releases Latest Oracle Community Survey on Open Source Trends

      The extraordinary life of Oracle CEO Larry Ellison

      Interview with Thomas Roach.

      Guest Singer.

      Thanks,

      LewisC

    • #3201233

      BADA: Performance Goals – A Parable

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      MauDweeb: Database Architects of Dune, Chapter 1

      Any
      road followed precisely to its end leads precisely nowhere. Climb the
      mountain just a little bit to test that it’s a mountain. From the top
      of the mountain, you cannot see the mountain.

      from MuaDweeb: Family Commentaries by the Princess Irulan

      Summoned! Summoned to meet with the local representatives of the Bene Management. To discuss performance! That’s what they said. Who knows what’s behind the unfocused eyes of a Bene Manager.

      What could they want? It must be more than performance., I thought.

      The
      architecture changes were looking good. Tests were written. Tests were
      performed. The tests run by Consultixian C’tair had proven our
      supposition. Those queries that returned in less than a second would
      take longer but anything that took longer than 30 seconds in the
      current system would take less time.

      Our tests proved that! Why this meeting? Didn’t they get the memo?

      Continue reading this post.

    • #3203671

      PL/XML – XML Based Scripting for PL/SQL

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I started working on a
      task for a project and decided that there were some very good
      properties that I could use to help me teach people PL/SQL and XML. I
      expanded a bit on the idea and ended up with a scripting language,
      implemented in XML, that can be passed into a PL/SQL procedure. The
      script can execute stored procedures, it has looping logic, conditional
      (CASE) logic, user defined variables, etc.

      The nice thing about
      it is that it’s very easy to read and modify. The XML structure is also
      very easy to read. It’s really a learning tool but it may have some
      real life uses also. You can modify application
      functionality on the fly just by changing XML. You could even write a
      program that would generate XML for you that would then feed other
      systems. Quite cool!

      Here is a sample script:

      <ROOT> 
      <CMD type="variable">
      <VAR name="$var1$" type="literal" datatype="char">MyValue</VAR>
      </CMD>
      <CMD type="variable">
      <VAR name="$var2$" type="function" datatype="date" format="dd/mm/yyyy hh24:mi:ss">
      <FUNCTION name="sysdate" />
      </VAR>
      </CMD>
      <CMD type="for">
      <FOR from="1" to="5">
      <CMD type="proc">
      <PROC name="dbms_output.put_line">
      <PARAMETER name="a">$var1$ is $var2$</PARAMETER>
      </PROC>
      </CMD>
      </FOR>
      </CMD>
      </ROOT>

      That XML, when run through my script interpreter, will output:


      MyValue is 25/08/2006 15:06:59
      MyValue is 25/08/2006 15:06:59
      MyValue is 25/08/2006 15:06:59
      MyValue is 25/08/2006 15:06:59
      MyValue is 25/08/2006 15:06:59

      The script is run sequentially. So the first thing it does is declare a variable, $var1$ and assign it the value of “MyValue”.

      Read the rest of this post.

    • #3203670

      Word Of The Day

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      I get a word of the day
      emailed to me and they just added an RSS feed. I thought I would pass
      it 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 had
      planned. I think it’s good stuff. Of course, the editors may debate
      that. heh

      Take care,

      LewisC

    • #3203669

      Mini-Tip #8 – Extending XMLType to Access Scalar XPath Functions

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      For some reason, the XMLType XPath implementation does not allow scalar results. According to the documentation:

      EXTRACT
      (XML) is similar to the EXISTSNODE function. It applies a VARCHAR2
      XPath string and returns an XMLType instance containing an XML fragment.

      Extract
      will only return an XMLType. A scalar value would be a function that
      returns a varchar2, number or date. What that means is that in an XPath
      statement, you could use a function like node() and get an XML fragment
      back. But if you try to use name(), which would return the VARCHAR2
      name of the designated element, you get an error.

      I frequently
      need to use name() and local-name(). Count() is another nice function
      at times. I decided to write my own extract function. What I really
      wanted to do was extend XMLType to allow me to add my own overloaded
      Extract. Not gonna happen. XMLType is considered a built-in and not a
      UDT so I can’t extend it.

      More than one way to skin a cat though
      so I created my own type that had an XMLType attribute. I created my
      own Extract that called an XSLT transform. Now it would be a pain to go
      back and forth between a standard XMLType and my home-grown XMLType, so
      I put in skeleton code to call the Oracle XMLType. That way I can use my type everywhere I would normally use an XMLType, except mine can return scalar values.

      The nice thing about this is that you can add any extensions you think you need.

      In
      the code below, I don’t put every method from the XMLType. I do put an
      overloaded Extract() and I show how to add existsNode() and
      getStringVal(). Use that example if you would like to extend it further.

      I also follow my code up with an anonymous block that shows how to use it.

      So here is the type declaration:

      Read the rest of this post,

    • #3203667

      Afraid of being fired?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hate taking abuse from
      management but you do anyway? Keep your opinion to yourself when you
      should be sharing it? Pretend you’re someone your’re not just to fit
      in? 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 fired.

      I had never heard of this blog until today. I got the link in an SD Times Newsletter. This is an eye opener. I don’t think it says anything we don’t already know but it’s nice to hear someone actually say it.

      Sometimes, it’s ok to be fired. If you work for an idiot, you should be proud to be fired. If the company is doing something unethical, blow the whistle and get fired. Then brag about it!

      Of
      course the next job might not be as easy as the writer makes it out to
      be but I have to agree that sometimes it’s either walk out or give an
      opinion when you know it’s going to get you canned.

      Very interesting read! Check it out and let me know what you think. I agree with most of it.

      Take care,

      LewisC

    • #3203618

      Would you like to participate in some on-line Database Training?

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      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 sit
      through (well, hopefully participate and ask questions and such) some
      sessions to help me fine tune it.

      I would like to have several
      people at varying levels of expertise: a few beginners, some
      intermediate, some advanced. I wouldn’t mind having one or two people
      who don’t know anything about databases or SQL at all.

      For
      my test group, I plan to limit it to about 10 people for now. The first
      session will either be beginning databases or beginning SQL.
      I haven’t decided yet. I have some of the training completed and I’m
      working on a couple of more pieces (in my spare time of course).

      The
      first session will only last an hour so I can get a feel for everything
      and how it flows. I’ll ask for feedback on the quality of the
      environment as well as the material itself.

      I also don’t have a
      date or time as of yet but since I hope for participation from anywhere
      in the world, it will probably be done on the weekend.

      Anyone with broadband internet, anywhere in the world, can participate.

      Read the rest of this post.

    • #3203581

      Slowing Down to Write a Book

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Well, I’m going to do
      it. I’m officially writing a book. I’ve got the publisher. I’ve got the
      topic. And now I’ve got a deadline.

      I’ll write more about the
      book over time but in the short term, that means that time I would
      normally spend blogging and answering questions on the oracle-sql-l
      list will be spent writing the book.

      I will still post and I
      will do my best to keep up with comments. It will just have to be less
      frequently than it has been. I’ll miss that. I have really been having
      fun. But I think I will also enjoy writing the book and it’s a huge
      challenge to meet. This is a personal goal that I have had for a very
      long time. I think I’m ready for it. Heck, I better be!

      See an overview of EnterpriseDB: The Definitive Reference.

      Read the rest of this post.

    • #3203577

      Katrina – One Year Later

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      This is a personal entry and has absolutely no Oracle,
      database or other technical content. This is more of a mind dump about
      Katrina and life in general. If you don’t care to read about Katrina or
      my life, please don’t read this. This entry is one of my few rambling
      rants and it’s a pretty long one. Read it at your own risk.

      If you want to read my thoughts as Katrina happened and shortly after you can read my posts: A New House, Pneumonia, TOAD and Katrina, A Personal Update on Katrina, Good News in Spite of Katrina, My Final Update on Katrina.

      It’s the 1 year anniversary of Katrina.
      The 1 year anniversary of Katrina hitting New Orleans and the gulf
      coast. I’m not sure it should be called an anniversary. That makes it
      sound like something that should be celebrated. I don’t know what the
      right word is though.

      As I write this (around noon, Sunday,
      August 27), Ernesto has become a hurricane. It looks to be a lot like
      Katrina. Right now they’re saying it might hit Tampa on Thursday. At
      this point that’s a total guess.

      I have been debating with
      myself whether or not to write something about Katrina. I’m still
      debating as I write this. I know there will be a thousand things
      written in the next week.

      I saw Spike Lee’s HBO documentary. He
      presented one point of view. It was a good documentary in general but
      very biased. His stuff usually is.

      I thought I could write about
      the incompetence of the government response to Katrina. Of incompetent
      local government. Of incompetent state government. Of incompetent federal government. Besides not knowing where to start, I figure there are others who will say all of that better than I can.

      Read the rest of this post.

    • #3203573

      EnterpriseDB Wins Best Database Award at LinuxWorld

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      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 the EnterpriseDB product page
      but a quick run down is that the the automated migration tool can log
      into an Oracle instance and migrate the entire schema to an
      EnterpriseDB database. Kind of cool actually.

      More important I
      think are the other two. The replication server can replicate between
      Oracle and EnterpriseDB. That means data can go back and forth, not
      just one way. I don’t mean multi-master, which it’s not. I mean that
      you can use Oracle as a slave to an EnterpriseDB database or an
      EnterpriseDB slave to an Oracle database. It can also replicate to and
      from PostgreSQL. I’m doing some research right now on how that works
      and I’ll post more in the future.

      The last really significant tool is Developer
      Studio. That’s the EnterpriseDB IDE for developers (sort of a
      multi-database SQL Developer). It can run on multiple platforms and can
      connect to Oracle, PostgreSQL and EnterpriseDB. There is also a source
      level PL/SQL and PL/pgSQL debugger included. I’m also playing with this
      and will have an update in the future.

      If you’re not familiar with EnterpriseDB, I’ve blogged about it in the past. Hard to believe it’s been over a year since I first downloaded it.

      Take care,

      LewisC

    • #3203572

      Photos of an Oracle ACE Award

      by lewisc1 ·

      In reply to An Expert’s Guide To Oracle

      Hi all,

      I mentioned a while back that I was an Oracle ACE. I got the actual Oracle
      ACE award in the mail yesterday. I had never seen one so I took
      pictures. I figured I would post them in case anyone else is curious as
      to what it looks like. You can see it here. It’s pretty neat looking. It’s also very heavy.

      I
      also got a very nice (I mean very nice!) fleece sweater/coat/thing. It
      has the Oracle ACE logo on it. I’ll be wearing it in San Francisco in
      October, I’m sure.

      That’s all for today.

      LewisC

Viewing 176 reply threads