Search results for query: *

Hi, I've written a statement, which works fine but it is rather slow. Does anybody got a better idea? select * from ( select a.*, row_number() over (partition by row1, row2 order by row3 desc) as xxx from TABLE a where DATE <= to_date('01.01.2009'...

Hi, I've written a statement, which works fine but it is rather slow. Does anybody got a better idea? select * from ( select a.*, row_number() over(partition by row1, row2 order by row3 desc) as xxx from TABLE a where DATE <= to_date('01.01.2009', 'DD.MM.YYYY') and...

Quite possible I miss an obvious thing. I have taken a dump from a database with followoing options: compress=n direct=y rows=y indexes=y constraints=y grants=y triggers=y owner=xxx Enable row movement is enabled on every table. Importing the dump works fine, but Enable row movement is gone...

Hello everybody, since our database upgrade from 9i to 10g we have problems with a function. It works fine in 9i, but in 10g we got ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "AB.P_V_NUMBER". Following select is used: SELECT SUBSTR(DS,1,4) AS...

Hello to everybody. Following problem: Due to a error I got in a table duplicate and illogical entries. It's a table with staff members witch normally should show something like this: Storage_ID valid_from valid_to personnel_number .... 1 2006/07/07 2007/05/31 1234567...

Hi, some weeks ago we upgraded our Oracle Database from Version 8i to 10g (10.1.0.3.0). To do so, we used the migration tools from Oracle Since then we are experiencing a poor performance of our database. e.g. we've got one big table with 128 Billion entries. A "normal" query under Oracle 8i...

Hi, following problem: I want to correct emai-addresses in a column: Now: Scott.Tiger@anycompanyintheworld.com Should be: Scott.Tiger@anycompanyworld.com Any Ideas how to do this? Thx in advance Roland

Hi, following problem: There a two tables with differnt information: Table A: Txn-No. Account-No. Sub-Account-No. Amount Item-No. 10 12345 00001 2605 80001 15 12346 00001 2000...

Hi everybody, I've got following problem: In our company we receive an order information, which we fill in "Table 1" and an Invoice information, which we receive in "Table 2". In a view, information of both tables should be merged together. And here my problem begins: Example: Table 1...

Hi, I need some Advice. We have different Schemas in our Database. I've got a user with DBA-Privilege. Now I want to create a View in Schema A, using Tables from Schema A and Schema B. Above mentioned ErrorMessage occurs. Even creating a View in Schema A only with tables from Schema B will...

Hi everybody, following problem: How can i figure out, WHICH column causes the problem "inserted value too long". Any stupid Access Database will give you the information, which column causes this error, but not Oracle! Is there a tool/procedure or whatever available, which can do that in...

Hi, following problem: I need to update some rows in a table. All information, which colums are to be updated are in the table itself. For example, following statement does exactly, what I want: update basis_table set factor = ( select factor from basis_table where type = 'STK' and...

Hi everybody, I'm facing a problem, which I can't solve. Following situation: Table 1: The ID is the foreign key of ID in Table 2 Row ID Value 100 1 DE1234567 101 4 CN4567890 102 3 NL1346799 103 3 US7654321 104 5 FR7658902 Table 2: In this table, the ID is the primary key and unique. ID...

Hi all, following problem: Statement: select * from some_table where (A OR B) AND C AND D This statement was running 5 hours. In my opinion (A OR B) is causing this problem. select * from some_table where A AND C AND D OR B AND C AND D which is logically the same will...

Hi everybody, following problem: We have a test and production database (nothing unusual so far :-) ). For some reasons, changes in the test database were never documented and I never got any reports when changes were made. As I am responsible for the production database I have now the...