Search results for query: *

Where can I download the source ddl and data generator to create and populate a star schema together with test queries? tpc-h is normalized and tpc-ds is not yet released. Would like to generate/populate about 1Tb

Happily creating/using Oracle External Tables Trouble starts when Setting the Access Parameters, specifically Fields Terminated X'2c' The STRING specification of the terminator works for "," and for ',' but rejects the hexadecimal notation X'2c' I've standardized on X'b8' for my...

I found the answer to my question, for those who like self contained ksh scripts for oracle A backslash cannot be used to escape a single quotation mark in a string that is set in single-quotation marks. An embedded quotation mark can be created by writing, for example: 'a'\''b', which yields...

This works great using cut with signed delimiters: DELIM=`echo "\0270"` cut -f 2 -d "$DELIM" myfile.txt -------------- The awk version is probably ok for smaller field counts, myfile.txt has 940 fields: awk -F"$DELIM" '{print $2}' myfile.txt awk: record...

From Unix Korn shell script creating and Oracle External Table. The unix file name is typically provided via the LOCATION('myfile.txt'). My script has the problem that oracle rejects it as LOCATION(myfile.txt). I need to preserve the quotes around the filename. The MYSQLCMD below would work...

Thanks for verifying that the Solaris 8 cut utility does not appear to support signed delimiters. I need a cut utility that can handle signed delimiters. The delimiter cannot be translated safely to unsigned values without mapping to existing data values. Also, the datasets are >10GB so...

cut -f 2 -d "," myfile.txt works great to cut the second column from a comma delimited text file. What would the syntax be for specifying a delimiter with the value x"b8" cut -f 2 -d x"b8" myfile.txt produces cut: "invalid delimiter"