Results 1 to 2 of 2

Thread: deletion

  1. #1
    Join Date
    Sep 2011
    Location
    Hyderabad
    Posts
    18

    Unanswered: deletion

    how to delete duplicate rows show me with example.


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

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    Quote Originally Posted by vithalreddy View Post
    how to delete duplicate rows show me with example.
    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
    Quote Originally Posted by vithalreddy View Post
    why length(date),vsize(date) returning different values?
    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/
    Quote Originally Posted by vithalreddy View Post
    how the date is storing internally?
    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).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •