Find duplicate rows SELECT A.field FROM YOURTABLENAME A WHERE rowid > (SELECT min(rowid) FROM YOURTABLENAME B WHERE B.field = A.field ); remove duplicate rows: DELETE FROM YOURTABLENAME WHERE rowid in (SELECT rowid FROM (SELECT rowid, row_number() over (partition by key …
check for email pattern if( !preg_match( “/^( ([^()[\]\\\\.,;:\s@\”]+(\.[^()[\]\\\\.,;:\s@\”]+)*)| (\”([^\”\\\\\r]|(\\\\[\w\W]))*\”))@((\[([0-9]{1,3}\.){3}[0-9]{1,3}\])| (([a-z\-0-9áàäçéèêñóòôöüæøå]+\.)+[a-z]{2,}))$/i”, $email ) ) { $msg = ‘Email address was not recognized as a valid email pattern’; } get the mx host name $domain = preg_replace( “/^[\w\W]*@([^@]*)$/i”, “$1”, $email ); Validate …
mp3-BAZAR (موزيک بازار) موزيک ويدئو جورواجور هرچي كه بخواهي همه در موزيک بازار – اديتور به فارسي و لاتين – Html – فارسی نويس فارسی نويس بدون نياز به کيبرد فارسي ويندوز – تقويم ساليانه شمسي و قمري و …
SSL & Serverzertifikat Debian Package Solaris Package remove all lines from the file d.dat: perl -p -i.bak -e ’s#^\*X-something.*\n$##g’ d.dat perl -p -n -i.bak -e ’s/^\*X-pol.*\n$//g’ file.in perl -p -n -i.bak -e ’s/\r\n/\n/’ file.in awk ‘{print $3}’ $filename installing a …
debugger for hash variable require Data::Dumper; print STDERR “Line ” . __LINE__ . “, File: ” . __FILE__ . “\n” . Data::Dumper->new([$columns, \@fields],[qw(columns fields)])->Indent(1)->Useqq(1)->Dump; require Data::Dumper; print STDERR “Line” . __LINE__ . “, File: ” . __FILE__ . Data::Dumper->new([$applConfigHash],[qw(columns)])->Indent(1)->Useqq(1)->Dump; Cached …
An introduction to building a Web Service: A Web service consists of a network-accessible service with a formal description of how to connect to and use the service. The language for formal description of a Web service is XML and …
The best ways to run all files from a folder in SqlPLus Create a file and store all of the file names from the folder: ls -l > list.sql Edit and set @ before each file name vi list.sql 1,$s/^/@/ …