Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. skunkmaster

    save sql results to excell file

    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...
  2. skunkmaster

    Update problem

    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...
  3. skunkmaster

    How to change linefeed created by UTL_FILE?

    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...
  4. skunkmaster

    PL/SQL: can't execute a simple file reading procedure

    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)...
  5. skunkmaster

    Automating SQL Loader Jobs Urgent!!!!

    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...
  6. skunkmaster

    Adding a Null Field with a numerical field

    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.
  7. skunkmaster

    Multi record block - highlighting record

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

    Multi record block - highlighting record

    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...

Part and Inventory Search

Back
Top