1
  • Bulk Collect vs Cursor in Oracle

    Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...

    Nikhildhar35 pointsBadges:
  • Powershell, loop through two different arrays?

    Helllo, What I am trying to accomplish is reading in two separate text files and going through them 1 by 1. Say text file 1 is computer names and text file 2 is ABCDEFG (the alphabet) In the script i'm trying to access a remote computer(s) (According to the text file 1) and access a text file on...

    bradob160 pointsBadges:
  • For Do rename loop

    Would anyone know of a createive way to change the following to represent a "do ren" loop and cleanup some of the un-needed syntax? for /f "tokens=1-9 delims=/ " %%d in ("%date%") do ren "A B C *.xlsx" "A B C %%e %%f %%g.xlsx" for /f "tokens=1-9 delims=/ " %%d in ("%date%") do ren "D E F *.xlsx" "D...

    ConFlicker210 pointsBadges:
  • Loop is seen on router but line protocol is down

    Loop is seen on router but line protocol is down, where could be the issue?

    Rohanpatil8885 pointsBadges:
  • Looping Ping

    Could someone please help me with this command to loop through the IPlist table and report results. It doesn't seem to be looping properly at this time. Thank you. :: "Set Variables" for /f "tokens=*" %%I in (IPlist.txt) do @Set $IP=%%I @Set OutputFile=PingResults.log :: "Set Time stamp" @FOR /F...

    ConFlicker210 pointsBadges:
  • Creation of array for input of data

    Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ';'. There would be a maximum number of 10...

    Rponsford15 pointsBadges:
  • Looping to create new workbooks using a set “transaction” number

    I'm playing around a bit and can't figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 - 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when ".SaveAs Filename:=Start" comes back...

    McNitro255 pointsBadges:
  • DO…LOOP and IF ELSE THEN statements

    I am writing a basic program where two types of data are added: 1. a salespersons ID and 2. an amount of cars sold within a month from that salesperson. I have found out how to set the code where the numbers will go where they need to, but adding extra ones does not work, and trying to add any more...

    Norphes5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following