Search results for query: *

Curious - why would you select having count(*) = 2? Since we need only the 1-to-1 records, shouldn't this be having count(*) = 1?

The database is Oracle 10g...

I have a table with two columns: id1, id2. There are 4 scenerios regarding these fields: 1) A id1 can map to multiple id2's 2) a id2 can map to multiple id1's 3) A id1 can map to one id2 4) a id2 can map to one id2. I want to create a table that contains all id1's and id2's that only match...

Simple question for the guru's... 2 tables: table_a – 8mm records table_b – 1mm records They each have the same table structure. I need to create a table with every row in table_a that is NOT in table_b. Since each row (all columns) acts as the “key” I’m selecting all fields concatenated...

I am trying to get the latest file from an ftp site that matches a pattern and is the latest one. The file name format is: foobar_5279_09-03-2008.log.gz I really need help with two things: 1) regular expression for file name pattern matching 2) logic to get the most recent file. Thanks much...

I have tool tip working, but I'd like to increase the time it is displayed. Is this possible in HTML? Thanks in advance!

I need to write a scoop in PERL that stores all directories (UNIX machine) as an array, then renames them to "pull_<dir_name>. The problem is, the working dirtectory contains both directories and files. How can I obtain a list of ONLY the directories? ls -lrt | grep ^d works, but it also...

I have 100 files in a directory. Roughly half of them are owned by one user and the other half are owned by another user. How can I use the chown command to move ownership of ALL these files to one of the two users? Thanks!!

I have an array that contains data that is returned from a SQL query. I'm then looping through the data to create an XML spreadsheet. The data returned from the SQL looks like this: table_name field_name value count order amt_paid A 500 order amt_paid...