I've got some fields in an oracle table where the internal format
is date. I'm currently using a select * type query to return
all the colums of the table (36), and the date fields come back
as 'MM/DD/YYYY'.
I could enumerate every column and for each data field do
a select to_char(field,'MM/DD/YYYY HH24:MI:SS'), but that
seems rather tedious and I was thinking there must be a better
way. Is there some way to do the equivalent of an alter system
to set the NLS_DATE_FORMAT for retrieving date fields?
Doug
