Search code examples
oraclecachingoracle-coherence

A method to Extract Output of Oracle Coherence Cache (CohQl) into a flat file

Do we have any way to extract output of a query into a flat file, while working with CohQl, I know we have the way to do that with RDBMS databases. Something like in MySql

SELECT ... FROM ... WHERE ... 
INTO OUTFILE 'file.csv'
FIELDS TERMINATED BY ','

I just want it into a flat file, delimiter is not a preference, if I get a solutuion with a delimiter, well and good.

Solution

  • In unix we can do something like this

    ./query.sh -s -c -l "select * from 'cacheObject'" >>cacheObject.txt