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
-
Answer
02 Dec 2005
Multiple rows with same value in one column
I'm doing a search from one table and my goal is to show only the rows with the same value in one of the columns. I am only interested in seeing the rows for all the emp_no that shows more than once. Continue Reading
-
Answer
28 Oct 2005
DELETE WHERE NOT EXISTS
I have two tables, A1 and A2, and they both have a column called SSn. How will I delete a row from table A2 that doesn't exist on A1? Continue Reading
-
Answer
26 Sep 2005
Converting a column from VARCHAR2 to DATE
I need to convert a date column created using data type VARCHAR2 into data type DATE. Is it possible? Continue Reading
-
Answer
19 Sep 2005
LEFT OUTER JOIN on more than two tables
Is it possible to perform LEFT OUTER JOIN in more than two tables? If possible, please give me details. Continue Reading
-
Answer
16 Sep 2005
LEFT OUTER JOIN with ON condition or WHERE condition?
I would like your explanation of the difference between a LEFT OUTER JOIN ON condition and a WHERE condition. Continue Reading
-
Answer
31 Aug 2005
Converting from CHAR to DATE datatype
As a time value, I used the CHAR datatype and need to convert to a DATE value while manipulating/computing. How do I use the DATE datatype instead? Continue Reading
-
Answer
22 Aug 2005
Installing 32-bit and 64-bit Oracle on same machine
I have an application that does not support 64-bit Oracle. It needs to run on 32-bit Oracle. Can I install two Oracle engines (32-bit and 64-bit) on the same machine? If so, how can it be done? Continue Reading
-
Answer
16 Aug 2005
Multiple instances on a single database
Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)? Continue Reading
-
Answer
16 Aug 2005
VARCHAR2 vs. NUMBER
What is the correct circumstance to store a numeric string as VARCHAR2 vs. NUMBER? The response I have received before is to store all numeric strings as VARCHAR2 unless the intention is to manipulate the field mathematically; but no reason has been given. Continue Reading
-
Tutorial
21 Jun 2005
Relational Database Management System (RDBMS) fundamentals tutorial
New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database management system. Continue Reading
- Answer 18 Apr 2005
-
News
14 Apr 2005
So you want to be a DBA...
@9963 Robert G. Freeman, Oracle consultant and the author of several books, including "Portable DBA: Oracle" and "Oracle Database 10g New Features," knows a bit about the highs and lows of being an Oracle DBA. At next month's IOUG Live! 2005 conference, Freeman will share some of what he has learned in his 17 years with those of you who are new to the role, or considering it, and SearchOracle.com got a preview. Continue Reading
-
News
07 Apr 2005
Recovering from "Compulsive Tuning Disorder"
Performance tuning expert Gaja Krishna Vaidyanatha wants to help DBAs who suffer from what he calls "Compulsive Tuning Disorder" (CTD). Vaidyanatha, owner of consulting firm DBPerfMan.com and an author of several Oracle books, including "Oracle Performance Tuning 101," coined the term to describe the haphazard tuning techniques that many DBAs use. Speaking at next month's IOUG Live! 2005 show in Orlando, Vaidyanatha will talk about the specific methodologies he uses for pinpointing performance problems. SearchOracle.com chatted with him and got a preview of his presentation. Continue Reading
-
Tutorial
05 Apr 2005
SQL guide for Oracle users
Whether you are a newbie or a seasoned expert looking to tweak query performance, this learning guide to the structured query language (SQL) has something for you. These seven chapters can help you figure out how to get the data you need by looking at solutions to real-world problems. Continue Reading
-
Tutorial
01 Mar 2005
Learning Guide: Backup and recovery
Backup and recovery is arguably the DBA's most important responsibility. This Learning Guide covers everything from the basics of creating a backup and recovery plan to the specifics of using RMAN and other methods of hot and cold backups. Samples of scripts and step-by-step instructions can help anyone who wants a database that can survive any disaster. Continue Reading
-
Tip
16 Feb 2005
DBA certification
Craig Mullins tells you why you should, or shouldn't, care about DBA certifications. Continue Reading
- Tip 15 Feb 2005
-
Tip
15 Feb 2005
The morphing of database administration
Craig Mullins discusses some of the trends and issues that will impact data management professionals in 2005. Continue Reading
- Answer 31 Jan 2005
- Answer 07 Oct 2004
-
Answer
28 Sep 2004
Purpose of roll forward and roll backward
What are rolling forward and rolling backward in backup and recovery? Continue Reading
- Answer 23 Sep 2004
-
Tip
22 Sep 2004
Oracle tuning: Blocksize and index tree structures
There has been a great debate about the structures of Oracle index trees and whether they are important to Oracle tuning. Guru Don Burleson gives his opinion on the matter. Continue Reading
-
Tip
15 Sep 2004
Oracle tuning fallacies
Some common fallacies about Oracle tuning, including the importance of reducing logical I/O, the meaninglessness of hourly tuning averages, and more. Continue Reading
-
Tip
14 Jul 2004
Oracle disk I/O tuning: Disk performance statistics
This is the third tip in a series on the different aspects of disk I/O performance and optimization for Oracle databases. Continue Reading
-
Tutorial
08 Jun 2004
Oracle PL/SQL tutorial
This PL/SQL tutorial can help both newbies and veterans become better acquainted with the Oracle development language and hone their developer skills. Continue Reading
- Answer 07 Jun 2004
- Tip 26 May 2004
-
Tip
15 Mar 2004
Merging datasets with NULL values
A MERGE may appear to work properly, but it's important you check your target dataset to make sure it does. This tip explains why and how. Continue Reading
-
News
12 Dec 2003
Roll forward versus roll back
Database extra tip #2 from "30 tips in 30 minutes," brought to you by the IOUG. Continue Reading
-
News
05 Nov 2003
Oracle OCMs are rare breed
The Oracle Certified Master (OCM) certification is only for top-tier Oracle gurus who spend years gaining real-world experience before being tested on far-out IT scenarios. Continue Reading
-
Tip
06 Aug 2003
Find users who have unlimited quota on a tablespace
Here is a query to find users that have unlimited quota on a tablespace. Continue Reading
- Answer 25 Jun 2003
-
News
09 Apr 2003
How to get an Oracle DBA job
Despite the steepest downturn in the history of IT, there are jobs to be had by Oracle certified professionals and DBAs. To get them, insiders say, IT pros need to remember some of the rules they learned long ago and apply some new strategies as well. Continue Reading
- Answer 17 Mar 2003
- Answer 18 Feb 2003
- Answer 29 Jan 2003
- Answer 25 Nov 2002
- Answer 25 Nov 2002
- Answer 11 Nov 2002
- Answer 11 Nov 2002
- Answer 05 Nov 2002
- Answer 17 Oct 2002
- Answer 17 Oct 2002
- Answer 04 Oct 2002
- Answer 02 Oct 2002
- Answer 18 Sep 2002
- Answer 13 Aug 2002
- Answer 12 Jul 2002
- Answer 18 Jun 2002
-
Tip
10 May 2002
How to convert milliseconds to the proper date format
How to convert milliseconds in Oracle to the proper date format. Continue Reading
- Answer 24 Apr 2002
- Answer 19 Apr 2002
- Answer 16 Apr 2002
- Answer 16 Apr 2002
-
Tip
20 Mar 2002
Oracle Java application performance, part 2: JDBC driver comparisons
A comparison of the performance of OCI and thin drivers. Continue Reading
-
Tip
19 Mar 2002
Oracle Java application performance, part 1: Creating dynamic strings
Tips about using dynamic strings in Oracle and how they can improve Java application performance. Continue Reading
- Answer 15 Mar 2002
- Answer 24 Feb 2002
- Answer 13 Feb 2002
- Answer 30 May 2001
- Answer 27 Mar 2001