ora_commit> <ora_columnsize
Last updated: Mon, 28 Dec 2009

ora_columntype

(PHP 4, PHP 5 <= 5.0.5)

ora_columntype — Pega o tipo de uma coluna no Oracle

Descrição

string ora_columntype ( resource $cursor , int $column )

Retorna o nome do tipo de campo/coluna column no cursor cursor . A coluna 0 é a primeira coluna. O tipo retornado irá ser um dos seguintes:

  • "VARCHAR2"
  • "VARCHAR"
  • "CHAR"
  • "NUMBER"
  • "LONG"
  • "LONG RAW"
  • "ROWID"
  • "DATE"
  • "CURSOR"



User Contributed Notes
ora_columntype
kk at shonline dot de
05-Aug-1998 12:32
And the mapping between SQL types (see $ORACLE_HOME/rdbms/demo/ocidfn.h) and return strings is as follows:<p>

SQLT_CHR (character string) becomes VARCHAR2
SQLT_VCS (variable character string) becomes VARCHAR
SQLT_AVC (Ansi var char) becomes VARCHAR
SQLT_STR (zero terminated string) becomes CHAR
SQLT_AFC (Ansi fixed char) becomes CHAR
SQLT_NUM (oracle numeric) becomes NUMBER
SQLT_INT (integer) becomes NUMBER
SQLT_FLT (floating point number) becomes NUMBER
SQLT_UIN becomes NUMBER
SQLT_LNG (long) becomes LONG
SQLT_LBI (long binary) becomes LONG RAW
SQLT_RID (rowid) becomes ROWID
SQLT_DAT (date in oracle format) becomes DATE
SQLT_CUR (cursor) becomes CURSOR

All other types (and there are many of them) become UNKNOWN

ora_commit> <ora_columnsize
Last updated: Mon, 28 Dec 2009