I have million records and i want to delete 10000 records each time....how to do that?
I have written the following query for that
loopcount=ceil (1000000/10000)
while (i<loopcount)
{
delete from table where =(every time i need to delete 10000 records)
commit;
i=i+1;
}
I am confused what to write in the where clause so that in every while statement 10000 records are...
RaviRajhulk
Last Activity: Sep 2 '10, 08:33 AM
Joined: Feb 20 '08
Location:
-
How to delete constant no. of records
-
what does count(1) do?
If there is a code like
SELECT count(1) from TABLE Where condition1=cond ition2;
Is count(1) same as count(*)?
Does count(1) counts the first column of the table? -
To delete first few letters in a string in a file
I have got a file called filelist with content
[code=text]
f+ f templatedata\po c\Ravi\Appfolde r\filelist.xml
f+ f templatedata\po c\Ravi\Appfolde r\testdeploy.xm l
f - templatedata\po c\Ravi\Appfolde r\testdeploy2.x ml
f - templatedata\po c\Ravi\Webfolde r\apples.bmp
[/code]
I need to remove the first few characters in the begining and need to have only
[code=text]
templatedata\po c\Ravi\Appfolde r\filelist.xml... -
RaviRajhulk replied to To test the pattern whether it is.jpg or .xml by comparing with the extensionin PerlAfter executing the code ,the Appfile and webfile are created but they remain empty.The data in the common file are
a.html
b.html
falls.html
html\test.html
templatedata\ca tegory4
templatedata\Li brary
templatedata\Ni k
templatedata\Pa ge
templatedata\po c
templatedata\zz _tst_sakina_mun shi_1_manifest
Test1.html
folwer.jpg
I need to write the html file to... -
RaviRajhulk replied to To test the pattern whether it is.jpg or .xml by comparing with the extensionin PerlThis is not working.help plz...Leave a comment:
-
RaviRajhulk started a topic To test the pattern whether it is.jpg or .xml by comparing with the extensionin PerlTo test the pattern whether it is.jpg or .xml by comparing with the extension
I need to write the image files in one file and (the xml and html) in another file from a common file. I am trying to compare the extensions,like if it is .jpg or .bmp it will be written to the image file and if it is .html or .xml it will be written to the app file.But I am not able to do so.My code is given below
[code=perl]
open (MyFileHandle," <C\:\\home\\com monfilelist.txt ");
open (MyWebFileHandl e,">$imagefile" )... -
To read the full subfolder path and write the path into textfile
I am trying to read folder and subfolder and print their name into a text file.I am able to read the folder and its content and write it to the textfile but I am not able to read the content of the subfolder and write its content..FOR Eg : I have
folder1\text1
folder1\text2
folder1\folder2 \text3
I am reading folder1 and it is writing text1,text2 and folder2 in another textfile.I need to print the total structure of the... -
RaviRajhulk started a topic To raise some error message when there is error in any batch file called from a perlin PerlTo raise some error message when there is error in any batch file called from a perl
I am trying to execute a batch file from a perl code and its executing fine with the folowing code
Code: ( text )
`C:\temp\sample .bat`
,but another problem is occuring.....wh en there is some error in the .bat file(sample.bat ) the perl should not execute it,and should throw some error message,but in case of error in the .bat file also,it is executing...... ..Is there any way to capture in the perl code that if there is... -
Its executing fine now with
,but another problem is occuring.....wh en there is some error in the .bat file(sample.bat ) the perl should not execute it,and should throw some error message,but in case of error in the .bat file also,it is executing...... ..Is there any way to capture in the perl code that if there is some error in the sample.bat file then it should throw some error message and should not excute...Code:`C:\temp\sample.bat`
Leave a comment:
-
Executing a batch file(.bat) from a perl code
I have tried executing executing a batch file from a perl code using
system("start c:\\temp\\sampl e.bat")
but it is not executing ,Is there any way to execute batch file from a perl code -
How to Call a Batch file for execution from a perl script
I need to call a batch file for execution through the perl script.pz help -
How to execute the perl code after an interval
I need to execute the perl code after a delay of say an minute.. and i need to write to do this in the perl code itself....Plz help
No activity results to display
Leave a comment: