Oracle MySQL database
Top Stories
-
Feature
16 Aug 2018
Open source RDBMS uses spurred by lower costs, cloud options
Open source technologies have become more capable alternatives to mainstream relational databases for cost-conscious users -- and the cloud makes them more accessible. Continue Reading
-
Feature
02 Aug 2018
Open source DBMS software gains foothold in enterprise IT
Open source databases are increasingly making their way into corporate IT environments, says Gartner analyst Merv Adrian in a Q&A. But some care is required. Continue Reading
-
News
04 Oct 2012
Oracle goes social
Oracle’s reasons for buying various cloud and social media companies seem to be coming into focus. Continue Reading
-
News
03 Oct 2012
Oracle Fusion Applications breakdown
Oracle CEO Larry Ellison showed some interesting Fusion Applications pie charts during his second keynote at Oracle OpenWorld 2012. Continue Reading
-
Answer
03 Aug 2012
Calling stored procedures inside user-defined functions in Oracle Database
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database. Continue Reading
-
News
19 Jul 2012
A rare feel good week in the world of Oracle
Oracle’s having a busy week. Instead of their usual legal fracases, they seem to actually be getting some work done. Continue Reading
-
Feature
17 Jul 2012
Excerpt: The key concepts of Oracle WebLogic server
The Oracle Weblogic server is great, but it's important to understand a few key concepts. Read this excerpt from Oracle WebLogic Server 11g Handbook by Sam R. Alapati to learn why. Continue Reading
-
Answer
05 Jul 2012
Solve a PL-SQL error that creates dynamic tables
Oracle PL-SQL expert Daniel Clamage answers a question about a problem with doing an “insert” in PL-SQL to create a table dynamically. Continue Reading
-
News
05 Jul 2012
Oracle just can’t catch an IP break
Another day, another court ruling not in Oracle’s favor when it comes to intellectual property laws. Continue Reading
-
News
21 Jun 2012
HP vs Oracle: the drama continues
Hewlett-Packard was scared. Terrified. Trembling. And why shouldn’t they have been, after seeing what happened to Sun only months before? Continue Reading
-
News
07 Jun 2012
New version of Oracle database on the way?
Ready for a new version of the Oracle Database? You might not have to wait too long. Continue Reading
-
News
31 May 2012
HP vs Oracle continues- No one wants to be exhibit A
Have you ever had the experience of going through someone’s email or chat logs and seeing something you later wished you hadn’t? There’s a legal version of this. It’s called electronic discovery (or ediscovery). Continue Reading
-
News
16 May 2012
Oracle in the cloud- better late than never
Larry Ellison seems to have been wrong about cloud computing, having made it the subject of a now fairly well-known rant. Oracle dragged their feet on cloud for a while, but now that's changing. Continue Reading
-
News
10 May 2012
Need access to real-time, business critical info? Oracle wants to be your man
Many have remarked in recent years that business intelligence is becoming a commodity. Oracle, long having had the reputation of database of the 1%, is now attempting to position itself as bringer of BI to the masses. Continue Reading
-
News
03 May 2012
Oracle and SAP- friends again?
Are Oracle and SAP friends again? Well, maybe not friends (in fact, this article goes so far as to suggest they kind of still hate each other), but they seem to have accepted that end-users are going to want to integrate their products from time to time, and are willing to work together when that needs to happen. Continue Reading
-
News
20 Apr 2012
This week in Oracle vs Google in a nutshell
This week the software Trial of the Century took off in a San Francisco courtroom as Oracle and Google duke out their intellectual property lawsuit. If you’ve been too busy to follow the case, here’s a cheat sheet. Continue Reading
-
Answer
18 Apr 2012
Hyperion upgrade creates issues with migrating Essbase data
One reader asks how to properly migrate Essbase data when upgrading from Hyperion 9.3.1 to 9.3.3 and then 11.1.2.1. Continue Reading
-
News
13 Apr 2012
Oracle gets vertical—Industries, that is
Oracle has entered into agreement to purchase cloud-based clinical trial firm ClearTrial. What does this mean for the big picture? Continue Reading
-
News
05 Apr 2012
Oracle vs. HP- Or, how the corporate world is really a lot like grade school
In the case of the ill-fated Itanium chip, multiple companies, including HP and Intel, got a lesson in failure. The now famous debacle has been coined “the joke of the chip industry” by tech blogger Ashlee Vance . Continue Reading
-
News
23 Mar 2012
Larry Ellison’s new toy in New Zealand
Most people have hobbies of some sort. Some people build model cars. Others enjoy knitting. But Larry Ellison owns a very expensive milling machine in New Zealand and uses it to build ships. Continue Reading
-
News
15 Mar 2012
Note to Oracle: Nobody likes a nuisance
By now, you probably know that Oracle is in the middle of a multi-billion dollar lawsuit against Google for patent infringement regarding Google’s use of patents Oracle feels are related to the Java programing language. Continue Reading
-
News
08 Mar 2012
Larry Ellison demoted to 7th wealthiest person on earth
Bad news for Larry Ellison- He’s no longer among the top five richest people on earth, and will have to settle for the slightly less luxurious position of number seven, according to Bloomberg’s most recent list of billionaires. Continue Reading
-
Answer
28 Feb 2012
Partitioning and Oracle licenses
One reader asks expert Scott Rosenberg from Miro Consulting about partitioning Oracle software licenses. Continue Reading
-
News
27 Feb 2012
Larry Ellison — Philanthropist?
When you think of philanthropic CEOs, who crosses your mind? Bill and Melinda Gates? Sir Richard Branson? Mark Zuckerberg, perhaps? Larry Ellison usually doesn’t even register. Continue Reading
-
Answer
08 Feb 2012
Making Monday the start of the week in Oracle SQL
One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week. Continue Reading
-
Answer
07 Jul 2011
Copy Oracle Database but with no data
One reader asks how he can make a copy of his Oracle Database but not have any data in it, for test purposes. Continue Reading
-
Video
20 Apr 2011
Oracle Fusion Apps customer goes live
Oracle VP Steve Miranda describes how Principal Financial Group became one of the first users to go live in production with Fusion Applications. Continue Reading
-
Video
16 Mar 2011
Oracle Fusion Middleware VP breaks down Oracle Exalogic
Oracle Fusion Middleware VP of development Adam Messinger details what he thinks are the benefits of Oracle Exalogic, the company's integrated WebLogic and Java server appliance. Continue Reading
-
Feature
14 Mar 2011
Starting an Oracle virtualization project
Contributor Frank Ohlhorst gives tips on how to start a server virtualization project in an Oracle shop. Continue Reading
-
Tutorial
20 Dec 2010
Oracle upgrades: Tips and trends
If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades. Continue Reading
-
Feature
13 Dec 2010
Oracle Exalogic: Is Oracle's cloud-in-a-box really cloud computing?
Oracle’s new Exalogic Elastic Cloud is the company’s announced foray into cloud computing. But does Oracle Exalogicfit the traditional model of cloud computing, and does that matter? Continue Reading
-
News
03 Dec 2010
Oracle pushes Sparc Supercluster and Sparc Exalogic server hardware
Oracle rolled out a refresh of its Sparc-based servers, including a new Sparc-based Exalogic Elastic Cloud middleware server. Continue Reading
-
Feature
18 Nov 2010
Oracle Professionals’ Challenges and Priorities Survey 2010
Almost 450 Oracle professionals answered survey questions from SearchOracle.com this year on topics such as budget, database and application challenges, virtualization and support. Here are the results. Continue Reading
-
News
11 Nov 2010
Oracle will now support Oracle RAC on VMware
Oracle RAC on VMware will now be supported by Oracle, a change in support policy that could lead to more customers exploring the RAC-on-VMware platform. Continue Reading
-
News
09 Nov 2010
Oracle Enterprise Manager improves, still far from Big Four
Oracle Enterprise Manager Ops Center 11g now includes management tools for Sun products, but one analyst says Enterprise Manager is too Oracle-centric to be a big player in systems management. Continue Reading
-
News
04 Nov 2010
Oracle E-Business Suite users face EBS R12 upgrade challenges
An upgrade to E-Business Suite R12 can offer many benefits, but EBS users have also reported a number of business and technical challenges during and after their EBS R12 upgrade process. Continue Reading
-
News
28 Oct 2010
Users consider Oracle EBS R12 upgrade as Premier Support for 11i ends
Premier Support for Oracle E-Business Suite11i ends Nov. 30, and end users must decide whether to move to Extended Support, which brings fewer features and higher maintenance fees, or do an EBS R12 upgrade. Continue Reading
-
News
19 Oct 2010
Oracle cloud computing application solutions get second look from some
While Oracle cloud computing may not be for everyone, interest is slowly growing as Oracle and other vendors offer a variety of solutions for safely deploying applications in the cloud. Continue Reading
-
News
07 Oct 2010
Oracle Beehive collaboration software to be rolled into WebCenter
Oracle Beehive made a big splash at OpenWorld 2008, where company officials billed it as integrated collaboration software meant to compete with Exchange, Lotus and SharePoint. But the buzz is done buzzing. Continue Reading
-
News
05 Oct 2010
Oracle vs. Google lawsuit
Oracle sued Google on Aug. 12, 2010, claiming that Google was violating Oracle's intellectual property related to Java with its Android operating system used on mobile phones. Continue Reading
-
News
28 Sep 2010
R.L. Polk sees 10x query improvement with Oracle Exadata V2
R.L. Polk, an automotive statistics company, says it saw 10x improvement on its query performance since installing Oracle Exadata V2, largely due to the box’s hybrid columnar compression and flash cache features. Continue Reading
-
News
24 Sep 2010
Quest offers new Toad tools for Oracle Java development, cloud DBs
Quest Software has released beta versions of two new Toad tools for Oracle users that focus on Java development and NoSQL cloud databases. Continue Reading
-
Video
24 Sep 2010
Mark Smith on Oracle Fusion Application strategy
Oracle showed off its long awaited Fusion Applications at OpenWorld this year. Mark Smith, CEO of Ventana Research, offers advice on the highlights of Fusion Apps, the upgrade path and how business needs to remain engaged. Continue Reading
-
News
23 Sep 2010
Oracle demos Fusion Applications; Ellison talks up integrated systems
Oracle executives demoed Fusion Applications at the end of the OpenWorld 2010 keynote on Wednesday. Meanwhile, CEO Larry Ellison dissed Salesforce.com some more and talked up Exalogic and Exadata. Continue Reading
-
News
20 Sep 2010
Oracle Openworld 2010 Special Report
This special report is your guide to Oracle OpenWorld 2010, the biggest annual conference for users of Oracle database and applications technology worldwide. Continue Reading
-
News
20 Sep 2010
Oracle Fusion Applications video demo
Oracle rolled out its long-awaited Fusion Applications suite at OpenWorld this year. SearchOracle.com got an exclusive look at the software. Watch the video to see it for yourself. Continue Reading
-
News
20 Sep 2010
Oracle Exalogic is the company's "cloud in a box"
Larry Ellison opened OpenWorld 2010 offering his definition of cloud, taking shots at Salesforce.com and releasing a complement to Exadata, the Oracle Exalogic "cloud in a box." Continue Reading
-
News
26 Aug 2010
Oracle MySQL users have little loyalty to Oracle
Six months after the Oracle-Sun deal, end users say it’s too early to say where Oracle MySQL is going. But one thing is certain: If it goes nowhere, they’ll quickly go elsewhere. Continue Reading
-
News
19 Aug 2010
A nutritional supplement company does Oracle E-Business Suite upgrade
USANA Health Sciences tackled three key business issues when it performed an Oracle E-Business Suite upgrade: third-party integration, employee turnover and new software modules. Continue Reading
-
News
17 Aug 2010
Leaked memo suggests death of Oracle OpenSolaris, some say
A recently leaked internal Oracle memo has some OpenSolaris fans saying it means the death of OpenSolaris, but not all Solaris users are feeling so glum. Continue Reading
-
News
09 Aug 2010
Oracle RAC on VMware gets no support from Oracle
Oracle won’t support Oracle RAC on VMware at all, largely for political and outdated technical reasons, according to end users, consultants and vendors. Continue Reading
-
News
09 Aug 2010
Why run Oracle RAC on VMware?
With Oracle RAC and VMware both growing in popularity, end users might be tempted to combine the two. So what are the pros and cons of running Oracle RAC on VMware? Continue Reading
-
News
27 Jul 2010
How big is Oracle’s acquisition budget, really?
Oracle president Charles Phillips said the company could spend $70 billion on acquisitions in the next five years. The next day, a company spokeswoman said that wasn’t the case. So what’s going on? Continue Reading
-
News
08 Jul 2010
Oracle Exadata Version 2 interest booms a year after release
While the first version of Oracle Exadata generated only a handful of customers, Version 2 has lured customers into spending millions to buy it. But what’s so special about it? Continue Reading
-
News
29 Jun 2010
Is Oracle’s rosy Oracle-Sun merger picture really that rosy?
Oracle painted a pretty picture of its first full quarter with the Oracle-Sun merger under its thumb. But the reality doesn’t entirely jibe with that picture of the Oracle-Sun merger. Continue Reading
-
Answer
29 Jun 2010
How to add disk to ASM diskgroup with two-way mirroring
Learn how to add disk to ASM diskgroup with two-way mirroring and how to specify a failgroup in this tip from Oracle expert Brian Peasland. Continue Reading
-
News
17 Jun 2010
U.S. government sues Oracle for tens of millions of dollars
The federal government says Oracle failed to disclose deep discounts it gave to commercial customers. The cost? Perhaps more than $100 million. Continue Reading
-
News
15 Jun 2010
Oracle Fusion Middleware 11g getting updates
Oracle's key sales pitch for its Oracle Fusion Middleware 11g updates is "integration," but according to some, there’s still room for more of it. Continue Reading
-
News
01 Jun 2010
Jewelry manufacturer chooses Oracle on Unix over x86
Jewelry manufacturer Stuller chose Oracle on Unix and Intel Itanium rather than x86 when changing out its old Superdome. But why? Continue Reading
-
News
27 May 2010
Oracle Sun server hardware sales nosedive
Oracle Sun server hardware sales dive-bombed in the first quarter of this year. Meanwhile, all other server hardware vendors saw growth. Continue Reading
-
News
25 May 2010
Third-party tools for Oracle: Special report
Learn about the options for third-party tools for Oracle databases and why Oracle third-party tools are growing in popularity. Continue Reading
-
News
20 May 2010
Are Oracle unlimited license agreements really unlimited?
Oracle’s unlimited license agreements have grown in popularity, but end users should pay close attention to the details rather than assuming that “unlimited” means unlimited. Continue Reading
-
News
18 May 2010
Oracle continues hardware push with Sparc-based Sun Netra servers
Oracle has announced a new blade chassis and server for its Sun Netra server line. The one blade server is Sparc-based, which seems to jibe with Oracle pushing Sparc and de-emphasizing x86. Continue Reading
-
News
14 May 2010
New Oracle Database 11g book offers 'underground' tips
April Sims, a DBA at Southern Utah University and an Oracle Certified Professional, talks about her new book, “Oracle Database 11g Underground Advice for Database Administrators.” Continue Reading
-
News
11 May 2010
New Toad tool offers Oracle database development with Visual Studio
Quest has released Toad Extension for Visual studio, a new database schema provider to improve Oracle database development. Continue Reading
-
News
04 May 2010
Duke Energy emerges from 'dark period' with PeopleSoft 8.9 upgrade
Scared to touch a fresh PeopleSoft upgrade for years, Duke Energy finally bit the bullet and moved to 8.9. A new financial data hub helped ease the transition. Continue Reading
-
News
27 Apr 2010
Green computing virtualization initiatives need assessment, planning
Green computing virtualization initiatives can work, but building a virtualization software strategy in an Oracle shop demands a careful assessment of the existing infrastructure. Continue Reading
-
News
22 Apr 2010
Oracle licensing, support on VMware still a hindrance
Database pros say Oracle’s licensing and support policies for Oracle on VMware are still a pain point, mainly because Oracle considers VMware to be “soft partitioning.” Continue Reading
-
News
20 Apr 2010
Oracle users in wait-and-see mode with Oracle's stack computing strategy
Oracle continued to press its stack message of integrated applications, middleware, database and hardware, but some Collaborate attendees have heard it before. Continue Reading
-
News
15 Apr 2010
Collaborate '10: Special Report
SearchOracle.com is on the scene at Collaborate '10 in Las Vegas with breaking news and advice from the largest annual Oracle applications conference. Continue Reading
-
News
14 Apr 2010
Oracle updates, reaffirms commitment to MySQL
Speaking to a gathering of open source database users, Oracle's chief architect said the company remains committed to MySQL. Continue Reading
-
News
25 Mar 2010
Oracle grid computing and cloud computing: Special report
In this Oracle grid computing and cloud computing special report, learn about the difference between grid and cloud computing, the cloud and grid products that Oracle offers and users’ future plans for adoption. Continue Reading
-
News
18 Mar 2010
Oracle rolls out new lifecycle management for Sun environments
Oracle has backed up its promise to support Sun environments with the delivery of Oracle lifecycle management software for Sun’s Sparc and Solaris products. Continue Reading
-
Answer
17 Mar 2010
Do I need to pay extra for licenses for an Oracle Partitioning Option?
Do you have an Oracle Partitioning Option installed in your database? Learn whether you need to pay extra for licensing and how to be compliant in this tip from an Oracle licensing expert. Continue Reading
-
Answer
01 Feb 2010
When to use double quotes in Oracle column to avoid invalid identifier
Are you seeing an invalid identifier? Learn when to use double quotes in Oracle column names to avoid this in this tip from PL/SQL expert Dan Clamage. Continue Reading
-
Feature
27 Jan 2010
The future of Oracle and Sun
With the EC giving the Oracle/Sun deal a stamp of approval, it’s time to see what’s in store for the future of Oracle and Sun as we learn plans for Sun’s server hardware, virtualization technology, MySQL database and more. Continue Reading
-
Tutorial
28 Oct 2009
Oracle virtualization introduction guide
This introductory guide to Oracle virtualization is designed to help you define and understand the basics of Oracle virtualization including Oracle's VM. Continue Reading
-
News
06 Oct 2009
Coca-Cola Bottling swaps out Oracle for DB2
Spurred by a deal that would include DB2 with licenses for SAP products, Coca-Cola Bottling Co. decided Big Blue is better than Oracle. Continue Reading
-
News
17 Sep 2009
Oracle OpenWorld 2009 Special Report
This special report is your guide to Oracle OpenWorld 2009, the biggest annual conference for users of Oracle database and applications technology worldwide. Continue Reading
-
Tutorial
01 Sep 2009
Oracle applications learning guide
This learning guide is a one-stop shop for information on Oracle's changing role in the enterprise applications space, with news, analysis and tips on Oracle's acquisitions, Project Fusion, E-Business Suite and other apps, the battle between Oracle and SAP and more. Continue Reading
-
Answer
26 Aug 2009
How to decrypt an Oracle password using John the Ripper and checkpwd
Learn how to decrypt an Oracle password with Oracle password crackers like John the Ripper and checkpwd in this tip from an Oracle security expert. Continue Reading
-
Feature
19 Aug 2009
SELECT statement syntax and examples
In this chapter, learn how to use the SELECT statement with SELECT statement examples, including the basics of the SELECT statement syntax. Continue Reading
-
Tutorial
22 Jul 2009
Comparing servers for Oracle database 11g upgrades
An Oracle 11g upgrade means server hardware will need more octane. Find out how to compare Oracle 11g servers for database upgrades and which servers will speed performance. Continue Reading
-
Answer
24 Jun 2009
How to use the CREATE SESSION command to track Oracle database logins
Oracle security expert Brian Peasland explains how to use the CREATE SESSION command in an Oracle audit table to track Oracle user database logins. Continue Reading
-
Answer
22 Jun 2009
Can I download DBCA for Oracle Express Edition?
Understand how to install the DBCA in Oracle 10g Express Edition and why you cannot simply download DBCA in Oracle in this expert tip. Continue Reading
-
Answer
20 May 2009
Can I create multiple schemas in Oracle for one user?
Want to create multiple schemas for one user in Oracle? Learn whether it's possible here. Continue Reading
-
Feature
27 Apr 2009
Oracle E-Business Suite manufacturing and supply chain management
Find out what the Oracle E-Business software suite can do for manufacturing supply chain management (SCM). Learn supply chain planning and forecasting strategies for Oracle SCM software. Continue Reading
-
Answer
16 Apr 2009
How to concatenate rows into a single CLOB in PL/SQL
PL/SQL expert Dan Clamage explains how to concatenate rows into a single CLOB in PL/SQL. Continue Reading
-
Answer
09 Apr 2009
Using the SQL GROUP BY clause for counting combinations
Read SQL expert Rudy Limeback's advice for counting combinations in a table with SQL's GROUP BY clause Continue Reading
-
Answer
25 Mar 2009
How to solve an ORA-1555 error in the Oracle testing database
Expert Brian Peasland explains to a SearchOracle.com reader asks why the ORA-1555 error is showing in the Oracle testing database but not in production Continue Reading
-
Feature
13 Mar 2009
How to use SQL Developer to run SQL statements
In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more. Continue Reading
-
Feature
12 Mar 2009
How to view and edit table column definitions
In this chapter, learn how to edit and view column names and column definitions for a table, and when to use SQL Developer to do so. Continue Reading
-
Feature
12 Mar 2009
How to use SQL*Plus in Oracle
In this section, learn how to use SQL*Plus in Oracle, which may be used to run SQL statement and scripts if an Oracle database does not have SQL Developer installed. Continue Reading
-
Feature
12 Mar 2009
How to work with the Oracle database home page
In this chapter, learn how to work with an Oracle database, including how to start and stop the Oracle database and use the database homepage, before learning how to use Oracle SQL Developer. Continue Reading
-
Feature
12 Mar 2009
How to use SQL Developer to work with an Oracle database
In this chapter, learn how to use Oracle SQL Developer to review or modify your database design, navigate database objects and create, export and import database connections. Continue Reading
-
Answer
19 Feb 2009
How to sort an SQL UNION query with special ORDER BY sequence
SQL expert Rudy Limeback explains how to sort an SQL UNION query using a special ORDERY BY sequence. Continue Reading
-
Answer
19 Nov 2008
Using an SQL SELECT statement from a non-existing table
SQL expert Rudy Limeback explains how to formulate a query using an SQL SELECT statement from a non-existing table. Continue Reading
-
Answer
10 Nov 2008
Using LEFT OUTER JOIN query to get zero row counts in SQL
An SQL expert explains how using a LEFT OUTER JOIN query can retrieve zero row counts in SQL. Continue Reading
-
Feature
17 Oct 2008
List the types of SQL subqueries
In this chapter, learn about the three broad divisions of a subquery in SQL: Single-row, multiple-row and correlated subqueries. Continue Reading
-
Answer
15 Oct 2008
How to create an SQL CHECK constraint for two letters
SQL expert Rudy Limeback explains how to create a SQL CHECK constraint for two letters when trying to write a query to retrieve data from two tables. Continue Reading
-
Answer
02 Oct 2008
How to disable Oracle constraints and triggers during an import in 10g
An Oracle user asks expert Brian Peasland if constraints and triggers can be disabled on an Oracle import in Oracle 10g and how to complete this task. Continue Reading
-
Answer
11 Sep 2008
How to return a zero in SQL instead of no row back for a select count
Want your row to return a zero instead of getting no row backs for some combinations when doing a select count in SQL? Find out how here. Continue Reading