how to delete duplicate rows show me with example.


why length(date),vsize(date) returning different values?
how the date is storing internally?

Are you really unable to use any web search engine?
http://www.orafaq.com/faq/how_does_o...s_from_a_table
http://asktom.oracle.com/pls/asktom/...15258974323143
Because they accept different parameter types and have different functionality. For their description, please consult SQL Language Referennce Guide for your Oracle version. It is available with other Oracle documentation books e.g. online on http://tahiti.oracle.com/
Use DUMP function. It is also described in SQL Language Reference. Anyway, it will be useless as you will not be able to enter it (yes, there is one way, but if you do not know about it, you definitely do not need it).