-
Return non-matching rows from both tables
An Oracle user asks how to return only non-matching rows when joining two tables.
-
Can I write triggers from Oracle 7 to Oracle 11?
An Oracle user asks how to write triggers from Oracle 7 to Oracle 11.
-
I am running out of disk space, how do I hot swap my drives out?
An Oracle user asks, "I am running out of disc space, how do I hot swap my drives out?"
-
Taking a full offline backup
A SearchOracle.com member asks how to take a full offline backup through Oracle 8.0.
-
Using rule-based optimization to optimize a query
A SearchOracle.com member asks, "Can I have a detailed explanation of how and when the 15 rules of Rule Based Optimization are used when optimizing a query?"
-
Clone database vs. standby database
A SearchOracle.com member asks, "Can you tell me the difference between clone database and standby database? "
-
Cleaning a temporary tablespace
A SearchOracle.com member asks, "I have an Oracle 10g database with its temporary tablespace full. Is there any way to clean this tablespace?"
-
How to convert a SQL Server 2005 database to Oracle 10g
Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?"
-
Using Oracle Streams
Oracle expert Harish Harbham explains how Oracle Streams can be used for replication.
-
Becoming a Junior DBA
A SearchOracle.com member asks, "What are the requirements for becoming a Junior DBA?"
-
When trying to find a job, should I focus on becoming educated in Oracle or SQL?
A SearchOracle.com member who wants to restart his career asks, "Should I focus on Oracle or SQL? What, in your opinion, is there a greater demand for in the workplace?"
-
How important is ERP knowledge?
Oracle expert Michael Hillenbrand explains how important ERP expertise is when starting a career in Oracle.
-
Value of Oracle Certified Professional (OCP) exam in landing entry-level job
A SearchOracle.com member asks, "Will taking the OCP Exams be beneficial to me in getting a DBA or Database Designer job?"
-
How to transfer data from Oracle to MS SQL Server
SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server.
-
How to create a mediated schema
A SearchOracle.com member asks, "I have two different relational schemas with me. Can I get an example as to how to integrate them and create a mediated schema?"
-
How to use Oracle Heterogeneous Services
Expert Harish Harbham explains how to use Heterogeneous Services to update non-Oracle systems.
-
Extracting data from within a column
A SearchOracle.com member asks, "How do you write a command that will return data within a column? "
-
How to use DISTINCT on just one column
SQL expert Rudy Limeback explains how to use DISTINCT on just one column.
-
How to update columns dynamically
A SearchOracle.com member asks, "How do you update columns dynamically, depending on the conditions?"
-
Oracle 10g and Vista Premium OS
A SearchOracle.com reader asks, "Is Oracle 10g compatible with the Vista Premium OS?"
-
Perfect the Oracle RMAN duplicate 10g command
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
-
Do SQL arithmetic without using arithmetic operations
Learn how to do simple SQL arithmetic operations without using the arithmetic operators.
-
Managing SQL parent table-child table relations
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.