Recent content by dbadmin

Thank you so much. That fixed the problem dbadmin.

Hi, I am running into an issue which I cannot figure out. Any help from the experts is really appreciated. I have a view VIEW1 owned by USER1 which does some select statements against dba_users view owned by SYS. USER1 has granted select privileges on VIEW1 to a Role ROLE1. SYS granted...

Thank You!

Hi perl gurus, I am trying to format a file config.txt with the following sample data abc=11 abcdefgh=234 a=87 abc_cde=input khs_neo=230 I need an output as following with spaces/tabs before the "=" and a space after the "=" abc = 11 abcdefgh = 234 a = 87 abc_cde = input...

Hi, Thank You! That helped me. Thanks again for clarifying it. dbadmin

Hi, I have spreadsheet with 3 columns "Job", "Execution_Date", and "Elapsed_Time". I am trying to create a pivot chart with filter for Job (there are multiple jobs) and execution date on X axis and the Elapsed time on Y axis. But when I try to set this up, I can do it only with a...

Hi gurus, I need a command to search all files under a directory for a word "beat" and then print another line in the same file with the word "Elapsed" A typical file will have text like below Item1 bottle beat Elapsed:01:01:01 The command "find . -type f -print |xargs grep -i beat" will...

Hi, Thank You guys. dbadmin

Hi Gurus, I have a text file with about 200 lines. I need to search for a particular word "testing" and then add a character ":" at the end of those lines containing that word Thank you in advance, dbadmin

Hi Perl Gurus, I have a file with the following data. Test1 - Execution1 - 00:00:00.52 Test2 - Execution1 - 00:00:00.01 Test3 - Execution1 - 00:00:00.67 Test4 - Execution1 - 00:01:01.80 Test5 - Execution1 - 00:00:00.31 Test6 - Execution1 - 00:00:00.94 Test7 - Execution1 - 00:00:00.02 Test8 -...

Hi Annihilannic, That worked like a charm. I am not a programmer in perl, so I couldn't figure out what you exactly did. I couldn't reply you early because, I went on an emergency vacation. Any ways Thanks You! much. Just a small addition. Is it possible to print a "0" as below, if there is no...

Hi gurus, I am working on formatting data and create an html. The data is in text format as below 03/01/2010 29944 03/02/2010 3228 03/03/2010 496 03/04/2010 0 03/05/2010 985 03/06/2010 0 03/07/2010 0 03/08/2010 0 03/09/2010 0 03/01/2010 30000 03/02/2010 3228...

Hi PHV, Thanks for the quick reply. My specific question was how could I have the setenv comand spans multi line? If the same command is one line, it executes successfully. Actually my original setenv command is longer that the one I posted. SO I need the "\" escape character and that creates...

Hi, Hi, I am trying to set a long string as environment variable and getting this error, too many arguments. I am putting back slash for the new line escape. Any help is really appreciated. setenv PATH .:/opt/vendor/software/bin:/usr/ccs/bin:\...

Hi Feherke, Thank You! That works like a charm. regards, dbadmin