Hi All,

 

My nls_date_format is dd-mm-rr

 

i want one schema's tables date format should be in mm-dd-yy. (rest is fine with dd-mm-rr).

 

is there a way todo this.

(apart from using alter session set nls_date_format='mm-dd-yy');

 

 

can someone help me  ?

 

Thanks,

RAj

---

Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.