A collection of 23 FAQs on Oracle user account, schema and privileges. Clear answers are provided with tutorial exercises on creating user accounts, granting privileges for session connections, granting privileges for creating tables and inserting rows.

A collection of 23 FAQs on working with database objects in PL/SQL. Clear answers are provided with tutorial exercises on running DML statements, assign table data to variables, using the implicit cursor, defining and using RECORDs with table rows.

A collection of 27 FAQs on Oracle loading data and exporting data. Clear answers are provided with tutorial exercises on saving data as flat files, loading data from flat, exporting and importing database, schema and tables, creating external tables.

A collection of 33 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views, sorting and counting query outputs, grouping outputs and applying group functions, joining tables, using subqueries.

Oracle has announced the immediate availability of the Oracle (Collaxa) BPEL Process Manager with native, cross-platform, and comprehensive BPEL support. The BPEL Process Manager enables enterprises to model, deploy and manage BPEL processes. It comprises an easy-to-use BPEL modeler, a scalable BPEL engine, an extensible WSDL binding framework, a monitoring console and a set of built-in integration services for transformation, user tasks, and java embedding.

Over the last 27 years, Oracle has made tremendous improvements in its core database product. Now, that product is not only the world's most reliable and performant database, but also part of a complete software infrastructure for enterprise computing. With each new release comes a sometimes dizzying display of new capabilities and features, sometimes leaving developers, IT managers, and even seasoned DBAs wondering which new features will benefit them most.

OraDirect .NET Data Provider is a full featured 100% managed .NET data provider for direct access to Oracle for the Microsoft .NET Framework. Provides additional to ADO.NET functionality, design-time extensions and wizards.

This article is a quick summary of basic SQL commands with a little touch of Oracle to prepare for application development.In the previous article, you were given you a rough idea of the design and development issues that are involved in creating a database in Oracle 9i. You learnt about built-in data types available in the Oracle 9i language. Also discussed were user defined object schemas. Covered in Part 1 on this series was how to configure both PHP and Apache configuration files such that they could communicate with an Oracle database.

Narayan Veeramani shows how ASP.NET developers can improve application performance by caching data stored in an Oracle database and keeping the cached data in

For building scalable and high-performance Web based applications, ASP.NET provides a feature called data caching. Data caching enables programmatic storing of frequently accessed data objects in memory. This feature can be extended to vastly improve performance for ASP.NET applications that query data stored in an Oracle database. This article describes a strategy for caching Oracle database data in ASP.NET Web applications deployed using a Web Farm environment.

A set of potential buffer overflows has been discovered in the XML Database (XDB) functionality of the Oracle9i Database Release 2. A knowledgeable and malicious user can exploit these buffer overflows to cause a Denial of Service (DoS) attack against and/or capture an active user session of the Oracle9i Database Server.

These are tips coming from the Oracle JDeveloper Product Management and Development Team.

This article describes a strategy for caching Oracle database data in ASP.NET Web applications deployed using a Web Farm environment.

In this article Lorenzo explains a neat utility to simplify connecting to an Oracle database using PHP/OCI8.

This question is a very valid question for most people beginning and experienced with Oracle from within ASP. Because of the variety of things that are needed, there can be many answers to this question.

Support for Oracle internal NUMBER datatype added. Allows to work with high precision numbers without accuracy losses Following list describes the main features of Oracle Data Access Components:

Folks, contrary to popular belief there are many ways to call stored procedures from an ASP page. I've tried it with Oracle (the only REAL RDBMS) and it works.

This step-by-step article describes how to use the .NET Managed Provider for Oracle to pass an Input parameter, to retrieve a Ref Cursor from an Oracle stored

This article has hopefully given you a rough idea of the design and development issues that are involved in creating a database in Oracle 9i.

Oracle's SQL optimizer is a sophisticated tool for tuning database performance, but the default values may require tweaking.