Hi, all.
Newbie question here.
Thing is, I am responsible for database design in one DWH solution. It
is quite complicated, about 100 tables and growing. Recently analysts

We are planning for an Oracle database upgrade form 8i to 10g. We were
presently using
Oracle 8i version 8.1.6.3.0 for our production database. We were running
the 64 bit version of Oracle Standard Edition on a Unix server.

Hi, I'm still trying to get the info together to employ a company to
build an e-library for us. Someone advised me yesterday against
confusing databases with text-retrieval systems, which apparently is
what I want, really. I have never heard of this difference and my

For a project of importing files, I need a txt-file that includes fixed
length data.
Does anyone have such a file in his repository? Any kind of data would
be great!

i was wondering how i set two records in the same line this is my code.
also insted of inputting the membership ref numbers how do i select
them from a txt or csv file.
regards

I'm using mysql 4.0.x, which does not allow the following query (which works
fine in 4.1).  Is there any way I can issue a single query to achieve the
same results?  (I want a list of all records from table al, nulled where
there is no match in table alm, which has been filtered. ...

Hi!  I am looking for a 5-10 yrs DBA with RAC (real applicatio
clusters)implementions, Version 10G.  Also, hold Sercet clearance o
higher
If you or anyone you know is interested please contact me a

I need to create a SQL query where a given column will have unique
values.  So far I tried this:
SELECT DISTINCT col1, col2, col3, col4 from SOMETABLE
but the distinct part seems to consider col1, col2, col3 and col4 as

CREATE TABLE `servers2` (
          `name` varchar(255) NOT NULL default '',
          `idx` mediumint(8) unsigned NOT NULL auto_increment,
          PRIMARY KEY  (`name`),

I need to develop a scheduling app and am having trouble with the
database
design. I can easily design a table hold appointments with start and
finish

I've got a problem that I can't quite wrap my head around, about adding
a constraint to my PostgreSQL genealogy database. If somebody are
interested, I've written some thoughts on the general design at
<http://soluslekt.org/forays.blue.php>.

For a course, i need a business database, with stuff like costumers,
products, invoices, anything, having a average dimension in terms numbers of
records. I want to explore it witn the students, using SQL and some tools.
Do you know something like that avaiable in the internet?

I'm having a design issue with my web application and I believe that it
involves a fairly basic crosstab, but I'm not sure of which style of
query I should use.
Say that I have two tables, one full of users and another full of

I'm looking for recommendations for a good straightforward database
development software package with nice functionality (for example
attach/embed files of various formats including jpegs)-- shareware or
freeware licensed.

Hello boys must install for test Oracle Rac on my pc a Windows 200
only I have a problem do not have no other PC to put in cluster wit
mine there is a way to try the installation using only a PC.
Thanks to everybody and sorry for my Englis