BIT320 Remix — oracle

December 17, 2005

Oracle: Now for the Hard Part

Topics:

Why mergers are difficult and why it's so hard to retain customers in the new deal.

In del.icio.us/pinkfootsie, 12/17/2005 | Original | Archive

November 10, 2005

Exam clarification #2: Question 16, SQL

Topics:

Another one of those possibly contested questions that some of us discussed has to do with question 16. It looks at whether the subquery within the query is same as customer.customer_num <> orders.customer_num. I was a little confused on that one because I didn’t understand the real difference in the cross product. What helped me see that they are really different is running it in Oracle (because your tables are still there). The first command basically eliminates duplicates and filters out all the possibilities. It’s easier to see if you run it than explain it verbally (it’s simply one of those rules). I hope this helps.

In Pink Footsie, 11/10/2005 | Original | Archive | Post to del.icio.us | Technorati

November 4, 2005

Oracle has one less leader

Topics:

Oracle is losing one of it's leaders after only being with the company for a short time

In del.icio.us/mridge, 11/04/2005 | Original | Archive

November 1, 2005

Halloween treat for Oracle: A database worm | Tech News on ZDNet

Topics:

Oracle worms: database thrests

In del.icio.us/mridge, 11/01/2005 | Original | Archive

October 22, 2005

HAVING clause

Topics:

Can “having count” or generally the HAVING clause refer to non-primary key attributes? It refers to groups and i understand the basic differences between it and the where clause that seeks out specific rows. If it can, can someone provide an example? thanks.

In Pink Footsie, 10/22/2005 | Original | Archive | Post to del.icio.us | Technorati

The brain is still smarter than the computer

Topics:

As I was repracticing some commands in oracle I noticed that you can’t uniquely identify several aggregate functions in one command (ie. identify by customer_name, sum(credit_limit), ave(credit_limit) and so on even when you try to split up each command on a unique line with customer_name repeated each time). So it’s best to do these individually by either retyping the command (if short) in oracle or saving it in jEdit and then augmenting it to get new info. By the way can we link somehow to jEdit files or Oracle since they’re not webbased? All the sql assignments are found in the sql book and chapter covered are found here.

In Pink Footsie, 10/22/2005 | Original | Archive | Post to del.icio.us | Technorati

October 21, 2005

In case Oracle tickles your investment funny bone.

Topics:

Oracle creates an empire wrath at the cost of $19billion. Is it strategic?

In del.icio.us/pinkfootsie, 10/21/2005 | Original | Archive

October 17, 2005

SQL Commandments: yes they do exist

Topics:

In del.icio.us/pinkfootsie, 10/17/2005 | Original | Archive

October 16, 2005

To Learn More about ORACLE

Topics:

In addition to the famous database, Oracle supply a range of software to manage, share and protect data and information.

In del.icio.us/supriya, 10/16/2005 | Original | Archive

October 6, 2005

Third Parties Eager To Offer Alternative To Oracle Lifetime Support

Topics:

Service competitors argue that Oracle's real goal is to move owners of PeopleSoft, J.D. Edwards, and Siebel apps to Oracle software.

In del.icio.us/tigerlily23, 10/06/2005 | Original | Archive

September 28, 2005

Video News - Oracle

Topics:

Video article about Oracle's new acquisitions and growth

In del.icio.us/mridge, 09/28/2005 | Original | Archive

September 23, 2005

Internet as a threat to company success

Topics:

It's a blessing and a pain

In del.icio.us/pinkfootsie, 09/23/2005 | Original | Archive

September 22, 2005

Oracle Comments on Security

Topics:

Recap of a press conference with Oracle CEO, Larry Ellison

In del.icio.us/mridge, 09/22/2005 | Original | Archive

September 19, 2005

Oracle

Topics:

One of the first companies to design relational database software

In del.icio.us/mridge, 09/19/2005 | Original | Archive