|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Delete line in file based on data in another file | earth_goddess | Shell Programming and Scripting | 1 | 12-29-2008 10:47 AM |
| Truncating FILE data BASED ON A PATTERN | pkumar3 | Shell Programming and Scripting | 1 | 10-14-2008 12:49 PM |
| Rename file based on first 3 characters of data in file | jchappel | UNIX for Dummies Questions & Answers | 3 | 10-01-2008 03:21 PM |
| Extracting data from text file based on configuration set in config file | suparnbector | Shell Programming and Scripting | 3 | 08-10-2007 03:25 AM |
| Select a portion of file based on query | vanand420 | Shell Programming and Scripting | 14 | 10-31-2006 04:48 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
06-26-2009
|
||||
|
||||
How do I use SQL to query based off file data?
This is basically what I want to do:
I have a file that contains single lines of IDs. I want to query the oracle database using these IDs to get a count of which ones match a certain condition. the basic idea is: cat myfile | while read id do $id in select count(PC.ptcpnt_id) from ptcpnt_cmpsit PC where PC.gndr_type = 'F' ; done Hopefully, you get the gist. |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
