I have a long transaction (taking hours) with all tables within the
transaction
are temporary tables with no log and locked in exclusive mode, thus
there will be no LOG

I am reseaching into the best method for implementing a booking system
data structure. My booking system in full will be used to store
details on landlords apartments .. this part isnt too big an issue for
me as I can have a table called 'landlord' and a table called

I was trying to redirect output of a query to  file attached to root
of drive c:\ . I am trying to look up type of data stored in various
tables and the sort of data is being stored.
When I use this command

I have a university degree, but I've spent many years away from the
computer industry for family commitment  . I need to find a way to be
trained again so I can reshape my skills and find a job as DBA, QA or
BA. Any idea about companies that provide that kind of training and

Actually, i have a need to store the numbers like "AS2303",
TS3381"(first 2 alphabets,next 3 numbers). What i want is, i have to
assign the integrity which can check the following values,
     23334, ASDER, SDE23, 233A4 and like this.

In Microsoft SQL Server unfortunetly the only consistent date format is
YYYYMMDD, this is legacy from Sybase original code apparently; using
YYYY-MM-DD is converted as YYYY-DD-MM in many localised SQL Server installs
(us_english is fine, other languages even British aren't).

Is there a commercial RDBMS that allows one to create indices on
views?
I'm asking this partly because of BCNF.
A typical BCNF problem is (where -> is a FD)

I'm dissecting databases at the moment, and I've started to implement
my own just to get the proper understanding of things. To continue
from where I am right now I need to learn about string processing used
in todays RDBMSs. Issues I need to get the hang of are such as:

Hi everyone, I want to copy query results from read-only database to
another database, do you know any handy tool which can help me? I use
squirrel but it can't directly create new table with query result inside
database which is different from source database (I have to create

Did anyone knows a database system which can execute the following query:
select *
from (select rownum t, a, b, c, d from datatable where c=1 order by a,b,c)
where t=15

Try this out
http://db2examples.googlepages.com