• Home
• FAQ

Code.TechInterviews.com

ready-to-eat, hot-off-the-presses source code for your visual and intellectual pleasure

Uncategorized

Perl script that e-mails new sites popping up in Yahoo! Search

Sunday, March 12th, 2006

This script checks Yahoo! Search to find out if any new sites appeared in the top results for the keywords you’re interested in.

• Submit your code

• Oracle: list of the system events
• Oracle: list of the running transactions
• Oracle: sql types
• Oracle: wait statisics by block class
• Using the clipboard in WSH
• Oracle: check the existance of logon/logoff triggers
• Unix shell: workaround for loop problem
• JavaScript: edit web page in browser
• Oracle: redo log switches by date
• JavaScript: Soundex implementation
• Dynamic image resizing in PHP
• Oracle: usage of the tablespaces (permanent and temporary)
• AppleScript: rotate mov file in QuickTime Pro
• Oracle: plan of the running query
• Oracle: using DBMS_METADATA for getting table structure
• Oracle: using substitution variables in sqlplus
• Oracle: disable all constraints referencing the table
• Oracle: info about the corrupted block
• Spiraling quine in Perl
• Oracle: using recycling bin
• mysql: rownum functionality
• Oracle: source text for the view, package etc
• mySQL: size of the database
• Office: check if PowerPoint is running
• WMI: list of the methods and properties
• Oracle: flashback usage
• WMI: get the information about the system
• Oracle: information about ASM
• Oracle: file needs recovery (offline mode)
• WMI+VBS: how to get the domain name
• MS Word: replace spaces to non-breaking
• MS SQL & Sybase: recreate master database
• C++: change the cursor for one button only
• Check the default browser
• Oracle: logon trigger
• Oracle: password function
• MS SQL: long running queries
• Oracle: long running queries
• Oracle: PERFSTAT.STATS$MUTEX_SLEEP_PK violated
• Oracle: read the entries from alert log
• Oracle: export/import using compressed file
• Oracle: export as sysdba
• WHERE command for DOS
• Oracle: convert LONG to VARCHAR2
• Oracle: recreate database links
• Template for proxy auto-config file
• Oracle: grant permissions to the whole schema
• JavaScript: build table dynamically
• MySQL: start SQL from shell script
• PHP imagefilter without GD
• Unix: get the file date
• Oracle: text of the running SQL queries
• Recursive quicksort
• Nice CSS tab menu with PHP
• A vertical menu done in CSS
• CSS message quoting
• Oracle: transpose data table (rows into columns)
• Oracle: find dependent objects
• List the tablespaces in backup mode
• Write to the alert log from PL/SQL code
• Fading alerts in JavaScript
• Find the square root of a number with any precision
• Measuring the speed of MySQL replication
• Quick calculation of the row count
• Creation and using of Sybase DBCCDB database
• Simple JDBC address book in Java
• Bucket sort in C++
• Download manager in Java
• Calculating the date of Easter
• Automatic MySQL backup script
• Code for adding the project to bookmarks
• Perl script that e-mails new sites popping up in Yahoo! Search
• Find actual device numbers in Sybase
• Redirect script output to the log
• Setting password for Oracle listener in the script
• Apache rewrite rules for hosting multiple domains
• Usage of the temp tablespace in Oracle
• Yahoo! Maps API in VB.Net
• grep in find command: how to display file names
• Using pattern lists in Unix
• Rewind caret in a non-empty <textarea>
• Blocking certain sites from hotlinking images via mod_rewrite
• Displaying another image when someone hotlinks
• Preventing hotlinking images from any domain except Yahoo! Image Search and Google Images
• Print the PATH directories in the readable format
• Find the Oracle object by name
• MD5 function for encrypting a string in VB.NET
• HTTP POST request with PHP CURL
• Find the files not in use in Unix
• Process all databases in Sybase
• Print current Oracle character set
• Start sqlplus in Windows .BAT script
• XSLT to trim the string
• XSLT to trim the string to the last character
• XSLT to strip HTML
• XSLT to remove the first word of the string
• XSLT to replace substring
• XSLT to escape single quotes and double quotes
• XSLT to strip HTML tags
• XSLT to get the possessive of a noun
• Invalid objects in Oracle DB (health check)
• Search for Oracle errors in the alert log
• Converting timestamp to char
• Manupulating Oracle LDAP entries
• Paranoid E-mail validation in PHP: check that MX is alive
• E-mail validation in PHP: check IANA TLD
• RFC-(2)822/(2)821 compliant e-mail validation in PHP
• Parsing script parameters
• Truncate time part of datetime/smalldatetime value
• Read password in Unix shell
• Show hidden parameters in Oracle
• Sybase sp_freedevice procedure
• Sybase simplified sp_who procedure
• Rev function and comma-separated output
• Oracle: Renaming system-generated NOT NULL constraint names to intelligible ones
• MySQL 5.x: passing limits as stored procedure / function paramters
• Mouse handling with DOS functions in C++
• Connecting to MySQL database via PHP PEAR DB

Topics

• ajax
• apache
• AppleScript
• awk
• backup
• browser
• bsd
• C++
• character set
• clipboard
• connect
  • login
• conversion
  • type conversion
• copy
• css
• Curl
• cursor
• database
• date
• dbcc
• delete
• device
• dos
  • bat
• email
• error
• expect
• export/import
• find
• grep
• Hashing
• hotlink
• html
• internal
• Java
• javascript
• LDAP
• linux
• log
• mod_rewrite
• mouse
• MS Office
• MS SQL
• MySQL
• Oracle
• output
• parameter
• password
• pear
• performance
• perl
• PHP
• proxy
• quine
• regular expression
• replace
• restore
• reverse
• rowcount
• size
• space
• sqlplus
• statistics
  • perfstat
• Sybase
• T-SQL
• tablespace
• temp
• text
• timestamp
• transaction
• trigger
• Uncategorized
• Unix Shell
• validation
• VB
• VB.NET
• video
• web 2.0
• Windows
• Windows scripts
• WMI
• XSLT

RSS | Register | Log in