Question: how to change date format in toad for oracle?
Answer: Nimish, ... 
In toad go to format change, the format as dd-mm-rrrr. ... 
Do the following steps to change the date format in TOAD. ... 
Go to View->Options->Data Grids->Data. ... 
Go to View->Options->Data Grids->Data. ... 
This is now in tools grids, but it is a useful tip. ... 
SELECT TO_CHAR(MYDATE,'DD-MM-RRRR') FROM TABLE NAME.