• Home
• FAQ

Code.TechInterviews.com

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

bsd

Find the files not in use in Unix

Friday, February 10th, 2006

find . -name “*” -exec /usr/sbin/fuser {} 2>&1 \; | grep ‘: *$’

• 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