Menu ▾ ▴

Know column type of a table

OCILIB general discussions (ReadOnly - Use GitHub tracker instead)
Josemi Antelo
2011-04-12
2012-09-26

  • Josemi Antelo

    Josemi Antelo - 2011-04-12

    I tried the routine "OCI_ColumnGetType" but it not return types like
    NUMBER(1,2). Do you know how can I Do it?

    Many thanks in advance

    yours sincerely
    Josemi

     

  • Vincent Rogier

    Vincent Rogier - 2011-04-12

    hi,

    2 options :

    1 - you can use OCI_ColumnGetFullSQLType() to retrieve the full string type
    name.
    2 - you can use OCI_ColumnGetPrecision() and OCI_ColumnGetScale()

     

  • Josemi Antelo

    Josemi Antelo - 2011-04-13

    Thank you :-)