Search results for query: *

i must be going mad today cause i cant even do the simplest of sql! i have a table called z308. This table looks like this: Z308_REC_KEY---------------------- CHAR(22) Z308_VERIFICATION--------------- VARCHAR2(20) Z308_VERIFICATION_TYPE------- CHAR(2) Z308_ID------------------------------...

OK, I no practically nothing about scripting in Bash so I need some help. I want to place a job in the Cron that emails me if the following criteria are met: a file(s) of format z_u_* is found in directory X where X is the directory created the day previously [e.g. today directory would be...

I need to create a file rename script to run at a particular time. Part of the script must rename all files in the current directory that have *.let.* extension. For example I may have letter1.let.rdr form3.let.bib sqloutput.let.tlc and I want to rename them to: z_letter1.let.mon...

Is it possible to distribute an excel spreadsheet on the web [i.e. so people can download it] and set it such that they cannot edit the spreadsheet in any way. As with downloads, the file permissions would be accessable to whoever downloads it. I do not wish this. I want people to be able to...

I keep getting this statement at the end of my results of some sql. The query works fine until it tries to order the results. unknown command beginning "order by r..." - rest of line ignored. Currently I have: /* Column settings */ column clnum format a16 heading "Class...

I have a strange problem with my ADSL connection. On Saturday morning I tried connecting my modem/router with the new user/pass that was provided to me. It connected fine to my surprise, considering that my activation date is tomorrow [today in reality as BT activate the line and Nildram tell...

Last night our Sun Solaris server backup failed. Backup data is sent to a tape drive everynight. I looked at the logs today (/var/adm/messages) and I have this: Sep 12 00:17:50 mint unix: WARNING: ID[SUNWpd.glm.parity_check.6010] Sep 12 00:17:50 mint unix: WARNING: /pci@1f,4000/scsi@3,1...

On my Solaris box i have a job list (like the cron) that calls certain scripts at certain times. For example: c_r_107 is called form my job list like this: W1 09:06:00 Y CCC50 c_r_107 The rest of the line is irrelevant (local settings etc) but you can see the call simple enough. The...

I have the following code: I have the question at the end of code. It is well commented so should be eay to follow. Dim cellrng As Range For Each cellrng In Range("A:A") checkdata = cellrng.Value If Not IsEmpty(checkdata) Then 'Check that the data is not already in sheet1...

I am about to write a program to do the following: I have two spreadsheets (sheet1 and sheet2) and I wish to copy data from sheet2 to sheet1 only if it does not already exist in sheet1. Open Sheet2 For each row in Sheet2 Check row has data; Check row is not already present...

I have 2 spreadsheets. Both have the same columns except for an additional 2 columns of data on spreadheet 1. I want to import the data that is in spreadsheet 2 into spreadsheet 1 and add default values into the two extra colmns. for example I may have:- spreadsheet 1: name address...

I have 2 spreadsheets. Both have the same columns except for an additional 2 columns of data on spreadheet 1. I want to import the data that is in spreadsheet 2 into spreadsheet 1 and add default values into the two extra colmns. for example I may have:- spreadsheet 1: name address...

I need some helpwith Oracle. Perhaps this is the wrong forum but you can point me in the right direction if I'm worng. I am new to Oracle and I have been using it for my SQL for about a year now. However it has come to me that I must play more of an Oracle Admin role. The database I use at work...

I frequently create reports by spooling to a txt file creating long lists up to thousands of lines long. When I spool to a file all the lines are double spaced. For example: 001.4222 HAG 3604373822 001.4222 MAI 3604350213 but I want 001.4222 HAG 3604373822 001.4222 MAI...

I have a spreadsheet that is produced once a month with the same setup each time. For example I have the columns Name, Address, Fines and Action Taken. Every month there is a new spreadsheet but some data overlaps both months. So for example I have some peoples details appearing in more than...

I have a script that I need to decifer... #!/bin/csh set the_mon_day = `date '+%m-%d'` set date_fields=`date` set dayofweek = $date_fields[1] cd /aleph/u52_5/ccc50/print/ cp * /aleph/u52_5/alephe/ccc/print set the_dir = `find . -name "save*" -type d | grep $the_mon_day` cd $the_dir mv...

Im not sure where to post this but here is the closest match I can find. I would like somebody to explain the DECODE function within pl/sql. I have some queries passed on to me by a former employee and I have to continue where he left off. To me the use of decode seems to be very complicated...

I do lack the experience of SQL programming so it may be an easy question for the xperts to answer :) I have a query that is returning a list and I want to use the group by clause. However I cannot get it to work. I get error messages saying that it is incorrectly formatted or does not...

I am in the midst of major cleanouts of my database - using a total of 12 queries to get rid of specific data ensuring accurate copies are made. I have the following query that I want to improve so that they run faster. At the moment the following query takes 40 minutes to run. Ideally I would...

i have a problem with my database settings. i choose the option to compress the database when i close it. with this setting enabled it asks me for the database password when i close the database. i would like to stop this passowrd request as the user already enters this passowrd to enter the...