I am facing the build problem while installing the DBD-MySql perl
module (ver 2.9008) using both GCC and CC compilers in HP-UX machine.
For the Build using GCC, the compiler error is produced due to the
unknown GCC compiler option "+DAportable".

Background:
===========
We have an Oracle 8i site that has a replicated (standby) database
using the RECOVER MANAGED STANDBY DATABASE command.

If I do:
SELECT * FROM items, itemtocategory WHERE itemtocategory.itemuid
=items.itemuid and itemtocategory.catuid=1 order by items.created limit
1 , 10 ;

What is the best way to store a friend relation between two given
users?
I use this:
idfriendship (pk, auto increment)

I'm looking to find out how I'd go about setting up a database where a
visitor to my site could punch in their postal code, and find out how far
they are from another postal code.  For example, AutoTrader has this feature
I believe to tell you how far the vehicle is from you.  ...

Help!  I have two tables, Table1 and Table2.  Table1 has a field called
lastname and Table2 has a field called name.  I need to search Table2
to see if the last name field from Table1 is contained within the field
name.  Other than doing this progamatically, can this be done using

I am having problems designing the following situation: We need to
store information regarding different resource objects. The objects
will be of different types, for example Cabincruiser, MTB, F16,
Submarine etc. Each type should have default values for attributes

I am trying to create a server that shares legal mp3's.
I would like to have the mp3's organized so that they can be searched
and organized in a variety of ways, for example, through composer,
genre, date etc.  As of now, I have a website for each composer, and

I'm loading data into a database but having trouble (probably
self-inflicted) figuring out how I can use SQL to first load to a
super-type table that generates an auto-incrementing Primary Key and
then using that primary key as the Foreign Key to load data into my

Please help me use trace tools of TOAD
Thank you

Q> SQL sort quention
There are 'P1' and 'P10' in the data to be sorted.
1:I want a query result only about 'P1', but 'P10'
is affected to the result by my mistake in SQL statement.

We will be developing a management reporting software for a bank. The
user will see reports that get updated in near real time( e.g. every 5
min), with data regarding transaction amounts, etc. across a number of
dimensions such as day, time, region, etc.

If I do:
SELECT * FROM items, itemtocategory WHERE itemtocategory.itemuid
=items.itemuid and itemtocategory.catuid=1 order by items.created  ;
I get tons of matching records. But if I do:

I need to choose between Oracle and SQL Server.
The scenario is as follows:
1. Real time / near real time performance expected.
2. Around 15 million records.

Isn't it true that table-based security usually uses the CRUD model? If
so, then what is the usual way to handle the situation in which you want
a user to be able to C/R/U/D only one line of a table, e.g., that relating
directly to himself?