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.

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.

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.

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 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.

Pavi has produced an article for Oracle DBAs interested in finding ways of partitioning the tables as well showing a new form of partitioning using Oracle 9i

In this interview, devArticles has a chat with an informative university lecture about the Oracle database. I was impressed when Doctor Janusz Getta agreed to conduct an interview with me in relation to Oracle. I know how hard the life of a lecture is and to take the time to answer my questions was great to see. I have sat down to many of his lectures and found them extremely useful in the work I do today.

The SID is the oracle database you want to connect to. You'll notice that I'm not sending the username and password. Abstract the OCILogin Another common problem in the Oracle connectivity world is where the passwords are stored.

This whitepaper takes you through different ways of database connectivity to Oracle database from .NET. This also talks about the advantages and disadvantages of all of these technologies.

This source code shows you how to connect to an oracle database and do operations such as select, insert, update and delete.

This article discusses Oracle Net Services, the suite of products that enables a connection between your application and the Oracle database, and how best to configure and troubleshoot it.

Most ASP developers are familiar with data connections using ActiveX Data Objects (ADO). However, Oracle provides the OraSession object to manage collections of OraConnection, OraDatabase, and OraDynaset objects used within your application.

This is a simple ASP program that allows the user to create a backup copy of a DB user's tables. It uses Oracle Objects for OLE (OO4O) for database access to Oracle and for the backup function, Oracle's Export Utility program is used.

I'll take it that you have visited www.oracle.com , read the hype and decided to register and download Oracle on your win32 platform. What you really wish to do however is be able to use Oracle as the data source for your website. This article will explain the sequential process of developing and maintaining your Oracle driven website. We will use PHP and Apache. Database security will also arise and a quick discussion of alternatives to each of the tools.

In this walk-through you'll learn about designing an InfoPath form that connects to Oracle database server.