A collection of 26 FAQs on PL/SQL managing our own procedures. It can also be used as learning tutorials on creating procedures and functions, executing and dropping procedures, passing actual parameters to formal parameters, making optional parameters.

This article provides tutorial notes on Sun's Reference Implementation of JdbcRowSet working with MySQL database. Topics include installing JdbcRowSet reference implementation; connecting JdbcRowSet objects to database server with connection URL, DataSource name, ResultSet objects or Connection objects; query parameters; inserting rows.

A collection of 14 FAQs on Transact-SQL language character string and binary string operations. Clear answers are provided with tutorial exercises on concatenating character/binary strings; converting Unicode character strings; converting binary strings; inserting new line characters; locating and taking substrings; bitwise operations.

This article provides tutorial notes on sending non-ASCII text data to MySQL. Topics include sending non-ASCII text data in SQL statements; changing MySQL character set settings to send Latin1, UTF-8, BGK, and Big5 characters

In this fifth article in the series about managing content in an employee workplace, the author describes how the team designed and implemented a sample Web portal application to support the authoring tasks for the document management scenario called Analyst research reporting. The scenario is about employees collaborating to author, review, and publish research reports accessible to every employee in the company.

Learn how to use databases on mobile devices.

What elements comprise a database? This article deals mainly with the objects that comprise a database. Several concepts are worthy of coverage within the scope of the database as it relates to database design. As you work with data and databases, you will see how the origination of business information and databases is formulated into database elements. The intent here is to provide a brief coverage of basic database elements to provide you with a basic understanding of the elements found in a database.

Showcases the XML functionality of SQL Server 2000 by turning SQL Server into an object repository using XML as the bridge between relational and object-oriented data.

Find out how well IBM DB2, Microsoft SQL Server 2000, Oracle Database 10g, and Sybase ASE handle the structured documents that drive today's business.

Doug explains how to get data out of the SqlDataReader. He explains how to get the column data including GetString(), GetDateTime(), GetValue(), etc.

Xml has become a very ubiquitous and is an integral part of .Net and the System.Data namespace. The problem lies in that not many people know how to take advantage of some of the features. When we are using a database, we naturally use the Systen.Data namespace, but with Xml documents as data there are hundreds of solutions for displaying Xml data out there for .Net.

An extremely flexible and easy-to-use library that retrieves data in XML format, supports simple parameterized queries, stored procedures, and transactions. It can also be used as a web service.

In this article, you’ll learn how to extract a list of stored procedures from a database, plus information about the parameters associated with the stored procedure. Finally, you’ll see how to take this information and use it to call a stored procedure on the fly.

Along with database design, Indexes are the backbone of optimal database performance. It requires specialist knowledge to ensure that you have the right indexes for the right job and this article will provide you with enough knowledge to make the right choices - and to know when to use an index and when not.

Basically, the Rules of Normalization are enforced by eliminating redundancy and inconsistent dependency in your table designs...

Steve gives us a great explanation of what a database is, the relational database model, metadata and indexes, the database management system and structured query language.

Julie has written this article to assist a dba to evaluate their database so that it matches the organisation's needs...The database which you think is best matched with your organization is your..

In this article I will introduce you to the JDBC API, showing you how to connect to and work with a database.

The information that has presented in this article is an extremely basic look at databases. If you'd like to learn how to create databases and use manipulate them, then please take a look at the list of related links and books, which are shown below.

MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. In this article Annette takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script.Active Server Pages are a Microsoft technology that allows developers proficient with either Visual Basic or VBScript to easily adapt their skills and knowledge to the web with very little effort at all. ASP uses ActiveX Data Object (ADO) to connect to several popular database management systems including Microsoft Access and SQL Server, Oracle, dBase and Visual Fox Pro.