Search results for query: *

Thanks for the info. I will probably plump for the ODBC as all I require are reasonable straight forward selects and the performance seems to be acceptable in the tests I have run. Though did have a little trouble getting it working over a WAN until I discovered you need to set up user...

Hi, I need to be able to import data through an automated process from a non-oracle system. I have found two possible ways of doing this using either of the following Oracle technologies Transparent Gateway or Gerneric Conectivity. Does anybody have any experience of using either of these...

I won't be able to use ADO or DAO I can use ODBC, I am just interested in accessing the file itself if possible.

Thanks, I have already used that link and although it does give some useful information it is not exhaustive. I was just looking for any hands on experience of actually reading the mdb files if possible. Thanks Gareth

Hi, I am looking for any information on the format of the mdb files. I need to read from mdb files to gather data from the tables contained within. I could achieve this using an ODBC connection but ideally would like to read the file directly. Has anybody here had any experience of the...

Hi, I have to access data from an external system to read into our system on a daily basis, at the moment it looks like the data will supplied in a MS Access database. We have done this in the past for the text files using UTL File. Has anybody had much experience of doing this? I looked at...

Hi, Thanks for all the feedback and good insight into the differences between IN and INTERSECT. I have another question problem that I seem to of come across kind of related. Basically I have created a tool that combines schemas of identical structure as consolidation of regional databases...

Thanks for the help guys, in this case I can guarentee the columns are in the same order. Just as a matter of interest why is the intersect method more efficient than the in method? Thanks Gareth

Hi, I am trying to idenitfy duplicate records in two tables, the tables share exactly the same structure but there is no primary key. Is there a more efficient way to do this than below? select * from T1 where (cola,colb,colc.........,colx) not in (select cola,colb,colc,..............colx)...

I have two tables a and b both conating fields x and y, I wish to update table a field x with the value of table b field x where a.y=b.y; update a set a.x=b.x where a.y=b.y but this doesn't seem to work am I am missing something? thanks Gareth

Hi, Thanks for the help, I have used the utl_file package, I was just after a very simple way to give feedback to the users as each task finshed and the next started. i.e. Updating xxxx records etc rather than them sitting there with a blank screen. I kind if guessed that it worked like Sem...

I have a package that is essentially a tool that performs a number of operations on a schema. Within this package I use the dbms_output.put_line function write back to the user the progress of the operations. The problem is the output only appears when the whole procedure has finshed, not very...

I have a package that is essentially a tool that performs a number of operations on a schema. Within this package I use the dbms_output.put_line function write back to the user the progress of the operations. The problem is the output only appears when the whole procedure has finshed, not very...

Hi, Thanks to both of you, I was trying something similar to Allan just seem to be having one of those days! I wasn't aware of the merge command, wish I was. Just finished writing a tool to combine multiple schemas into one..... that command looks like I could of saved a bit of time...

Hi, I know this should be basic SQL but have been struggling on this one! I have two identical tables T1 and T2 with two fields which are composite primary keys. If I wish to insert only records from T2 into T1 that don't already exist in T1 how can I do it? e.g. T1...

Thankyou very much for a detailed example. Regards Gareth

Thanks.... I think I know what you mean but can't quite get it to wrk any chance of a little example? Thankyou in advance.. Gareth

I have a table I have inherited similar in structure to the following Columns ID Varchar2(20) lower_timevalue 1 NUMBER lower_timevalue 2 NUMBER ........ lower_timevalue 24 NUMBER middle_timevalue 1 NUMBER middle_timevalue 2 NUMBER ........ middle_timevalue 24 NUMBER upper_timevalue 1 NUMBER...

Hi Dima, Below is a copy of the execution plan and the optimizer mode is choose. The area_id will return several records from the met_direct table each with a unique spid, this field then realates to the readings table. The query returns the last date when a reading for all spids listed in the...

Hello All, This is an example of a query I am opening as ref_cursor in a stored procedure that runs on an Oracle 9i box. the structure of the tables are; readings (approx >100 million records, index spid,dateofread) spid varchar2 dateofread date value NUMBER edval varchar2 met_driect...