Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Unix or perl script
Name: jeff Date: October 8, 2003 at 10:11:16 Pacific OS: windows 2000 CPU/Ram: pentium 4 2.20ghz
Comment:
I wanted to know if it's possible to create a script that runs 5 seperate SQL queries using a date function as input to the queries. Presently I have 5 sql queries I run in the morning can get yesterday's numbers (sysdate - 1 day). Then in the afternoon I run another 5 sql queries to get present day numbers (sysdate). The sqls that I run in the morning are identical with the ones I run in the afternoon the only difference is the date parameter.
Name: nick Date: October 9, 2003 at 07:10:44 Pacific
Reply:
its very possible to do that. however, to give you specific details on howto, would mean i would need more details on what you are tryingto do(eg where the output goes, where the input comes from), and maybe the sql queries.
0
Response Number 2
Name: WilliamRobertson Date: October 12, 2003 at 12:03:10 Pacific
Summary: I want to implement the Group BY function of Oracle in Unix to find sum of amount for certain key fields using Unix or Perl script. The file is sorted file Sumit Bagla...
Summary: Even though at home I have both a Solaris and Linux box, almost everything I do is on my Windows box (one of these days I'll get smart and reverse that). So, my unix skills are rusty and my shell sc...
Summary: In order to count words using unix tools other than wc, you'd probably have to write an awk or perl script. Without running tests, I can't be precise, but I don't think you can improve much on 'wc's ...
0 
