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 Wanet Telecoms Ltd 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. stewartdwest

    Generator for Test Star Schema

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

    External Table FIELDS TERMINATED BY X'2c'

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

    Self Contained ksh script for SQL PLUS

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

    Cut with signed value for delimiter

    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"

Part and Inventory Search

Back
Top