Search results for query: *

Not sure if I understand you fully. Are you creating a delimited file for excel (with semicolons as the delimiter)? Using the || you only have one column! If so could try:- SET PAGESIZE 10000 SET LINESIZE 200 spool h1.txt --spool h1.xls COLUMN colname heading...

Your original UPDATE statement will update the column management_area_code with the result of your select from new_allocs but any other records (the ones that didn't match) in your property table will have this column updated with NULL. Remember you have no WHERE clause in your UPDATE statement...

This is a common problem in unix/windows/dos environments. The simplest way to fix this is to run the unix2dos command in unix(linux) on your text file which will do the conversion for you. There is also dos2unix for the reverse. The unix2dos command adds a CR whenever it encounters a LF...

Another good idea would be to add an exception section to get a better error message, something like:- EXCEPTION WHEN UTL_FILE.INVALID_PATH then UTL_FILE.FCLOSE(fin); dbms_output.put_line('Invalid path for the file'); WHEN UTL_FILE.INVALID_MODE then UTL_FILE.FCLOSE(fin)...

Could write a unix script - something like the following. This could be set to run in the cron every day first thing. It will then sit in memory checking for files every minute then exit at 12:59. This uses the korn shell. The commands will be different if you use the c shell etc. # Script to...

Just use the nvl (null value) function eg nvl(fin1,0) This would treat any null in the field fin1 as 0 This could be used like this:- select nvl(fin1,0), nvl(fin2,0), nvl(fin1,0) + nvl(fin2,0) as total from mytable; to give:- fin1 fin2 total 0 1200 1200 etc.

Thanks Sem You are of course correct. Missed that particular property. Did think that it must be a common requirement!

I have a form with a multi-record block. I want to highlight a record if it is the current record eg if the user clicks on the record with the mouse or uses "next record" etc. I can do this thru a when-new-record-instance trigger and the display_item built in BUT how do I switch the...