Top five news features
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
1. Is Oracle technology too darn expensive? This year, many IT professionals said they would consider an alternative to Oracle because of the high cost of running Oracle database or business applications technology.
2. Oracle SQL Developer gets an update Last January, Oracle unveiled a new version of its free SQL Developer tool and also the SQL Developer Exchange site.
3. Author Mike Ault sizes up the new Oracle Database 11g This exclusive podcast interview features Mike Ault, a popular speaker at all the major Oracle conferences, discussing Oracle Database 11g's new SQL replay and memory management capabilities and much more.
4. Oracle shows off Database 11g Last July, after a nine-month beta-testing period, Oracle unveiled its Database 11g, the long-awaited overhaul of Oracle's flagship database management system.
5. Oracle SQL Developer vs. Toad: Users speak out, part two Oracle developers had differing opinions on the best PL/SQL editing and debugging tools.
Top five expert responses
1. SQL FAQ: Common SQL questions Expert Rudy Limeback answers readers' common SQL questions, in the categories of novice questions, homework questions and serious SQL questions.
2. What is ORA-06512? How can I rectify it? Oracle expert Karen Morton explains what is meant by a 06512 error.
3. Difference between subquery and join Rudy Limeback answers the question, "When comparing subqueries and joins, which one is faster?"
4. FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows... Rudy Limeback explains how to find specific rows in a table but highlights an often misunderstood conception about relational tables.
5. How to avoid the ORA-04030 error? Expert Brian Peasland explains how to avoid the ORA-04030 error, meaning that the Oracle process has requested memory from the operating system but the OS does not have any memory to give.
Top five tips
1. Acing the DBA job interview: Getting back to basics Read this article to learn what hiring managers look for in a DBA candidate, such as having an accurate and readable resume and taking time to conduct a follow-up.
2. DBA 102: Beyond the basics This article highlights the technical (hard) and non-technical (soft) skills you will need to survive as a DBA, and how to deal with management and ensure job security.
3. Fast guide to finding and keeping an Oracle job Whether you're a seasoned veteran or looking for your first Oracle job, this guide will help you stand out from the hundreds of other job seekers.
4. How do I do that in Oracle? This series is a collection of tips that explain in detail how to perform specific tasks in Oracle related to database administration.
5. The power of Oracle certification Oracle expert Michael Hillenbrand discuss the certification process and examines some of the arguments for and against certifications.
Top blog posts:
1. "Database administration is for suckers"?
2. Is Oracle supportive?
3. Does anybody really like SQL?
4. Oracle ACE program "almost completely worthless"
5. Thirty years of Oracle innovation — but is it really a RDBMS?
Top 5 learning guides
1. Fast Guide: Solving common Oracle errors Check out our helpful list of every expert response pertaining to Oracle errors on SearchOracle.com.
2. Exporting Oracle data In this compliation of questions and answers, SearchDatabase.com's resident Oracle experts Eli Leiba, Karen Morton and Brian Peasland explain how exporting Oracle data is done, with step-by-step instructions and example scripts.
3. Fast Guide: PL/SQL Helpful for both newbies and veterans, this fast guide links you to PL/SQL tips, expert responses and resources on SearchOracle.com and from around the Web.
4. Crash Course: Oracle basics This crash course will help you research Oracle technologies or get started with your own Oracle DBMS, bring you up to speed on Oracle DBMS basics for versions 8.x through 9.x, and provide you with an overview of Oracle10g's new tools and features.
5. Importing into Oracle In this Ask the Experts compilation, learn how to load text files without SQL*Loader, import a dump multiple times and import from different versions.