oracle报错文字与格式字符串不匹配,oracle-SQL错误:ORA-01861:文字与格式字符串01861不匹配...

我正在尝试将数据插入现有表中并继续收到错误。

INSERT INTO Patient

(

PatientNo,

PatientFirstName,

PatientLastName,

PatientStreetAddress,

PatientTown,

PatientCounty,

PatientPostcode,

DOB,

Gender,

PatientHomeTelephoneNumber,

PatientMobileTelephoneNumber

)

VALUES

(

121,

'Miles',

'Malone',

'64 Zoo Lane',

'Clapham',

'United Kingdom',

'SW4 9LP',

'1989-12-09',

'M',

02086950291,

07498635200

);

错误:

Error starting at line : 1 in command -

INSERT INTO Patient (PatientNo,PatientFirstName,PatientLastName,PatientStreetAddress,PatientTown,PatientCounty,PatientPostcode,DOB,Gender,PatientHomeTelephoneNumber,PatientMobileTelephoneNumber)

VALUES (121, 'Miles', 'Malone', '64 Zoo Lane', 'Clapham', 'United Kingdom','SW4 9LP','1989-12-09','M',02086950291,07498635200)

Error report -

SQL Error: ORA-01861: literal does not match format string

01861. 00000 - "literal does not match format string"

*Cause: Literals in the input must be the same length as literals in

the format string (with the exception of leading whitespace). If the

"FX" modifier has been toggled on, the literal must match exactly,

with no extra whitespace.

*Action: Correct the format string to match the literal.

只是不确定为什么这种情况一直在发生,我目前正在学习SQL,我们将不胜感激任何帮助!

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值