Here is the script I often used to find the sql script using oracle trace utility for oracle applications forms, reports. Change the user id, password and database name to suit your environment. Download TKprof shell script #!/bin/sh #*********************************************** # Script Read More

This script provides an sample, and then the practical example to connect to oracle database, extract data like excel sheet and attach it with an email list. First connecting is done with “sqlplus -s $FCP_LOGIN” in silent mode.Then EOF marks the begining of sql statement and another Read More

One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance. One should do performance tuning for the following reasons: * The speed of Read More

Long back, around 2001, I download the script from http://www.gt.ed.net/keith/plsql/. This link is dead as of date. They are working plsql scripts that I have tested long back. Introduction MD4 and MD5 are one-way hashing algorithms designed to create compact, fixed-length (256 bit) digital Read More

The Luhn algorithm or Luhn formula, also known as the “modulus 10″ or “mod 10″ algorithm, is a simple checksum formula used to validate a variety of identification numbers, such as credit card numbers and Canadian Social Insurance Numbers. Recently, Oracle has stopped Read More

I am not the author of this plsql. Just reproduced from the source site. The original copyright and credit goes to the Author. Send e-mail messages and attachments from PL/SQL From Oracle8i release 8.1.6 one can send e-mail messages directly from PL/SQL using either the UTL_TCP or UTL_SMTP Read More

I am not the original creator of this plsql procedure. Just used this script three years before, and stored at my local computer. Unable to locate the source website. Hence, sharing it with you. The copyright and credit goes to the Read More

I had a question for the linux community. I’m new to linux and I’m loving it so far. However, I’ve been having a small problem recently, and I’m not sure how to fix it. When I log into the shell, I get the error INIT: Id “h1″ respawning too fast: disabled for 5 Read More

select gls.name, gps.closing_status from apps.GL_PERIOD_STATUSES gps, gl_sets_of_books gls where 1=1 and gps.start_date <= sysdate and gps.end_date >= sysdate and gps.set_of_books_id = gls.set_of_books_id and gps.set_of_books_id >= &Set_of_books_id and Read More

1) Recreate the passwordfile You can recreate the password file using the ORAPWDxx command by which you can specify the password for internal. Before running this command to create the new password file, make sure to delete the old password file. Otherwise, the ORAPWDxx utility will give an error Read More

Can anybody send me the Toad explain plan (notoad.sql) script to me. My toad explain plan is not working.? Here you go: Toad explain plan script TOAD allows you to easily see the explain plan for the currently executed SQL statement. This is visualized on the Explain Plan tab in the results Read More

————————————————————————- —    Author : Jayasankar Read More

Just run this sample sql changing the patch number (3061831) in sqlplus or Toad. select distinct rpad(a.bug_number,11)|| rpad(e.patch_name,11)||rpad(trunc(c.end_date),12) ||rpad(b.applied_flag,4) from ad_bugs a, ad_patch_run_bugs b, ad_patch_runs c, ad_patch_drivers d, ad_applied_patches e where Read More