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_columntype
描述
string ora_columntype ( resource cursor, int column )返回游标 cursor 第 column列的 Oracle 数据类型名。 列号从0开始编号。返回下列类型之一：
| "VARCHAR2" |
| "VARCHAR" |
| "CHAR" |
| "NUMBER" |
| "LONG" |
| "LONG RAW" |
| "ROWID" |
| "DATE" |
| "CURSOR" |
add a note
User Contributed Notes
kk at shonline dot de
05-Aug-1998 11:32
05-Aug-1998 11:32