Search results for query: *

ID" "PATH" "SECURITY" 208 "importexport/exportusingtemplate/home.html" "22020002200**2****2*******************************" 210 "family/bulkchange.html" "000*000**00***************************************" 211 "importexport/quickimport/quickimport1.html"...

Hi, Andy. Yup, that's my goal F1 F2 F3 F4 F5 F6 ... F50 0 1 2 * 3 4 and, no, it's not normalized. It's a remnant from the original garage-born DB. Now the new publisher has carted it to Oracle. I can't see what routine they use to parse it out. But each column represents...

Hi, All. I have a field that contains single value data (in the form of 0. or 1. or2, or *). The field is 50-wide. Any way I can parse it out into separate columns, one value per column number 1 to 50? Thanks.

John, I starred your post. Nice idea, thanks. Santa, I'd like to build the procedures in the post you pointed to, but I am working with a proprietary interface that only allows writing to the DB through their GUI. We can extract via ODBC, nothing else. Very frustrating. Can't tell you how...

DUH. Was exporting to .csv with page headers.

school superintendent wants a policy where absences are escalated after five school days if a kid does not bring an excuse. Every date function I try will only count calendar days, not in-session school days. I can do this SELECT rownum rn, date_value FROM (SELECT Date_Value FROM...

I have one report that keeps erroring out with message "Not enough memory for operation" The report should export to a folder as csv file. I have about 80 others doing that or going to ftp. It's just this one, and it is not any bigger or more complex than the others. BOE 12.0. Server2003 on a...