用NUMBER就可以,
DECLARE A AS NUMBER(10)就可以了。
DECLARE A AS NUMBER(10)就可以了。
解决方案 »
- 求助,oracle创建用户【小白问题】
- SQL 错误: ORA-00922:
- 安装oracle10g时提示升级oracle9i的数据库
- 从视图中选取最大值
- Oracle计算员工的出勤天数、月工资!
- 请问oracle中如何判断某字段的值为数值而不是其他字母?
- 求教格式化字符串问题。
- 按照一个字段的数值进行分组怎么写?group by
- 数据库查看当前的运行模式?怎么切换成ARCHIVELOG模式?
- 用SQL语句,向oracle表中插入当前的系统时间,怎么 办!请指点。。在线 等。。
- 请问在orcale 8i 中用什么字段类型保存年月日时分秒的,急!在线等!!
- 无法写如数据库的问题!!!!!!!!!!
Internal Type C Type Description
VARCHAR2(Y) (Note 1)
char
single character
CHAR(X) (Note 1)
char[n] VARCHAR[n] int short long float double
n-byte character array n-byte variable-length character array integer small integer large integer floating-point number double-precision floating-point number
NUMBER
int
integer
NUMBER(P,S) (Note 2)
short int long float double
char char[n] VARCHAR[n]
small integer integer large integer floating-point number double-precision floating-point number single character n-byte character array n-byte variable-length character array
DATE
char[n] VARCHAR[n]
n-byte character array n-byte variable-length character array
LONG
char[n] VARCHAR[n]
n-byte character array n-byte variable-length character array
RAW(X) (Note 1)
unsigned char[n] VARCHAR[n]
n-byte character array n-byte variable-length character array
LONG RAW
unsigned char[n] VARCHAR[n]
n-byte character array n-byte variable-length character array
ROWID
unsigned char[n] VARCHAR[n]
n-byte character array n-byte variable-length character array
Notes: 1. X ranges from 1 to 2000. 1 is the default value. Y ranges from 1 to 4000. 2. P ranges from 1 to 38. S ranges from -84 to 127.
Internal Type C Type Description
NUMBER(P,S) (Note 2) short
int
long
float
double
没有__int64用long或者double就可以了