Recent content by acct98

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.