Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: get supported data type from oracle

    how i can retrieve those supported data type from oracle 9.0.2, include sdo_geometry. Does any table or view contains these information, or how i can get them.

    or brief, how many data types does oracle supported?

    thanks advance

    waiting online

  2. #2
    Join Date
    Jan 2004
    Location
    Germantown, MD
    Posts
    34
    Try:

    SELECT owner, type_name
    FROM all_types;

    -Rip
    "The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
    - Albert Einstein

  3. #3
    Join Date
    Apr 2004
    Posts
    3

    Thumbs up this is the right one!!!

    thank you

    i got what i needed.

    thank you again.

    justin

Posting Permissions

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