Search results for query: *

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...

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, 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 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 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, 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 Gurus, Can someone help me here. I have a file with following entry and need to print the lines not starting with a space or # using perl. Network 1 75.26.2.20 87.34.9.23 #73.90.23.12 Network 2 75.26.2.22 87.34.9.21 #73.90.23.11 I need the output as Network 1 75.26.2.20 Network 2...

Hi, I need to remove the newline character for certain lines of a file. There is a word to be searched on these lines. Ex: Input file Network 10.1.028 2.2067 Placeholder 10.27.96 90.24.87 10.0.1 Network 10.2.028 2.2077 Placeholder 10.27.92 90.22.87 10.0.10 Output Network 10.1.028 2.2067...

Hi Gurus, I have a MySQL database and it has one table with a date field and the format is as below '1212246855000'. How could I convert it to a valid mm/dd/yyyy hh:mi:ss format? Thanks, dbadmin

Hi Gurus, I have installed Windows XP Professional Service Pack2 on my Toshiba Satellite Laptop. After the installation on my screen about an inch on the right hand side is blank (as a strip). The remaining part is perfectly OK but it is really annoying. Anyone has similar issue? Any idea how...

Hi, I have multiple folders and sub folders from which I need to extract all files with extension .log. Is there any command which could be used on command prompt to do that? Thanks in advance, dbadmin

Hi Gurus, I have a text file and need to print the lines before a regular expression and then delete them. I have the following sed oneliner which prints the lines after the regular expression. Please help me in modifying the same to achive the above. cat test.lst | sed -n '/regexp/,$p'...

Hi, I am writing a java script which needs to read from a text file and display a date (format mm/dd/yy) in html. Is it achievable? Thanks, dbadmin

Hi, I have a VBA which connects to an Oracle database. The link table which I created shows certain columns as deleted but actually the columns exists in the database's schema. I have tried dropping and recreating this link table but of no use. Any one please help me... Thanks, dbadmin

Hi Gurus, This issue is eating my brain, but nothing seems to solve the problem. This is what I have and I did. I have two HP-UX machines and one had Oracle 8i (8.1.7) installed with 4 databases running on it. I can do startup/shutdown etc on this machine without any issues. Instead of...

Hi, I am in the process of compressing some files regularly under a certain folder. I want to use pkzip utility to achive this. I did write the script to just cd to the folder and run pkzip with a wildcard ("*"). Is there any way I could do a "find" on the folder and loop through that and run...

Hi, I am trying this for some time now, and could not get to resolve this. Some one of you may be able to help me. I have a text file with about 2000 lines. The file is of format as below Book1 ..... ..... ..... Price1:10:00 ..... ..... ..... ..... Book2 ..... ..... Price1:10:50 ..... ...

Hi, I have a laptop which I use in the Office and at home. At home, I have a Proview 17" flat panel monitor. When I connect the laptop at Office, it automatically sets the resolution accordingly (already set by me), but at home, I need to update the driver always when I need to have the desired...