Email Alerts
-
Oracle querying for developers
What pain points do you experience in Oracle querying? Read this excerpt from Michael McLaughlin’s Oracle Database 11g & MySQL 5.6 Developer Handbook to learn the answers to your questions. Feature
-
Oracle application development trends toward the Web
With the economy forcing developers to pursue less expensive methods of Oracle application development, many are evaluating Web development tools, including those for Rapid Application Development. Tutorial
-
Toad 10: Good for database developers, good for administrators
A major strength of Toad 10 is its ability to serve both Oracle database application developers and administrators equally well. Tutorial
-
RAD Studio 2010 supports Oracle databases, .NET environments
The three versions of Embarcadero’s RAD Studio 2010 are designed for individual developers and teams of developers building client-server and RAD Web applications for native Windows and .NET. Tutorial
-
How to use the Oracle Database SQL Reference Manual
In this chapter, learn how to use the Oracle Database SQL Reference Manual, a collection of technical information on the SQL statements that work with the Oracle Database. Chapter Download
-
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. Chapter Download
-
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. Chapter Download
-
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. Chapter Download
-
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. Chapter Download
-
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. Chapter Download
-
Oracle Advanced Analytics bundles R with Oracle Database
Oracle Advanced Analytics is the company’s newest announcement around data analytics, a market that Oracle seeks to blanket with products. News | 08 Feb 2012
-
Can Oracle be a NoSQL player?
The Oracle NoSQL database is mainly an attempt to satisfy existing Oracle Database customers interested in big data on the side, experts say. News | 25 Oct 2011
-
Quest boosts Toad for Oracle with version 11
New features of Toad for Oracle include more automated code analysis, allowing read-only access to production databases and reporting across all managed databases. News | 26 Sep 2011
-
Oracle Database 11g R2 High Availability sample book chapter
Here is a sample chapter from Oracle Database 11g R2 High Availability, a new book from Oracle Press. Book chapter | 27 May 2011
-
Ensuring high availability in Oracle Database 11g R2
Scott Jesse, senior manager for Oracle RAC customer support, discusses Oracle Database 11g Release 2 High Availability, a book he co-wrote this year. News | 27 May 2011
-
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. News | 24 Sep 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. News | 25 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. News | 11 May 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. News | 14 Apr 2010
-
Oracle delivers database fixes in Critical Patch Update
Oracle has shipped 38 database fixes affecting 21 products in its most recent Oracle Critical Patch Update (CPU), including three critical security patches for its core database. Article | 22 Oct 2009
- See More: News on Oracle DBA tools
-
Oracle XML capabilities in Oracle Database 11gR2, part 1
New Oracle XML capabilities in Oracle Database 11gR2 allow for easier reading and manipulation of XML documents, according to columnist Jeff McCormick. In part 1, McCormick introduces the reader to XML capabilities in Oracle Database and sets up a sc... Tip
-
How to create a database link in Oracle
Part of our "How do I do that in Oracle?" series, this tip explains in detail how to create a database link as well as how to troubleshoot db link errors. Tip
-
SearchOracle.com Lessons Learned Library
SearchOracle.com has identified your FAQs and compiled applicable expert answers in an easy-to-follow format. Tip
-
Oracle Application Server 10g administration: Using Enterprise Manager
Read this excerpt from Oracle Application Server 10g administration handbook to find out about using Enterprise Manager for deploying applications. Tip
-
Using Oracle flashback querying for DDL audit
Oracle's new flashback querying is an immensely useful feature and can be used to audit the DDLs (data dictionary changes) issued on the entire database. Tip
-
Terminating 11i concurrent requests
With this script, you can find the SID, serial number and server PID for a terminated concurrent request so that the process can be killed at the database and OS level. Tip
-
Working with Oracle10g's new global temporary table features
This tip will help those planning to work with Oracle10g's new global temporary table features -- VARRAY and nested tables. Tip
-
Oracle housekeeping scripts
Here are a few scripts for Oracle database "housekeeping". Tip
-
Find out about TEMP/SORT area usage
This script will give you an idea about the existing usage of the TEMP/SORT area. Tip
-
Determine used and free space in a tablespace
Use this script to determine total size, used space, free space and percentage of used and free space in all tablespaces. Tip
- See More: Tips on Oracle DBA tools
-
STATSPACK tool: transaction vs. execution measurement
An Oracle user asks about the difference between an Oracle transaction versus execution measurement found in the STATSPACK tool. Ask the Expert
-
Steps to use SQL Developer
Please let me know how I can get my hostname, service name and the port number to be able to run SQL statements and do other things on Oracle SQL Developer. Ask the Expert
-
Steps for copying a database or schema
Follow these steps to copy an entire database or a schema using Oracle's export and import utilities. Ask the Expert
-
Modeling tools that support DB2 and forward/reverse engineering
Ask the Expert
-
Tool to transfer DB objects from Oracle 8i to SQL Server
Ask the Expert
-
Tools to help size tables
Ask the Expert
-
The most important reporting and query tools
Ask the Expert
-
Reporting tools for Oracle 8i
Ask the Expert
-
virtual private database (VPD)
A Virtual Private Database (VPD) makes the database tables seem like they belong to one user when multiple users may actually be using that table. Definition
-
multidimensional database (MDB)
A multidimensional database (MDB) is a type of database that is optimized for data warehouse and online analytical processing (OLAP) applications. Multidimensional databases are frequently created using input from existing relational databases. Definition
-
Pick
Pick is a data base management system (DMS) based on a business model of data and its organization and traditionally associated with minicomputer systems for small- to medium-size businesses. Definition
-
How to get the most out of Toad for Oracle 10
Toad Product Manager John Pocknell talks about Toad for Oracle 10 in this podcast, discussing its new features, how it can be used by both DBAs and developers and more. Podcast
-
Oracle Advanced Analytics bundles R with Oracle Database
Oracle Advanced Analytics is the company’s newest announcement around data analytics, a market that Oracle seeks to blanket with products. News
-
Oracle querying for developers
What pain points do you experience in Oracle querying? Read this excerpt from Michael McLaughlin’s Oracle Database 11g & MySQL 5.6 Developer Handbook to learn the answers to your questions. Feature
-
Can Oracle be a NoSQL player?
The Oracle NoSQL database is mainly an attempt to satisfy existing Oracle Database customers interested in big data on the side, experts say. News
-
Quest boosts Toad for Oracle with version 11
New features of Toad for Oracle include more automated code analysis, allowing read-only access to production databases and reporting across all managed databases. News
-
Oracle Database 11g R2 High Availability sample book chapter
Here is a sample chapter from Oracle Database 11g R2 High Availability, a new book from Oracle Press. Book chapter
-
Ensuring high availability in Oracle Database 11g R2
Scott Jesse, senior manager for Oracle RAC customer support, discusses Oracle Database 11g Release 2 High Availability, a book he co-wrote this year. News
-
virtual private database (VPD)
A Virtual Private Database (VPD) makes the database tables seem like they belong to one user when multiple users may actually be using that table. Definition
-
Oracle XML capabilities in Oracle Database 11gR2, part 1
New Oracle XML capabilities in Oracle Database 11gR2 allow for easier reading and manipulation of XML documents, according to columnist Jeff McCormick. In part 1, McCormick introduces the reader to XML capabilities in Oracle Database and sets up a sc... Tip
-
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. News
-
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. News
- See More: All on Oracle DBA tools
About Oracle DBA tools
Learn about Oracle administration tools and compare DBA tool vendors and options with these tips and resources.