SQL> insert into title values(&title_id,'&title','&description','&city','&rating',to_date('&release_
date','yyyy-mm-dd'));
×îºóÊäÈëÍêºó´íÎóÊÇ:ORA-01756: À¨ºÅÄÚµÄ×Ö·û´®Ã»ÓÐÕýÈ·½áÊø
´óϺÃÇ,ÄÜ¿´³öÀ´ÕâÊÇʲô´íÎóô???
------½â¾ö·½°¸--------------------------------------------------------
SQL> insert into title values(&title_id,'&title','&description','&city','&rating',to_date('&release_
date','yyyy-mm-dd'));
->
SQL> insert into title values(&title_id,&title,&description,&city,&rating,to_date(&release_
date,'yyyy-mm-dd'));
-- Pls enter the values as following:
title_id: 3 -- use number type
title: 'tsa' -- use string type
... -- Just keep the others format as above string type
------½â¾ö·½°¸--------------------------------------------------------
¤É¤Ä¤â¡¡¤¢¤ê¤¬¶È¤´¤¶¤¤¤Þ¤¹
------½â¾ö·½°¸--------------------------------------------------------
SQL> insert into title values(&title_id,&title,&description,&rating,&city,&release_date
2 );
ÊäÈë title_id µÄÖµ: title_id_seq.nextval
ÊäÈë title µÄÖµ: 'Willie and Christmas Too'
ÊäÈë description µÄÖµ: ' All of Willie's friends make a Christmas list for Santa, but Willie has y
et to add his own wish list.'
ÊäÈë rating µÄÖµ: 'G'
ÊäÈë city µÄÖµ: 'CHILD'
ÊäÈë release_date µÄÖµ: to_date('1995-10-05','yyyy-mm-dd')
ÔÖµ 1: insert into title values(&title_id,&title,&description,&rating,&city,&release_date
ÐÂÖµ 1: insert into title values( title_id_seq.nextval, 'Willie and Christmas Too', ' All of Willi
ERROR:
ORA-01756: À¨ºÅÄÚµÄ×Ö·û´®Ã»ÓÐÕýÈ·½áÊø
¿ÉÊÇ, ÕâÑù»¹ÊÇ´íµÄ...........
------½â¾ö·½°¸--------------------------------------------------------
chr(32)Ìæ´ú&¾Í¿ÉÒÔÁË£¬¿ÉÒÔÊÔÊÔ