Dear DBAs,

Is there a function that compresses and eliminate unwanted characters or
need to write a function that does the following.

Table: name

Column: table_name

Contents of column table_name

Pop XML Inc.
Pop ABCD
Pop XYZ Inc.

Etc.


Goal is to create a .csv file with the table_name prefixed without space
and period such that the result will look like this


PopXMLInc.csv
PopABCD.csv
PopXYZInc.csv


Thanks,
Ferdinand


Oracle LazyDBA home page