Search results for query: *

Hello, I have a cursor that have the following data that I select from a table: Phone_number Event_Id 123 1 123 2 123 3 123 4 What I want to do is to increase a number in the event id every time he does...

Hello, I have an excel workbook with 3 sheets. In the first one, I have listed all the requests that were made to me. And one of the column of sheet 1 has the status (Made, Pending). The second have the subset of requests that are already done and the third sheet has the requests that are still...

Hello, We have DataStage 7.5.3 installed on an HP/UX machine. Our database was an oracle 9i instance. Last week we bought a new DB server. It's an Oracle RAC with 10G Version. When we were running some test we found two diferent problems: 1) Our dsx server had oracle client 9.2.2 and then...

I have a select query script that runs fine. I am trying to create a mview with it but when I try to create the view,it runs and runs and never creates the view; I have to cancel. I let it run for an hour without success, the actual select query takes about 5 minutes. If I use the select in a...

Hello, In 9i I had a procedure that opens a cursor with a select with union all inside. Then, the values of the cursor are inserted into a table and it gives a commit each 10000 rows. After upgrading to 10g, the procedure that used to take about 1min to run, takes over an hour. Could you...