I want to get some data from a time reporting system we use into Excel.
The list from which I want to get the data from is generated on certain
parametres such as period and which unit within the company. When you
have generated the information you want a list of names of the people

Who can tell me about "EMS MS SQL Manager 1.8.5.2" serial code or crack
path?? I need this is software, but I have not found out it!
thank you!!

So, I'm investigating oracle, and there's not a lot of inhouse expertise
with it.  We've got a fairly good handle on the client side of things,
and would like to become more familiar with how things operate on
the server side.

  When managing a lot of databases, some databases always hit
short-time load peak, it's hard to monitor, so need to write program to
capture the information to analyze it to find the root cause of the
load peak.

Is there any way I can check if the system time is between a certain
range (e.g. 3 - 9 pm)?
e.g. select * from <table> where systime >= "15:00" and systime <=
"21:00";

we have an application running an Oracle's 8.1.7. - unfortunally the
code is wrapped and we do not have any support from the software company
that made this application.
We have following SQL query that slows down the whole system (taken from

Could someone explain (or point out the relevant documentation about)
situations in which you would want to index several columns vs making
multiple indexes, one  for each column? Also, I understood that the
order of columns in a multi-column index was important, but I do not

For the "Disk Utilization" alert by default the grid ctl gives
a message looking like

Is there still an active Oracle Users Group for Belgium (or Flanders) ?
I tried http://www.bloug.org/ but it hasn't been updated in a while ...
You can contact me offline : matthias (dot) hoys (at) skynet (dot) be.
Thanks

I have a job I ouuld like to submit to delete historical data.
I need the job to run the 15th of every month at 330 am.
I am not sure how to get the date right ( IE the 15th)for the Interval
parm I need to pass w/ the DBMS_JOB.SUBMIT function.

I've encountered something that I believe is a bug in PL/SQL under 10g
(at least on 10.1.0.3).
Here's an example script:
--------

I try to create ea trigger on View
---
CREATE TRIGGER "GECOM"."IN_VW_FATTOMEGA" INSTEAD OF
   INSERT

I'm in trouble with a 8.1.7 rdbms which fails to shutdown cleanly on a
Win2000 server; in detail, when server is rebooted alert log shows a
crash recovery, I tried to close db manually and it works well; I found
this issue also on Metalink, but some unavailable patches are required.

I'm working in Oracle 9i Reports Developer. I have two queries that are
the source for one of my reports.  These two queries are connected by
two "data links". Each "Data link" connects 1 column from "Query #1" to
another column in "Query #2". I want to create a "Before Report" ...

What is a good documentation resource for index designing?  We're
running oracle 10g, and I have a number of queries that need to run
similar to the below example:
FROM   "BILL_FCT"  AB