Search results for query: *

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?

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

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...

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...

Does anyone know a simple way to get this delete statement to work? SQL> DELETE 2 FROM Z 3 WHERE SSN||VENDORID = (SELECT SSN||VENDORID 4 FROM F) 5 / WHERE SSN||VENDORID = (SELECT SSN||VENDORID * ERROR at line 3: ORA-01427: single-row subquery returns more...

Desired output: Doe, John E 1234567891234567 Yes Doe, Johnnie R 1234567891234567 No Im trying to look up/loop to see it the credit card number in table_A can be found in table_B -- If I can find the credit card nubmer then Yes otherwise No DECLARE...

Does anyone know if "Hidden" and "Visible" are reserved words in Oracle 9I?

Does anyone have a scrip that will provide the before and after results of an update statement?

Does anyone know of a backway into access that i can use to delete the current password.

Does anyone have an ideal how to do get this to work? SELECT ACCT_STRING,LASTNAME, FIRSTNAME FROM zeg_user_def_string where ((STN > '300' and stn < '500') AND rpad(SUBSTR(ACCT_STRING,20,6),6,' ')||rpad(SUBSTR(ACCT_STRING,16,2),4,' ')||rpad(SUBSTR(ACCT_STRING,31,4),4,' ') NOT IN ('0129A140 04...

What happens to the leading or trailing spaces when you concatenation two fields?

Does anyone have a nested if script that they can provide as an example? Im trying to do nested if one column.

Does anyone have a script to search for lowercase letters in a sting?

Has anyone tryied to backup an oracla db using Window scheduler? I have oracle installed on Windows XP.

This one will make you laugh and me cry! Well lets begin - I am now receiving and ORA-1033 Error. I know why this is happening. This is because I can connect to the database which is on an external drive. Anyway here is where it gets interesting -- I physically dropped the hard drive...

Has any tried to use a lookup function within a vlookup functions?

Does anyone know the syntax or code that will count characters and not spaces? i.e &quot;t w&quot; should = 2 length = 3

How do you stop printing the same record over again when spooling the output? I would just like to see the first record of the like records only.

I have viewed a text file using textpad and all of the columns line up. Nevertheless, after doing an import of the text file into Access the position of the previous lined up columns have shifted. Does anyone have any ideas why this is happending? I tried the import specifications and the...