Search results for query: *

Assuming it is TOAD your vendor refers to, the acronym stands for Tool for Oracle Application Developers and it provides a MS-Access-like alternative to SQL*Plus for interaction with an Oracle database. Beware when using with a production database however, as it has a tendency to lock tables...

You could try something along the lines of: select e.* from employee e, (select e1.emp_id, count(e2.emp_id) from employee e1, employee e2 where e1.startdate < e2.startdate (+) group by e1.emp_id having count(e2.emp_id) < 10) sub where e.time_key =...

If your source and target tables are in the same database instance, instead of using a values clause you should be able to do something like: insert into target_tab (col_a, col_b, col_c) select a, b, c from source_tab; I'm not familiar with JD Edwards, so this syntax may not be exactly correct...

You could do it with a PL/SQL script e.g. DECLARE l_date date; BEGIN FOR c_duration IN (select time_opened, time_closed from duration) LOOP l_date := to_date(to_char(c_duration.time_opened,'YYYYMMDDHH24MI'), 'YYYYMMDDHH24MI'); LOOP...

geenew, a small proof of concept at my site with PowerCentre 5.1 using a 4 CPU NT box with 1Gb RAM showed high paging and disk usage - it was concluded that considerably more RAM may be needed as it is planned to run many streams in parallel. Did you specifically choose an IBM M80 for the job...

Have a look in the Oracle8i Application Developer's Guide - Large Objects (LOBs): You could use Oracle Objects for OLE (OO4O), a Windows-based product included with Oracle8i Client for Windows NT. You can make changes to a LOB via OO4O by using one of the following objects interfaces...

I don't see any need for slamming - in fact I'd agree with you :-) The time dimension may grow when keys for new days / weeks / etc. are added, but once in there, a time dimension element doesn't change its values unless you restructure the dimension (e.g. to add quarterly reporting if not...

Limona, This post would probably better fit in the Oracle Developer forum ( http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/31/pid/259 ), but you may be able to process the records in your second block individually, looping around each in order to trap duplicate row errors (and possibly...

Soheils, you could try converting DateShown to a text string and comparing the last so many characters with the equivalent from today's date.

I'd like to canvass your opinion and experience regarding what server hardware has been used to run ETL products. I'm particularly interested in hub and spoke tools here (e.g. Informatica PowerCenter, Ascential DataStage, etc.) rather than code-generators (e.g. ETI Extract), or set-ups where the...

Boa, if the groups are regular groups of 5 you could try grouping by something like trunc(x/5) i.e. the integer result of a division operation (n.b. syntax may vary depending on RDBMS); if not you may want a look up table with lower and upper range bounds and an identifier, join to it where...

I have a general question regarding what platforms people are running Informatica on out there, and what sort of performance they are experiencing. I'd be interested in the vendor, operating system, amount of processors and RAM, and the amount / type of data being transformed.

I sounds like you're going to try selecting things that aren't there - always tricky ;-) I'd suggest using a second temporary table, populating it with the possible slots, in one hour increments or whatever granularity is required, then select slots from this secondary table where timestamps...

The idea behind the query rewrite feature is that you define your MV to match a commonly executed query on a (set of) large tables; then instead of having to select from your snapshot explicitly by re-writing your query code, the RDBMS will detect the conditions of your query and determine that...

Data Warehousing technology covers a wide range of products, tools and techniques. Probably more important than any of them though is to have a good understanding of why you're considering it, and what information is highest priority. As anand4all implies, unless your organisation has a lot of...

The Tuxedo version number displays when you boot up the Tuxedo servers using tmboot; alternatively, it is written at the start of the ULOG files when a new file is started. Tuxedo includes some functionality for restarting servers when errors are detected; the times I've seen them die have been...

I would suggest that you model the hierarchies to correctly reflect the business relationships. What you will have to consider with this sort of 'uneven' data, is how you structure your information. One option may be to generate 'dummy' key entries to represent aggregations/unavailability of...

Serji, Are you trying to implement a trigger to stop duplicate rows from being inserted ? or to handle the error caused an existing constraint ? If the former, then the (Oracle 8i) syntax for adding a primary key contraint is shown below, if the latter, you may be better putting a trap...

Oops, typing too slow, you got in before me Mike. I was assuming the problem was dynamically executing the statement stored in the table row ?

This sort of construct may work for other forms of DML statement (e.g. inserts), but it won't work for selects. Select statements return a result set (the column values), but you haven't provided anywhere for your results to be put.