[Before you point me to alt.comp.databases.mysql, you be told that the
group there is almost completely orphaned and I hardly expect any reply
in the next 2 weeks - hence my apologies in advance if I happen to be
wrong with my question here]

I have a following problem.
I have installed Teradata Database 5.0 (Demo version).
I tried to use EXTENDED GROUPING FUNCTIONS like: rollup, cube, grouping
sets.

Dear friends,
This is a message which some people may consider "a spam". But this
is not my original idea. My intention is to share with you that French
verb conjugation is as simple as that of English, suggesting to you an

My file contains city-names and their states (for example: Riverside
CA; Waco TX; Gnarly Nob, WV; etc).
How can I compare my file with valid (U.S.P.S.) city-names and their
states?

I have a column in TERADATA table: time_stpm VACHAR(22)which contains
timestamps in the following format: DDMMMYYYY:HH:MM:SS.nnn (timestamp
imported from SAS 8.0 through ODBC using put statement (put
(timestamp,DATETIME22.3) )). For example:

I am trying to create a database having "Term of Service" column,
"Version" and "UserID" column. For "TOS" column, the data may have more
than 9000 characters with HTML characters. What type I should use in
this case? BLOB?

My friends, I never worked with RDb before, but I developed a software
using Oracle 9i and now I had to use RDB... and I'm having lots of
problems.
I have a column declared as REAL and another one as Char, I need to put

I have the following question as a part of some course notes. The answer is
not provided and is not a part of any assessment for the course.
In nested loop join, for each record in the first, "outer" relation (table
R, say), every record - and hence every page - is sequentially ...

I have an entity Credit_Card ( credit_no , type, expiration_date).
Because of repetition of "type" attributes ,Should i split this entity
into 2 entities so there isn't data redundancy.
 1. Credit_Card (credit_no,expiration_date)

Please help me solve problem in installing Oracel client
I install Oracel 9.2.0.1 client on PC has following configure
Win XP Profesiona
SP

I have mysql 4.0.something (so I can't do subselects).
I think this is a common question:
I have 2 tables, they each have a column called "age" (float not null).
The two tables are in no way related to each other, neither has the

Does anyone know how I can backup my data in EMC's Documentum Content
Server 5.2.5? I'm using Oracle 9i database, but that only saves the
meta data. What I need is to somehow backup all of the files that I'm
keeping in Documentum. I have Veritas NetBackup for my server here

I'm trying to translate from mysql to pgsql one query as below
SELECT DISTINCT name FROM table ORDER BY surname
Referring to mysql this query was working perfectly, however when I try use
this query with pgsql I didn't achieve result

I have the following table, which stores simple HTTP requests:
  Column    |           Type           | Modifiers
--------------+--------------------------+-----------
ip           | character varying(254)   |

I know some SQL, but the project I am working on is getting to complex
for me to just wing it.
What is better for DB design - UML or ERM ?
Thank you for your opinion.