General discussion
-
CreatorTopic
-
August 16, 2005 at 2:57 pm #2185538
Topic is locked -
CreatorTopic
All Comments
-
AuthorReplies
-
-
August 16, 2005 at 5:01 pm #3050007
On The Lighter Side – What I like about blogging
by lewisc1 · about 17 years, 5 months ago
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…
-
August 16, 2005 at 5:01 pm #3050008
Prototype – Week 1
by lewisc1 · about 17 years, 5 months ago
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…
-
August 16, 2005 at 5:01 pm #3050009
Sorcerer of OO – Part 4
by lewisc1 · about 17 years, 5 months ago
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.
-
August 16, 2005 at 5:01 pm #3050010
Stumble Upon Anger
by lewisc1 · about 17 years, 5 months ago
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….
-
August 16, 2005 at 5:01 pm #3050011
Oracle and Multi-Core Chips
by lewisc1 · about 17 years, 5 months ago
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….
-
August 16, 2005 at 5:01 pm #3050003
Prototype – Week 2
by lewisc1 · about 17 years, 5 months ago
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….
-
August 16, 2005 at 5:01 pm #3050004
Prototype Week 3 – A New Beginning
by lewisc1 · about 17 years, 5 months ago
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…
-
August 16, 2005 at 5:01 pm #3050005
Prototype – Week 3, part deaux
by lewisc1 · about 17 years, 5 months ago
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….
-
August 16, 2005 at 5:01 pm #3050006
Can you beat this?
by lewisc1 · about 17 years, 5 months ago
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….
-
August 16, 2005 at 5:01 pm #3049999
Merge (AKA Upsert) – A Definition in Plain English
by lewisc1 · about 17 years, 5 months ago
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….
-
August 16, 2005 at 5:01 pm #3050000
The Weekend of ORA-01122
by lewisc1 · about 17 years, 5 months ago
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…
-
August 16, 2005 at 5:01 pm #3050001
Prototype – Week 4, The End
by lewisc1 · about 17 years, 5 months ago
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…
-
August 16, 2005 at 5:01 pm #3050002
Oracle and XML In Action – A Real World Example
by lewisc1 · about 17 years, 5 months ago
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…
-
August 16, 2005 at 5:01 pm #3049997
EnterpriseDB General Availability
by lewisc1 · about 17 years, 5 months ago
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….
-
August 16, 2005 at 5:01 pm #3049998
Telecommuting Questions
by lewisc1 · about 17 years, 5 months ago
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…
-
August 18, 2005 at 1:04 pm #3067205
Developing with Open Source and Oracle
by lewisc1 · about 17 years, 5 months ago
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… -
August 21, 2005 at 12:57 pm #3068232
A Busy Week
by lewisc1 · about 17 years, 5 months ago
In reply to An Expert’s Guide To Oracle
Hi all. This is going to be a busy week for me….
-
August 21, 2005 at 12:57 pm #3068233
Learn Oracle – What is Oracle?
by lewisc1 · about 17 years, 5 months ago
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.
-
August 22, 2005 at 9:00 pm #3067818
Oracle 10g vs PostgreSQL 8 vs MySQL 5
by lewisc1 · about 17 years, 5 months ago
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.
-
September 9, 2005 at 12:47 pm #3063722
Oracle 10g vs PostgreSQL 8 vs MySQL 5
by chilango02 · about 17 years, 4 months ago
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.
-
-
August 24, 2005 at 4:57 am #3066573
Introduction to Basic SQL, Part 1
by lewisc1 · about 17 years, 5 months ago
In reply to An Expert’s Guide To Oracle
Discussion about basic SQL commands.
-
August 29, 2005 at 6:19 pm #3046982
A New House, Pneumonia, TOAD and Katrina
by lewisc1 · about 17 years, 5 months ago
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…
-
September 1, 2005 at 2:19 pm #3055650
A Personal Update on Katrina
by lewisc1 · about 17 years, 5 months ago
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….
-
September 2, 2005 at 6:20 am #3055175
Good News in Spite of Katrina
by lewisc1 · about 17 years, 5 months ago
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…
-
September 7, 2005 at 6:20 am #3064638
TOAD User Group Conference/Meeting/Training
by lewisc1 · about 17 years, 5 months ago
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…
-
September 12, 2005 at 8:42 am #3065805
TOAD User Group Conference/Meeting/Training, Part 2
by lewisc1 · about 17 years, 4 months ago
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.
-
September 15, 2005 at 8:45 am #3059824
News
by lewisc1 · about 17 years, 4 months ago
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….
-
September 20, 2005 at 5:12 am #3054389
Why PHP?
by lewisc1 · about 17 years, 4 months ago
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…
-
September 27, 2005 at 10:48 am #3062984
Oracle Collections: A Definition in Plain English Part 1
by lewisc1 · about 17 years, 4 months ago
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…
-
September 29, 2005 at 6:44 am #3060986
TOAD for MySQL Review
by lewisc1 · about 17 years, 4 months ago
In reply to An Expert’s Guide To Oracle
A review of the Toad For MySQL Freeware IDE.
-
October 2, 2005 at 10:42 am #3073629
My Guilty Pleasure
by lewisc1 · about 17 years, 4 months ago
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…
-
October 4, 2005 at 6:47 am #3073212
Oracle Collections: A Definition in Plain English Part 2
by lewisc1 · about 17 years, 4 months ago
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….
-
October 6, 2005 at 9:16 am #3066217
Looking for a job?
by lewisc1 · about 17 years, 4 months ago
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…
-
October 9, 2005 at 9:18 am #3070203
My Final Update on Katrina
by lewisc1 · about 17 years, 3 months ago
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…
-
October 11, 2005 at 5:17 am #3069687
Oracle Collections: A Definition in Plain English Part 3
by lewisc1 · about 17 years, 3 months ago
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….
-
October 13, 2005 at 3:56 pm #3068748
Just the FACTA Please
by lewisc1 · about 17 years, 3 months ago
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…
-
October 13, 2005 at 7:56 pm #3068686
I am doing a Reverse Ask Tom
by lewisc1 · about 17 years, 3 months ago
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…
-
October 17, 2005 at 9:55 am #3058068
I have my answer! I think.
by lewisc1 · about 17 years, 3 months ago
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….
-
October 18, 2005 at 6:01 pm #3071084
EnterpriseDB, InnoDB and Oracle
by lewisc1 · about 17 years, 3 months ago
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…
-
October 20, 2005 at 6:56 am #3044690
My Philosophy of Interviewing
by lewisc1 · about 17 years, 3 months ago
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…
-
October 24, 2005 at 10:43 am #3043723
Correction to my Analytic Answer
by lewisc1 · about 17 years, 3 months ago
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….
-
October 25, 2005 at 10:42 am #3046235
VMWare Player – How sweet it is!
by lewisc1 · about 17 years, 3 months ago
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….
-
October 26, 2005 at 6:39 am #3045667
Oracle 10gR2 RAC on VMWare – A First Look
by lewisc1 · about 17 years, 3 months ago
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…
-
October 29, 2005 at 8:25 am #3115312
Oracle Express – EDB Killer?
by lewisc1 · about 17 years, 3 months ago
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…
-
November 1, 2005 at 6:40 am #3114957
Ralph Kimball – Real-time Data Warehouse Design Challenges
by lewisc1 · about 17 years, 3 months ago
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…
-
November 1, 2005 at 6:37 pm #3116687
EDB and Oracle XE Article
by lewisc1 · about 17 years, 3 months ago
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?….
-
November 3, 2005 at 5:03 pm #3137804
XE: On Railroad Barons and a definition of Crippleware
by lewisc1 · about 17 years, 3 months ago
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….
-
November 8, 2005 at 1:20 pm #3135742
Oracle RAC & Grid Tuning with Solid State Disk, A Review – Part 1
by lewisc1 · about 17 years, 2 months ago
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…
-
November 10, 2005 at 6:42 am #3118355
Oracle RAC & Grid Tuning with Solid State Disk, A Review – Part 2
by lewisc1 · about 17 years, 2 months ago
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….
-
November 14, 2005 at 9:59 am #3119999
Railroad Barons, Follow-up Cubed
by lewisc1 · about 17 years, 2 months ago
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,…
-
November 16, 2005 at 12:54 pm #3131702
XML and OO in Oracle, A Scenario
by lewisc1 · about 17 years, 2 months ago
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…
-
November 17, 2005 at 4:56 pm #3132345
IBM Viper: XML Technology in DB2
by lewisc1 · about 17 years, 2 months ago
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…
-
November 22, 2005 at 5:48 am #3123745
The largest commercial Linux data warehouse in the world runs Oracle Database
by lewisc1 · about 17 years, 2 months ago
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….
-
November 23, 2005 at 1:20 pm #3113992
SAP CEO on Oracle
by lewisc1 · about 17 years, 2 months ago
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….
-
November 28, 2005 at 5:25 am #3123122
Binary XML – Compressing, Encrypting and Encoding Data in Oracle
by lewisc1 · about 17 years, 2 months ago
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…
-
November 29, 2005 at 6:48 pm #3123203
Hardware Upgrades at Home
by lewisc1 · about 17 years, 2 months ago
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…
-
December 3, 2005 at 4:06 pm #3128022
Help me out – take a poll
by lewisc1 · about 17 years, 2 months ago
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…
-
December 4, 2005 at 4:11 pm #3127835
Oracle Buzz, Episode 1 – Podcast
by lewisc1 · about 17 years, 2 months ago
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…
-
December 8, 2005 at 7:39 am #3129841
Accessing Multiple XE Databases from a single machine
by lewisc1 · about 17 years, 1 month ago
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…
-
December 11, 2005 at 5:36 pm #3121053
Answers: Security and Garbage Collection
by lewisc1 · about 17 years, 1 month ago
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….
-
December 14, 2005 at 11:38 am #3121322
XE, XML and WebDAV – Access your XML data in Oracle XE
by lewisc1 · about 17 years, 1 month ago
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…
-
December 16, 2005 at 10:57 am #3125228
Cryptography in the Database
by lewisc1 · about 17 years, 1 month ago
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….
-
December 19, 2005 at 1:55 pm #3197576
Oracle Buzz, Episode 2 – Does it ever get any easier?
by lewisc1 · about 17 years, 1 month ago
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!…
-
December 21, 2005 at 9:34 am #3196656
Database Links: A Definition in Plain English
by lewisc1 · about 17 years, 1 month ago
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…
-
December 22, 2005 at 10:04 am #3198452
Merry Christmas and Happy Holidays
by lewisc1 · about 17 years, 1 month ago
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…
-
December 29, 2005 at 5:50 am #3083586
Back in Town
by lewisc1 · about 17 years, 1 month ago
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…
-
January 2, 2006 at 11:48 am #3081019
Review: Oracle Streams, High Speed Replication and Data Sharing, Part 1
by lewisc1 · about 17 years, 1 month ago
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…
-
January 3, 2006 at 5:45 pm #3094395
2006 Has Arrived! Tell me what you want to see (and hear)!
by lewisc1 · about 17 years, 1 month ago
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…
-
January 5, 2006 at 5:53 am #3095403
Review: Oracle Streams, High Speed Replication and Data Sharing, Part 2
by lewisc1 · about 17 years, 1 month ago
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…
-
January 10, 2006 at 4:50 am #3078098
Growth in 2006: A New Job(s) and My First Presentation, and some Poll Results
by lewisc1 · about 17 years ago
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….
-
January 12, 2006 at 1:45 pm #3080098
Been a Busy Week
by lewisc1 · about 17 years ago
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….
-
January 13, 2006 at 5:44 pm #3077607
Claiming My Blog For Technorati
by lewisc1 · about 17 years ago
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…
-
January 16, 2006 at 5:43 am #3079282
Forget About TNS: Connect To Oracle Using Easy Connect
by lewisc1 · about 17 years ago
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…
-
January 17, 2006 at 8:54 pm #3097101
Oracle Databases: Starting a Career, Part 1
by lewisc1 · about 17 years ago
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…
-
January 19, 2006 at 5:13 pm #3097817
ODTUG: Desktop Conference
by lewisc1 · about 17 years ago
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…
-
January 23, 2006 at 7:57 pm #3258611
Oracle Databases: Starting a Career, Part 2
by lewisc1 · about 17 years ago
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?…
-
January 26, 2006 at 7:55 am #3109783
Oracle Databases: Starting a Career, Part 3
by lewisc1 · about 17 years ago
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….
-
January 29, 2006 at 11:55 am #3109379
Is it TOra, TOAD or a little bit of both?
by lewisc1 · about 17 years ago
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….
-
February 3, 2006 at 6:12 am #3134053
Friday already?
by lewisc1 · about 17 years ago
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….
-
February 3, 2006 at 6:32 pm #3134996
Want a FREE VMWare Server?
by lewisc1 · about 17 years ago
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….
-
February 6, 2006 at 7:06 pm #3093443
How to Ensure a Strong Oracle Password
by lewisc1 · about 16 years, 12 months ago
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….
-
February 7, 2006 at 10:56 pm #3133048
ODTUG Kaleidoscope 2006
by lewisc1 · about 16 years, 12 months ago
In reply to An Expert’s Guide To Oracle
I had an abstract accepted for ODTUG Kaleidoscope 2006 in Washington DC in June….
-
February 8, 2006 at 6:56 pm #3092321
Oracle BI/DW Blog
by lewisc1 · about 16 years, 12 months ago
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,…
-
February 9, 2006 at 6:59 pm #3253922
Oracle Announces Layoffs
by lewisc1 · about 16 years, 12 months ago
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:…
-
February 9, 2006 at 6:59 pm #3253921
Oracle 3rd Quarter Looks Good
by lewisc1 · about 16 years, 12 months ago
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….
-
February 10, 2006 at 7:03 am #3253720
Oracle Buying into Open Source?
by lewisc1 · about 16 years, 12 months ago
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…
-
February 10, 2006 at 6:54 pm #3090950
Flashback 1999: Dell to sell Oracle database appliances
by lewisc1 · about 16 years, 12 months ago
In reply to An Expert’s Guide To Oracle
A database appliance? From Oracle? I must have slept through that announcement!…
-
February 13, 2006 at 8:03 pm #3091626
Oracle Databases: Starting a Career, Part 4
by lewisc1 · about 16 years, 11 months ago
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…
-
February 15, 2006 at 8:57 pm #3080730
Building an XML Utilities Package, Requirements
by lewisc1 · about 16 years, 11 months ago
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…
-
February 23, 2006 at 12:57 am #3101489
Building an XML Utilities Package, Requirements
by vdragos_2000 · about 16 years, 11 months ago
In reply to Building an XML Utilities Package, Requirements
As I want to know more about PL/SQL and XML I am very interested in this.
-
-
February 17, 2006 at 7:23 pm #3252076
Flashback 1987: What will 2007 be like?
by lewisc1 · about 16 years, 11 months ago
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…
-
February 18, 2006 at 4:09 pm #3090648
New Version of Oracle SQL Developer (Raptor) Available
by lewisc1 · about 16 years, 11 months ago
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….
-
February 20, 2006 at 6:45 pm #3101392
ODTUG Desktop Conference
by lewisc1 · about 16 years, 11 months ago
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…
-
February 21, 2006 at 2:34 pm #3103075
My XE Presentation
by lewisc1 · about 16 years, 11 months ago
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…
-
February 22, 2006 at 3:30 pm #3101711
Oracle 10g Security and Audit Presentation
by lewisc1 · about 16 years, 11 months ago
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…
-
February 23, 2006 at 11:32 am #3101067
Oracle Supports MS-SQL Server
by lewisc1 · about 16 years, 11 months ago
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….
-
February 24, 2006 at 10:01 pm #3273707
Taking a vacation
by lewisc1 · about 16 years, 11 months ago
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….
-
March 5, 2006 at 11:17 am #3085584
Back From Vacation
by lewisc1 · about 16 years, 11 months ago
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…
-
March 5, 2006 at 3:16 pm #3085516
Is an open source release “news”?
by lewisc1 · about 16 years, 11 months ago
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….
-
March 6, 2006 at 7:04 pm #3086110
Oracle XE: Read my article at OTN
by lewisc1 · about 16 years, 11 months ago
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!…
-
March 10, 2006 at 11:24 am #3266764
Building an XML Utilities Package, XML Debugger Part 1
by lewisc1 · about 16 years, 11 months ago
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…
-
March 10, 2006 at 9:16 pm #3267565
Oracle XE: Read my article at OTN, Part Deaux
by lewisc1 · about 16 years, 11 months ago
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…
-
April 26, 2006 at 5:02 pm #3149926
BEPELL, BEOPLE or BIPPLE? The Oracle Architect Forum
by lewisc1 · about 16 years, 9 months ago
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
-
April 27, 2006 at 12:39 pm #3150942
Oracle Data Vault
by lewisc1 · about 16 years, 9 months ago
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.
-
May 7, 2006 at 9:52 am #3161689
Get the XML out of your database, via HTTP
by lewisc1 · about 16 years, 9 months ago
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.
-
May 24, 2006 at 5:36 am #3146113
Dynamic Paging, Calling Oracle XML From Java
by lewisc1 · about 16 years, 8 months ago
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.
-
May 30, 2006 at 8:25 am #3156678
What is the difference between Oracle, SQL and PL/SQL?
by lewisc1 · about 16 years, 8 months ago
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
-
June 2, 2006 at 3:09 pm #3166284
And you thought your commute was bad!?!?!?
by lewisc1 · about 16 years, 8 months ago
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.”
-
June 2, 2006 at 3:10 pm #3166282
BEPELL, BEOPLE or BIPPLE? The Oracle Architect Forum
by lewisc1 · about 16 years, 8 months ago
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.
-
June 2, 2006 at 3:10 pm #3166281
No ODTUG Conference For Me This Year
by lewisc1 · about 16 years, 8 months ago
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.
-
June 2, 2006 at 3:11 pm #3166280
TBTF: The Man From NASA
by lewisc1 · about 16 years, 8 months ago
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.
-
June 2, 2006 at 3:11 pm #3166278
Need Input: Oracle SCM and .Net SOA
by lewisc1 · about 16 years, 8 months ago
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.
-
June 2, 2006 at 3:12 pm #3166277
Yahoo Answers! WTF?
by lewisc1 · about 16 years, 8 months ago
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
-
June 2, 2006 at 3:12 pm #3166276
Dynamic Paging of Data for Java and .Net
by lewisc1 · about 16 years, 8 months ago
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
-
June 2, 2006 at 3:12 pm #3166275
Dynamic Paging of Data, Retrieve XML instead of REF CURSOR
by lewisc1 · about 16 years, 8 months ago
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.
-
June 2, 2006 at 3:12 pm #3166274
Dynamic Paging, Calling XML From Java
by lewisc1 · about 16 years, 8 months ago
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.
-
June 2, 2006 at 3:12 pm #3166273
Presenting XML and SQL Analytics
by lewisc1 · about 16 years, 8 months ago
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.
-
June 2, 2006 at 3:12 pm #3166272
Oracle is the Database Top Dog!
by lewisc1 · about 16 years, 8 months ago
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
-
June 2, 2006 at 3:12 pm #3166271
Would you like to Podcast?
by lewisc1 · about 16 years, 8 months ago
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
-
June 5, 2006 at 12:11 pm #3164991
Not Oracle Related – I hate lovebugs!
by lewisc1 · about 16 years, 8 months ago
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
-
June 6, 2006 at 9:06 pm #3164341
Introduction to Basic SQL, Part 2 – Joins
by lewisc1 · about 16 years, 8 months ago
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;
-
June 8, 2006 at 9:14 am #3143510
Introduction to Basic SQL, Part 3 – Complex Joins and Sub-queries
by lewisc1 · about 16 years, 8 months ago
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.
-
June 8, 2006 at 9:14 am #3143509
Oracle and Open Source DBs
by lewisc1 · about 16 years, 8 months ago
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
-
June 9, 2006 at 1:15 pm #3144194
Ray Lane on Web 2.0
by lewisc1 · about 16 years, 8 months ago
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.
-
June 11, 2006 at 5:39 pm #3144997
Celebrate Moon Day, July 20 or 21
by lewisc1 · about 16 years, 7 months ago
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
-
June 12, 2006 at 9:15 pm #3145466
Oracle Buzz Episode 3, VLDB and the Oracle Partitioning Option
by lewisc1 · about 16 years, 7 months ago
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
-
June 13, 2006 at 1:37 pm #3164780
Generate XML Schemas for your Data
by lewisc1 · about 16 years, 7 months ago
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
-
June 14, 2006 at 1:18 pm #3155649
DB2 Security Glitch Makes IBM Whine
by lewisc1 · about 16 years, 7 months ago
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.
-
June 15, 2006 at 5:17 pm #3154932
Oracle: The biggest Linux vendor you
by lewisc1 · about 16 years, 7 months ago
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:
-
June 16, 2006 at 2:16 pm #3268563
Oracle: The biggest Linux vendor you
by lewisc1 · about 16 years, 7 months ago
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:
-
June 16, 2006 at 2:16 pm #3268561
Bill Gates Leaving Microsoft
by lewisc1 · about 16 years, 7 months ago
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.
-
June 16, 2006 at 2:16 pm #3268562
Sweet, sweet numbers for Oracle
by lewisc1 · about 16 years, 7 months ago
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
-
June 17, 2006 at 7:22 am #3145951
Oracle: The biggest Linux vendor you
by lewisc1 · about 16 years, 7 months ago
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:
-
June 19, 2006 at 11:31 am #3142010
Oracle: The biggest Linux vendor you
by lewisc1 · about 16 years, 7 months ago
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:
-
June 19, 2006 at 7:27 pm #3141814
Oracle Magazine Profile
by lewisc1 · about 16 years, 7 months ago
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
-
June 20, 2006 at 12:12 pm #3269503
H-1B Pay Drags Down Salaries
by lewisc1 · about 16 years, 7 months ago
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.
-
June 20, 2006 at 7:24 pm #3143948
Oracle: The biggest Linux vendor you’ve never heard of
by lewisc1 · about 16 years, 7 months ago
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:
-
June 21, 2006 at 11:25 am #3142245
ITtoolbox CEO Dan Morrison Talks About Web 2.0
by lewisc1 · about 16 years, 7 months ago
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
-
June 21, 2006 at 3:25 pm #3142116
Oracle XE Presentation at the SOUG
by lewisc1 · about 16 years, 7 months ago
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
-
June 23, 2006 at 11:52 am #3270518
Interesting SQL Question, Pivot 1 column into multiple rows
by lewisc1 · about 16 years, 7 months ago
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 rowsMessage:
How do I parse this one field in a table into multiple rows:
Field 1
1,2,3,4,56
-
June 26, 2006 at 9:01 pm #3112403
SQL Question: Pivots, Analytics and the judicious use of Row_Number()
by lewisc1 · about 16 years, 7 months ago
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.
-
June 28, 2006 at 7:45 pm #3111745
The Joys of Public Presentations
by lewisc1 · about 16 years, 7 months ago
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
-
June 29, 2006 at 3:49 pm #3113136
Oracle Content Database and Oracle Records
by lewisc1 · about 16 years, 7 months ago
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.
-
July 1, 2006 at 9:02 am #3111312
Independence Day
by lewisc1 · about 16 years, 7 months ago
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
-
July 3, 2006 at 12:36 pm #3113473
Interview with Larry Ellison
by lewisc1 · about 16 years, 7 months ago
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
-
July 4, 2006 at 9:36 am #3168646
Oracle: what you need to know
by lewisc1 · about 16 years, 7 months ago
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
-
July 6, 2006 at 12:54 pm #3166846
SQL Question: When the Pivot data contains a Key Column (and character data at that!)
by lewisc1 · about 16 years, 7 months ago
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');
-
July 12, 2006 at 6:11 am #3209773
Learn PL/SQL: Structure and Comments
by lewisc1 · about 16 years, 6 months ago
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? -
July 12, 2006 at 6:13 am #3209771
Learn Oracle: Article Index
by lewisc1 · about 16 years, 6 months ago
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. -
July 12, 2006 at 6:16 am #3209769
I am an Oracle ACE!
by lewisc1 · about 16 years, 6 months ago
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.
-
July 12, 2006 at 10:13 am #3211022
Oracle SQL Developer: New Article on OTN
by lewisc1 · about 16 years, 6 months ago
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
-
July 30, 2006 at 1:09 pm #3208476
Learn PL/SQL: Declaring Variables, Named vs Anonymous Blocks
by lewisc1 · about 16 years, 6 months ago
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. -
July 30, 2006 at 1:12 pm #3208475
Learn Oracle: Datatypes for SQL and PL/SQL, Numbers
by lewisc1 · about 16 years, 6 months ago
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.-
October 16, 2007 at 11:17 pm #2470263
Learn Oracle: Datatypes for SQL and PL/SQL, Numbers
by peeusht · about 15 years, 3 months ago
In reply to Learn Oracle: Datatypes for SQL and PL/SQL, Numbers
Nice information .The binary_double datatype seems to be quite useful .
-
-
July 30, 2006 at 1:14 pm #3208474
Learn Oracle: SQL and PL/SQL Datatypes, Strings
by lewisc1 · about 16 years, 6 months ago
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. -
August 4, 2006 at 11:14 am #3215156
Looking for a co-worker.
by lewisc1 · about 16 years, 6 months ago
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
-
August 10, 2006 at 2:12 am #3276961
Looking for a co-worker.
by welshbilly · about 16 years, 5 months ago
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.
🙂
-
August 10, 2006 at 4:15 am #3276954
Looking for a co-worker.
by lewisc1 · about 16 years, 5 months ago
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
-
-
August 7, 2006 at 6:21 pm #3213268
Learn Oracle: Datatypes for SQL and PL/SQL, Dates
by lewisc1 · about 16 years, 6 months ago
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. -
August 10, 2006 at 6:38 am #3276879
Using a PL/SQL Table in SQL
by lewisc1 · about 16 years, 5 months ago
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.
-
August 14, 2006 at 9:36 am #3231507
Mini-tip #1 – Getting rid of spaces after TO_CHAR
by lewisc1 · about 16 years, 5 months ago
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?
-
August 17, 2006 at 5:28 am #3277308
Mini-Tip #2 – NVL2()
by lewisc1 · about 16 years, 5 months ago
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. -
August 19, 2006 at 9:39 am #3229618
Mini-Tip #3: Associative Array – Retrieve and Sort Array Index
by lewisc1 · about 16 years, 5 months ago
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. -
August 19, 2006 at 10:34 am #3229611
Mini-Tip #4: Open Source Tools for Oracle
by lewisc1 · about 16 years, 5 months ago
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:
-
August 22, 2006 at 7:31 am #3201837
BADA: Absolutes – Never say never, Never say Always
by lewisc1 · about 16 years, 5 months ago
In reply to An Expert’s Guide To Oracle
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. -
August 29, 2006 at 7:07 am #3282466
Learn Oracle: Datatypes for SQL and PL/SQL, Boolean and Large Objects (LOB)
by lewisc1 · about 16 years, 5 months ago
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. -
August 30, 2006 at 11:10 am #3284912
Mini-Tip #5: Coalesce()
by lewisc1 · about 16 years, 5 months ago
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:
-
September 3, 2006 at 9:30 am #3284410
Mini-tip #6 – Private Variables
by lewisc1 · about 16 years, 5 months ago
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:
-
September 3, 2006 at 9:33 am #3284409
BADA: Responsibilities of a Database Architect
by lewisc1 · about 16 years, 5 months ago
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? -
September 3, 2006 at 9:34 am #3284408
Mini-tip #7: Quick Access to Oracle Documentation
by lewisc1 · about 16 years, 5 months ago
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
-
September 8, 2006 at 9:46 am #3201235
Software Freedom Day 2006
by lewisc1 · about 16 years, 5 months ago
In reply to An Expert’s Guide To Oracle
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
-
September 14, 2006 at 2:58 am #3227497
Software Freedom Day 2006
by apotheon · about 16 years, 4 months ago
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.
-
September 14, 2006 at 6:56 am #3227388
Software Freedom Day 2006
by lewisc1 · about 16 years, 4 months ago
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
-
-
September 8, 2006 at 9:47 am #3201234
Oracle Buzz Version 4
by lewisc1 · about 16 years, 5 months ago
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! 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.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
-
September 8, 2006 at 9:50 am #3201233
BADA: Performance Goals – A Parable
by lewisc1 · about 16 years, 5 months ago
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 IrulanSummoned! 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?
-
September 22, 2006 at 6:59 am #3203671
PL/XML – XML Based Scripting for PL/SQL
by lewisc1 · about 16 years, 4 months ago
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:59The script is run sequentially. So the first thing it does is declare a variable, $var1$ and assign it the value of “MyValue”.
-
September 22, 2006 at 7:01 am #3203670
Word Of The Day
by lewisc1 · about 16 years, 4 months ago
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. hehTake care,
LewisC
-
September 22, 2006 at 7:02 am #3203669
Mini-Tip #8 – Extending XMLType to Access Scalar XPath Functions
by lewisc1 · about 16 years, 4 months ago
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:
-
September 22, 2006 at 7:06 am #3203667
Afraid of being fired?
by lewisc1 · about 16 years, 4 months ago
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
-
September 22, 2006 at 8:43 am #3203618
Would you like to participate in some on-line Database Training?
by lewisc1 · about 16 years, 4 months ago
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.
-
September 27, 2006 at 1:43 am #3139666
Would you like to participate in some on-line Database Training?
by jahernandez · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Hi! I would like to participate. I’ll take the class from home, as it will probably be on a Sunday here in our part of the world (the Philippines). I can be contacted at the following email addresses: jahernandez at mbtc-tech.com and juleshernandez at yahoo.com.
-
September 27, 2006 at 3:34 am #3139656
Would you like to participate in some on-line Database Training?
by apschorr · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
I would love to help you out. I reside in Michigan. My name is Ann Schorr and I have been a DBA for over 5 years. My email is schorrap@yahoo.com. Just let me know what day and time so I can plan for it. Have a great day.
-
September 27, 2006 at 5:30 am #3139638
Would you like to participate in some on-line Database Training?
by sschwam · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
I am interested in this training program, I have a little sql, and interface with oracle, and access databases. I will do this from home. Please email me at sschwam@gmail.com…
Thanks.
-
September 27, 2006 at 6:11 am #3202984
Would you like to participate in some on-line Database Training?
by rjdanner · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Insert comment text here
I would also like to participate. I am a total beginner at sql and databases. My name is Jae and I live in Indiana. My email is rjdanner@comcast.net.
-
September 27, 2006 at 8:14 am #3202950
Would you like to participate in some on-line Database Training?
by cgmserrano · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
hi! i’m interested in participating. i’m an analyst and would like to know more about databases. i’m on the other side of the planet, i hope i’ll be able to fit in the schedule. thanks!
-
September 27, 2006 at 8:44 am #3202937
Would you like to participate in some on-line Database Training?
by cmotap · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
I would like to participate in your training program. My name is Carlos Mota and I from Monterrey M?xico. I have 9 years working with oracle. Please, e-mail me at cmota@itesm.mx
-
September 27, 2006 at 11:46 am #3202870
Would you like to participate in some on-line Database Training?
by saadkhan2007 · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Hi.
My name is Saad and I want to participate in the online training as well. I live in NY,USA and would like to take this training on weekends. I already have DBA experience and exposure.
Please let me know how to participate in the program. My email address is m_saadkhan@yahoo.com
-
September 27, 2006 at 1:13 pm #3202847
Would you like to participate in some on-line Database Training?
by bankerit · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Hi
I am interested in participating in the database training. I live in Nigeria, and have no experience of Oracle or MS-SQL. I do know some SQL – learnt mainly be tweaking wizard generated Access queries.
Please let me know how to go ahead. my address – raviramanathan@hotmail.comravi ramanathan
-
September 27, 2006 at 5:30 pm #3202791
Would you like to participate in some on-line Database Training?
by jaytuke · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Count me in. I am a student of Oracle and have completed requisite courses to take certification exams.
JayTuke@hotmail.com -
September 27, 2006 at 5:42 pm #3202790
Would you like to participate in some on-line Database Training?
by cazz101 · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Hi, my name is Caroline and i am a tekkie at a non profit company, I would like to participate in the training.
I fix the access database for about 90 end-users with no formal training and it is a real pain to try and figure out what they do to that database on a daily basis. so, yeah, keep me in mind
I am in Ozz, my e-mail address is cazz101@bigpond.net.au.
See ya
-
September 28, 2006 at 7:55 am #3140648
Would you like to participate in some on-line Database Training?
by maevinn · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Don’t kow if you’re still looking, but I would be interested in participating, but am limited on time, so that will determine if I can or not.
-
September 28, 2006 at 11:07 am #3140538
Would you like to participate in some on-line Database Training?
by vsdevan · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
I would like to participate. My name is Sahadevan and I’m a DBA. I live in Middle East and so will be able to take part on Friday or Saturdaya if that fits in your schedule. My e-mail address is vsdevan@hotmail.com
-
September 28, 2006 at 7:16 pm #3140394
Would you like to participate in some on-line Database Training?
by cherubcalf · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
I’m in, if you’re still looking for recruits. Live in Fla. Primarily a mathematician; hate code; so good candidate for feedback. Orlando Oracle wouldn’t let me past the front door to discuss my algorithm; so maybe if I learn the lingo, I’ll have a better chance. Be gone the first week of Oct.; can work your schedule after that.
Thanks, Ron M.
-
September 29, 2006 at 7:24 am #3138573
Would you like to participate in some on-line Database Training?
by pc21geek · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
I would be willing to participate. Some mysql and access experience. from home, i have broadband internet.
Kevin
-
October 3, 2006 at 5:12 am #3141239
Would you like to participate in some on-line Database Training?
by waynehess · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
I’d like to participate in your conference.
I have experience in Access and SQL. I live in Kansas, and I can be reached at the following email: waynehess@usd475.org
-
October 3, 2006 at 3:46 pm #3138855
Would you like to participate in some on-line Database Training?
by ericev · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Hi,
I would like to participate in your on-line training.
I am currently learning the basics of Oracle and would defeintly benefit from your expertise. -
October 3, 2006 at 4:02 pm #3138850
Would you like to participate in some on-line Database Training?
by tgaudet · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Yup! I would definitely like to sit in and participate. I have quite a few years of data mining experience, intermediate in coding SQL, expert with a GUI……
I’ll also give you the Canuck’s perspective….
Terry
-
October 3, 2006 at 5:22 pm #3138836
Would you like to participate in some on-line Database Training?
by dmjohnson · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
I would be interested in the class. I’ve never used Oracle, but I’ve got a few years of SQL Server under my belt.
-
October 3, 2006 at 8:36 pm #3138806
Would you like to participate in some on-line Database Training?
by atul_shinkar · about 16 years, 4 months ago
In reply to Would you like to participate in some on-line Database Training?
Hello ALL 🙂
I would also like to participate in the training program. I have a little knowledge of sql and databases.. My name is Atul Shinkar and I live in India. My email is atul_shinkar@rediffmail.com.
Thanks to all for initiating this program.
Regards,
Atul Shinkar
-
-
September 22, 2006 at 10:26 am #3203581
Slowing Down to Write a Book
by lewisc1 · about 16 years, 4 months ago
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.
-
September 22, 2006 at 10:30 am #3203577
Katrina – One Year Later
by lewisc1 · about 16 years, 4 months ago
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. -
September 22, 2006 at 10:36 am #3203573
EnterpriseDB Wins Best Database Award at LinuxWorld
by lewisc1 · about 16 years, 4 months ago
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
-
September 22, 2006 at 10:38 am #3203572
Photos of an Oracle ACE Award
by lewisc1 · about 16 years, 4 months ago
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
-
-
AuthorReplies