Obtaining column type in OCI8

Discussion in 'Ruby' started by Sean Nakasone, Nov 7, 2007.

  1. Using the OCI8 module, how does one obtain the type of a column in a
    table? For example, how do we know if a column is a VARCHAR or a NUMBER?
     
    Sean Nakasone, Nov 7, 2007
    #1
    1. Advertisements

  2. Hi,

    On 11/8/07, Sean Nakasone <> wrote:
    > Using the OCI8 module, how does one obtain the type of a column in a
    > table? For example, how do we know if a column is a VARCHAR or a NUMBER?


    Column types of an existing table, or of a query?
    For the former, you can get the column types by querying
    USER_TAB_COLUMNS data dictionary.
    For the latter, you have no way now. It will be supported at the next release.
    http://rubyforge.org/forum/forum.php?thread_id=17986&forum_id=1078
     
    KUBO Takehiro, Nov 11, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. heyo
    Replies:
    3
    Views:
    1,340
    Dan Pop
    Apr 1, 2004
  2. pete
    Replies:
    4
    Views:
    1,010
    Dan Pop
    Apr 2, 2004
  3. Yevgen Muntyan

    #define ALLOCIT(Type) ((Type*) malloc (sizeof (Type)))

    Yevgen Muntyan, Feb 9, 2007, in forum: C Programming
    Replies:
    10
    Views:
    1,203
    Yevgen Muntyan
    Feb 13, 2007
  4. Rakesh
    Replies:
    4
    Views:
    4,034
  5. kj
    Replies:
    5
    Views:
    611
  6. Mrinalini Kulkarni
    Replies:
    0
    Views:
    275
    Mrinalini Kulkarni
    Dec 25, 2011
  7. Gennady Bystritsky
    Replies:
    2
    Views:
    306
    KUBO Takehiro
    Jan 18, 2006
  8. Sean Nakasone

    Obtaining column type in Oracle table

    Sean Nakasone, Nov 8, 2007, in forum: Perl Misc
    Replies:
    1
    Views:
    173
    Brian McCauley
    Nov 8, 2007
Loading...