Search results for query: *

Its me again. Everything works fine. However, it taking too long to execute the query on a table containing 400K records. The query has been running for 3+ hours. Any ideas on how to speed it up? I know that that hard to do because no one is here but I just looking for a few ideas.

I not sure it the FOR loop will work with what I am trying to accomplish. I have one table: Test1 SSN VARCHAR2(9) VENDOR_NAME VARCHAR2(30) Is it possible to use you example to create the following?: SSN VENDOR_NAMES 123456789 DOE, JANE ~ SMITH, JANE ~ THOMAS, JANE

Dave, How did you the " batchCol4(col1,col2,col3) e " to work.

I created the function [No Errors]. However, no results are displayed. I set serveroutput on expecting the results to be displayed but nothing. Do I need to do a DBMS_output.put_line????

No errors. How do I get the following: Col1 Col2 Col3 Strung-together Col4 Values ----- ---- ---- -------------------------------------------------- 1 A YY Oracle,Siebel,Sybase 2 B ZZ Oracle,Siebel,Sybase,DB2,MySQL,SQL Server,Informix

SQL> CREATE OR REPLACE FUNCTION MANYNAMES(SSN VARCHAR2, VENDOR_NAME VARCHAR2) 2 RETURN VARCHAR2 3 IS 4 HOLD_STRING VARCHAR2(4000); 5 SEPARATOR VARCHAR2(2); 6 BEGIN 7 FOR R IN (select ssn, vendor_name 8 from vendors 9 where ssn like...

I tried Dave function but got the following error: Warning: Function created withe compilation errors How can I find the compilation errors?

I think if found the problem it lies inside a cobol dataset.

Is it possible to utilize and outer join with concatenated fields?

Carp, I tried your first suggestion but was unsuccessful. Could you please explain your statement: or you might try just ANDing all of the conditions together (with calls to NVL if NULLs are the root of the problem).

I'm have a question. When I execute the following script I get too many records. In the F887rpt table there is only 20,000 records. However when I run the script below 20,100 are selected. I was only expecting to get 20,000 records. Can someone please tell me why I am getting more than...

I had all my control files on a floppy and the floppy went bad. Anyway, Is there a log file in Oracle the maintains executed SQL Loader scripts?

This is what I was looking for. Thanks

Im not try to recreate the wheel. Does anyone have SQL code to create an aging report?

Thanks, I only need to use ... <> Nvl(credit_card,'Z')) to get it to work. It take 2.3 hours to run--Thats another issue.

I tried the following: AND ( (v_cardnumber_update <> credit_card) or (v_cardnumber_update is null) or (v_expire_update <> expire) or (v_expire_update is null)or (v_name_on_card_update <>name_on_card)or (v_name_on_card_update is null)...

I have yet another question. I can get the cursor (below) to work. However, if the field is null it will not update the record(s). Does anyone have any ideas on how to get the cursor to update the records whether it's null or not? DECLARE v_ssn_update...

Consider changing the fields that are rejecting to VARCHAR2. It does not appear that you will be doing any calculations on these fields.

I have two tables: TABLE A TABLE B SSN 123456789 SSN 123456789 NAME DOE, JOHN VNAME DOE,JOHN I would like to seleced all records from both tables where the SSN & NAME are the same. However, in the example above there is a space between the last name and first name in...

I took out the concatenation and used the "IN" in the delete statement. Thanks for your help.