Oracle 10g 字段长度的问题!
偶用的是Oracle 10.1 G,遇到以下问题,调试了很久,就是调不成功,请求网友帮忙!
SQL> CREATE TABLE person (
2 pid VARCHAR2(18),
3 name VARCHAR2(200),
4 age NUMBER(3),
5 birthday DATE,
6 sex VARCHAR2(2) DEFAULT '男'
7 );
sex VARCHAR2(2) DEFAULT '男'
*
第 6 行出现错误:
ORA-01401: 插入的值对于列过大
SQL> CREATE TABLE person (
2 pid VARCHAR2(18),
3 name VARCHAR2(200),
4 age NUMBER(3),
5 birthday DATE,
6 sex VARCHAR2(2) DEFAULT '男'
7 );
表已创建。
没错啊，是不是你多加了空格哦，成了这样' 男'
The VARCHAR2 and CHAR types support two methods of specifying lengths:
• In bytes: VARCHAR2(10 byte). This will support up to 10 bytes of data, which could be as few as two characters in a multibyte character set.
• In characters: VARCHAR2(10 char). This will support to up 10 characters of data, which could be as much as 40 bytes of information.
ORA-01401: inserted value too
相关问答：
我安装一台redhat linux5+oracle 10g的服务器，笔记本（XP系统）安装了oracle 10g客户端,结果老是出12560的错误，请高手指点一二，
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
环境：1.win2003server+oracle9i
2.oracle9i字符集为AMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer版本 1.5.5
现象描述: 1.在sql developer 中查询oracle中的某个表，中文全部显示为乱码。
......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
select sname,(2009-10-05)-birth
from student;
birth字段中存的是出生年月，想查询出来的结果是年龄，该如何查询？
加上datediff函数试试
select sname, to_char(sysdate,'YYYY')- to_char( ......
我写的一个Job
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103,
&n ......
