devxlogo

Tip Bank

Another Way to Delete Files or Filetypes

This routine uses all the good stuff that FileSystemObject offers. Here it is: Public Sub DeleteFiles(ByVal strPath As String, ByVal strExtension As String) Dim fsoMain As Scripting.FileSystemObject Dim folToDeleteFrom As

Delete Duplicate Rows From an Oracle Table

It’s easy to introduce duplicate rows of data into Oracle tables by running a data load twice without the primary key or unique indexes created or enabled.Here’s how you remove

Another Way To Compare Strings

When comparing a string, you can use this: public class compareString{ public static void main(String[] args) { String stringToCompare =