Oracle competitors and market analysis
Top Stories
-
News
25 Jun 2019
Oracle Analytics Cloud update unifies BI products, pricing
Oracle Analytics Cloud now offers a consistent UI and all-in-one pricing for Oracle's analytics tools. But an on-premises BI update is also on the way for cloud holdouts. Continue Reading
-
Opinion
14 Dec 2018
The real Oracle cloud strategy that may work vs. AWS and Azure
Oracle's database software is at the heart of its efforts to move users to its cloud. And that strategy might work, despite Oracle's inauspicious standing in the cloud now. Continue Reading
-
Answer
22 Jul 2008
Business Analyst vs. Data Architect: Who should do the source-to-target mapping?
An Oracle user asks who should do the source-to-target mapping in a company--the Business Analyst or Data Architect. Continue Reading
-
Answer
10 Jul 2008
Why am I receiving the ORA-12535 error when using a remote database?
An Oracle user asks why they are receiving the error ORA-12535: TNS: operation timed out when using a remote database. Continue Reading
-
Answer
08 Jul 2008
Defining RTO, MTBF and MTTR
Database backup and recovery expert Brian Peasland explains the terms RTO, MTBF and MTTR. Continue Reading
-
Answer
03 Jul 2008
Using BETWEEN with DATETIMEs in SQL
Expert Rudy Limeback is asked if SQL can be used to retrieve data between two dates, including the two dates. Continue Reading
-
Answer
03 Jul 2008
Which normal form is used most?
SQL expert Rudy Limeback explains what normal form is used in most database projects. Continue Reading
-
Answer
19 Jun 2008
SQL query for co-authored books
SQL expert Rudy Limeback gives advice for writing a query that involves a number of tables. Continue Reading
-
Answer
20 May 2008
SQL for hourly totals for the last 48 hours
SQL expert Rudy Limeback explains to an Oracle user how to user asks how to generate datetimes or use left outer join to get hourly totals for the last 48 hours in SQL. Continue Reading
-
Answer
20 May 2008
LEFT OUTER JOIN to a MIN/MAX row
An Oracle user asks SQL expert Rudy Limeback how to use a LEFT OUTER JOIN with a MIN/MAX condition. Continue Reading
-
Answer
14 May 2008
What is the difference between an instance and mounting in Oracle?
An Oracle user asks what the difference is between an instance and mounting. Continue Reading
-
Answer
28 Apr 2008
Import on one table from dump file
An Oracle user asks if it is possible to do an import on one table from a large dump file. Continue Reading
-
Answer
17 Apr 2008
How do I retrieve second transaction for each customer?
An Oracle user asks how to write a query to retrieve the second transaction for each customer. Continue Reading
-
Answer
24 Mar 2008
SQL to round up to nearest thousand
SQL expert Rudy Limeback explains how to use the CEILING function. Continue Reading
-
Answer
22 Feb 2008
How to drop tablespace with missing datafile
Oracle expert Brian Peasland explains how to drop a tablespace with a missing datafile and recreate the tablespace. Continue Reading
-
Answer
25 Jan 2008
Select from one table based on condition in another
SQL expert Rudy Limeback explains how to select from one table based on condition in another using an inner join in Oracle. Continue Reading
-
Answer
16 Jan 2008
How to use DISTINCT on just one column
SQL expert Rudy Limeback explains how to use DISTINCT on just one column. Continue Reading
-
Answer
11 Jan 2008
What is the difference between obsolete and expired status?
Oracle expert Brian Peasland explains the difference between obsolete status and expired status. Continue Reading
-
News
21 Sep 2007
Oracle's free SQL Developer adds database migration tool
Oracle SQL Developer is offering a new tool that lets users migrate data from Microsoft and MySQL databases to Oracle. Continue Reading
-
Answer
15 Aug 2007
LOB tables missing with exp/imp move of schema
I have a problem when moving a schema using exp/imp. After import, the tables with LOBs are missing. Continue Reading
-
Answer
15 Aug 2007
Add or drop inactive online redo log files
Can we add or drop (inactive) online redo log files at the open stage? Continue Reading
-
Answer
09 Aug 2007
Query on dblink returning ORA-12545 error
I have a dblink between Oracle 9i and Oracle 10g. When I execute this query sometimes I get the result, but sometimes I get the error "ORA-12545." Continue Reading
-
Answer
06 Aug 2007
Restore database from backup without control files
If you just had to restore from backup and do not have any control files, how would you go about bringing up this database? Continue Reading
-
Answer
01 Aug 2007
Integrity constraints and referential integrity
What is the difference between integrity constraints and referential integrity? Continue Reading
-
Answer
20 Jul 2007
Difference between driving table and driver table in Oracle
I need to know the difference between the driving table and driver table in Oracle. Continue Reading
-
Answer
20 Jul 2007
Use HAVING with CASE to count specific instances
I'm trying to construct a SELECT statement that will return people that have NO live courses running at the moment. Continue Reading
- Answer 17 Jul 2007
-
Answer
12 Jul 2007
Performance goals for DBAs
Do you have any suggestions on how to measure DBA job performance and provide meaningful goals for performance management of DBAs? Continue Reading
-
Answer
21 Jun 2007
How to create an index using a procedure in Oracle
How can we create an index using a procedure? Continue Reading
-
Answer
15 Jun 2007
What is the difference between left outer join and (+) outer join?
What is the difference between left outer join and (+) outer join? Continue Reading
-
Answer
07 Jun 2007
The MAX of two MAX values in SQL
Can I get the max of two columns into one column in SQL? Continue Reading
-
Answer
31 May 2007
Obtaining COUNTs for males and females in one SQL query
For my table the gender column has only two values; F and M. I would like to do a count of both genders in one SQL query. Continue Reading
-
Tip
31 May 2007
Acing the DBA job interview: Getting back to basics
DBAs are again in high demand, but this should not be viewed as a free ticket to a new, higher-paying job. Having superior credentials does not mean that all you have to do is submit your resume and wait for an offer. You still need to follow the basic business principles for landing that next job. In other words, you have to get back to the basics and earn it. Continue Reading
-
News
31 May 2007
Oracle vs. SAP: The SOA factor
SAP is beating Oracle on the SOA front, but IBM has got the edge over them both, says one expert. But who's in front may not matter for many just yet. Plus, SOA planning tips. Continue Reading
-
News
31 May 2007
Oracle upgrades require careful planning
The next major Oracle technology upgrade cycle is getting closer. Will your company be ready? Continue Reading
-
Answer
24 May 2007
Using GROUP BY to collapse rows
Can I get the following with one select statement in SQL? Continue Reading
-
Answer
22 May 2007
How to increase SGA_MAX_SIZE in Oracle
How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup. Continue Reading
-
Answer
18 May 2007
SQL to calculate days to next status change
I would like to find out how long a particular customer order has been on hold in SQL. Continue Reading
-
Answer
18 May 2007
UPDATE only rows which match another table in SQL
I have a SQL query where I am trying to update a column in a table from data in another table. This works fine when I try to update all the records in the first table; however, Is it possible to update only the missing data? Continue Reading
-
Answer
11 May 2007
Employees with the same first and last names in SQL
How do I SELECT a list of employees who have the same last and first name in SQL? Continue Reading
-
News
03 May 2007
Author Mike Ault sizes up the new Oracle Database 11g
Oracle book author Mike Ault talks about the upcoming Oracle Database 11g's new SQL replay and memory management capabilities. Continue Reading
-
Answer
26 Apr 2007
Columns in the SELECT not in the GROUP BY
I have an SQL query where I am using the SUM function with the GROUP BY clause. I need to select a couple more columns from the table without adding those columns in the GROUP BY clause. Continue Reading
-
Tip
25 Apr 2007
PL/SQL do's and don't's: Five questions with Steven Feuerstein
Oracle PL/SQL expert Steven Feuerstein advises on what you should never do in PL/SQL -- and what you should always do. Continue Reading
-
Answer
23 Apr 2007
When will support for Oracle 9i be discontinued?
When will general support for Oracle 9i be discontinued? Continue Reading
-
Answer
12 Apr 2007
What should my global database name be?
When I type hostname it returns me this localhost.localdomain. So what should be my global database name if SID is ora9i? Continue Reading
-
Answer
05 Apr 2007
LEFT OUTER JOIN without using LEFT OUTER JOIN
Can I get the same result as LEFT OUTER JOIN without using LEFT OUTER JOIN? Continue Reading
-
Answer
02 Apr 2007
ORA-04082: NEW or OLD references not allowed in table level triggers
I am calling a stored procedure from a trigger. It shows the error: "ORA-04082: NEW or OLD references not allowed in table level triggers." Continue Reading
-
Answer
22 Mar 2007
Check current SCN in control file
How to check current SCN or header in the control file? Continue Reading
-
Answer
22 Mar 2007
Add a column in a specific position in a table
I have created one table with three columns. I want to drop one column and add the column back to the same table in the same location. Continue Reading
-
Answer
08 Mar 2007
Totals from a UNION query
I'm trying to retrieve a count of rows using a union, but for some reason I get two rows returned with different counts. Continue Reading
-
Answer
27 Feb 2007
Definitions of checkpoint, PMON and SMON
What is a checkpoint? What are PMON and SMON? Continue Reading
-
Answer
22 Feb 2007
ORA-01702: a view is not appropriate here
I'm creating an index on a view using Oracle 9.2.0. I get the error ORA-01702 (a view is not appropriate here). Continue Reading
-
Answer
12 Feb 2007
Migrating database from Solaris to Linux
What is the procedure to migrate an Oracle database from a Solaris machine to Red Hat Linux 9? Continue Reading
-
News
31 Jan 2007
Oracle SQL Developer vs. Toad: Users speak out, part two
Oracle developers are still talking about their favorite PL/SQL editing and debugging tools, and their opinions aren't confined to just Toad and SQL Develper. Continue Reading
-
Answer
18 Jan 2007
Invalid stored procedures
When running an application that is connected to an Oracle server/database and trying to add rows or make a call to the DB, I am getting various errors that the stored procedures are invalid. Continue Reading
-
Answer
17 Jan 2007
COUNT(*) or COUNT(1)
How do you specify difference between count(*) and count(1) in a select statement? Which is best to use and when? Continue Reading
-
Answer
11 Jan 2007
Encountered the symbol "ELSE" when expecting one of the following
I am a beginner to Oracle. I am getting this error: "ORA-06550: line 21, column 1: PLS-00103: Encountered the symbol "ELSE" when expecting one of the following:" Continue Reading
-
Answer
02 Jan 2007
GROUP BY multiple columns
My table structure is empid, category, col1, col2, amount. I would like to get the results as total of amounts for the col1 and col2 combinations, with a particular category. Continue Reading
-
Answer
18 Dec 2006
Sorting a clob column
I'm trying to sort a column type asc as well as desc. I'm able to sort the clob column desc but not able to sort it asc. Can you please help me out? Continue Reading
-
News
29 Nov 2006
Oracle tutorial library: SearchOracle.com's learning guides
One of the best resources SearchOracle.com offers is our collection of learning guides. They're a perfect education tool for the beginner who's just getting started with Oracle or the seasoned professional looking to attain expert status. We've gathered all our Oracle tutorials here in one invaluable list that you can return to again and again whenever you need a helping hand. Continue Reading
-
Answer
26 Oct 2006
Finding the highest COUNT in a GROUP BY query
I want to get the maximum of totalcontracts from the retrieved data using a select statement. Continue Reading
-
Tip
19 Oct 2006
Introduction to BPEL
It's important for managers, developers and DBAs to have an understanding of how BPEL can benefit them. This article provides an introduction to BPEL including Oracle's BPEL Process Manager. Continue Reading
-
Answer
12 Oct 2006
Steps to implement RAC
How can I implement a RAC application in Oracle Database in my system? Continue Reading
-
Answer
06 Oct 2006
Foreign keys in a composite primary key
Is it possible to use one of the attributes of a composite primary key as a foreign key? Continue Reading
-
Answer
04 Oct 2006
Non-zero values for SHARED_POOL_SIZE and JAVA_POOL_SIZE
I am getting an ORA-04031 error. I have a two-node 10g RAC cluster. If I gave both SHARED_POOL_SIZE and JAVA_POOL_SIZE values (thus overriding the defaults) how would this affect the running of the CLUSTER? Does a CLUSTER require these values to be 0? Continue Reading
-
News
29 Sep 2006
Oracle acquisitions timeline: From soup to nuts, PeopleSoft to Sigma
In this Oracle acquisitions timeline, find all the details on Oracle buyouts such as PeopleSoft, Hyperion, BEA Systems and the Oracle Sun acquisition. Continue Reading
-
Feature
27 Sep 2006
Oracle Fusion Update Center
Everything you need to know about Oracle's high-profile acquisition spree and Fusion integration plans is here in one spot. Continue Reading
-
Tip
27 Sep 2006
High availability with Flashback Database
Flashback Database is a new approach to point-in-time (PIT) database recovery. This incomplete recovery strategy can be used to recover a database that has been logically corrupted due to human error. Introduced in Oracle 10g, it is designed to maximize availability by reducing recovery time. This article will explore Flashback Database, compare it to traditional recovery methods and demonstrate how to configure and perform a flashback recovery. Continue Reading
-
News
14 Sep 2006
Gartner makes Oracle CRM predictions
Plenty of Siebel users are still concerned and confused over the direction of their CRM tool. Analysts at the Gartner CRM Summit offered some clues. Continue Reading
-
News
07 Sep 2006
Oracle security guru Peter Finnigan on the problem with PL/SQL
The protective wrapping around the programming language used to write procedures and commands in the Oracle Corp. database -- PL/SQL -- isn't as ironclad as some might expect, says Oracle security guru Peter Finnigan. In this new SearchOracle.com podcast, Finnigan explains what DBAs need to know to protect their systems. Continue Reading
-
Tutorial
01 Sep 2006
Oracle database performance tuning guide
Learn the tricks of industry experts for identifying and eliminating performance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common problem areas. Continue Reading
-
Answer
01 Sep 2006
DISTINCT applies to all columns in the result
Could you tell me what are the effects of using the DISTINCT keyword before a group of different column names in a SELECT statement? Continue Reading
-
News
31 Aug 2006
Spotlight on Oracle performance tuning
Performance tuning -- keeping your database and SQL queries running quickly and smoothly -- is one of the most important and demanding tasks for an Oracle DBA. This special report compiles analysis, tips and expert advice to help you meet your tuning challenges and keep your users happy. Continue Reading
-
Answer
28 Aug 2006
System vs. object privileges
What is the difference between system privileges and object privileges in Oracle? Continue Reading
-
Answer
28 Aug 2006
Exporting selected procedures and functions in Oracle
How can we export selected procedures/functions/packages in Oracle? Continue Reading
-
News
22 Aug 2006
The Oracle Security Challenge
Let's find out what how much you really know about Oracle security. Continue Reading
-
Tip
21 Aug 2006
Oracle RAC design: The effects of component failure
This excerpt from the book "Oracle 10g Grid & Real Application Clusters" shows expert techniques used by real-world RAC professionals for designing a robust and scalable RAC system. This section provides a quick look at the effects of component failure. Continue Reading
-
Tip
14 Aug 2006
Oracle vs. Sybase: 10 reasons to use Sybase on Linux
Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh. In this tip, he gives 10 reasons why Sybase on Linux bests other databases, particularly Oracle. Continue Reading
-
Answer
14 Aug 2006
Difference between two dates in hours
How to calculate the difference between two dates in hours? Continue Reading
-
News
01 Aug 2006
Spotlight on Oracle security
This special report compiles news, analysis and expert advice on Oracle security topics, including breaking articles and content from our archives, to help you conquer your daily security challenges. Continue Reading
-
Tip
19 Jul 2006
Service-oriented architecture: Realizing tangible benefit from SOA in the near term
This introduction to service-oriented architecture (SOA) clarifies some basic terms, such as service and Web services, and provides an overview as to how your organization can begin to see benefits from SOA. Continue Reading
-
Answer
14 Jul 2006
Using SQL to find the number of Sundays in a month
I want to find out how many Sundays come in any month in SQL. Continue Reading
-
Tip
07 Jul 2006
Regulatory compliance and the DBA: What you need to know
At the top of business executives' minds today is how to meet regulatory compliance and corporate governance rules. New laws are changing the way companies collect, retain and manage information. DBAs need to understand what is happening in the corporate business world and how it will directly impact their job role. Continue Reading
-
News
05 Jul 2006
Spotlight on compliance
This special report compiles news and analysis on regulatory compliance, a top priority for anyone working with Oracle or in IT. Continue Reading
-
News
29 Jun 2006
Eight key Oracle developer tools
Consultant Sridhar Bogelli provides a refresher on some of the key tools that developers use to customize Oracle E-Business Suite applications. Continue Reading
-
Tip
21 Jun 2006
Performance tuning a RAC implementation
The performance tuning methodology for an Oracle Real Application Clusters (RAC) configuration can be broadly categorized into these seven steps. Continue Reading
-
News
20 Jun 2006
Survey: DBAs not planning for downtime
Companies need to do more to reduce the amount of database downtime resulting from both planned and unplanned events, a new IOUG survey finds. Continue Reading
- Answer 16 Jun 2006
-
News
13 Jun 2006
Five Oracle developer best practices
A refresher on some best practices designed to make sure that apps developers don't go messing up production boxes. Continue Reading
-
Answer
09 Jun 2006
Grid or RAC?
Which is better, RAC or 10g Grid? When to use both or either of these? What are the steps to install 10g Grid? Does it require a special license? Continue Reading
-
News
30 May 2006
Spotlight on RAC, grid and availability
Availability is a hot-button issue with DBAs these days -- users want more of their data available more of the time. You can achieve this through grid computing and Oracle's Real Application Clusters (RAC). This spotlight includes breaking news on these technologies, as well as analysis, expert advice and tips from our archives, to get you up to speed on what RAC and grid are all about. Continue Reading
- Answer 04 May 2006
-
Answer
21 Apr 2006
ORDER BY a specified sequence
I'm trying to create an SQL query with the IN clause where I give the IDs to match. Now I want the order of these records to be the same as I give in the IN clause. But it's not happening. Continue Reading
-
Answer
12 Apr 2006
Check if date is greater than 2000 in PL/SQL
How to check if the date is greater than the year 2000 in PL/SQL? Continue Reading
-
News
06 Apr 2006
Special Report: Oracle enterprise apps
This special report compiles news, tips and analysis on Oracle Applications and E-Business Suite, including coverage of the Collaborate '06 show in Nashville. Continue Reading
-
News
20 Mar 2006
Java and the Empowered Database
This article by Norbert Ehreke proposes an approach where the modeling is done in the relational tier and as much business logic as possible is handled within the database by employing a set of stored procedures as the middle tier. Continue Reading
-
News
14 Mar 2006
Oracle unveils free SQL Developer: Has Toad met its match?
Oracle's newly released free SQL Developer could spell trouble for Quest Software Inc.'s popular Toad for Oracle software. Continue Reading
-
News
14 Mar 2006
Special Report: Oracle vs. SAP
This special feature compiles new and archived content covering the ongoing battle between Oracle and SAP in the enterprise applications space. Continue Reading
-
Tip
09 Feb 2006
Got CRM? 10 questions to ask before you buy
CRM is a big investment. Consider these strategic and technical questions before you take the plunge. Continue Reading
-
Answer
16 Jan 2006
Standard vs. Enterprise Editions of Oracle
What's the difference between Standard Edition and Enterprise Edition? Continue Reading
-
Answer
11 Jan 2006
Difference between function, procedure and trigger
What is the difference between a function, a procedure and a trigger? I know the basic differences, but I would like to know the answers based on the performance tuning aspect. Continue Reading
-
Answer
09 Jan 2006
Easy way to import public synonyms?
Using export/import to update a development database, I normally do a schema (user) import. Is there an easy way to import public synonyms? Continue Reading