create table plsql101_purchase (
product_name varchar2(25),
product_price number(4,2),
purchase_date date
c);
insert into plsql101_purchase values
('Product Name 1', '1', to_date('5-NOV-03','dd-mm-yy'));
insert into plsql101_purchase values
('Product Name 2', '2.5', '29-JUN-04');
insert into plsql101_purchase values
('Product Name 3','50.75','10-DEC-05');
insert into plsql101_purchase values
('Product Name 4','99.99','31-AUG-06');老提示无效的月份,是怎么回事,如何使用to_date()
product_name varchar2(25),
product_price number(4,2),
purchase_date date
c);
insert into plsql101_purchase values
('Product Name 1', '1', to_date('5-NOV-03','dd-mm-yy'));
insert into plsql101_purchase values
('Product Name 2', '2.5', '29-JUN-04');
insert into plsql101_purchase values
('Product Name 3','50.75','10-DEC-05');
insert into plsql101_purchase values
('Product Name 4','99.99','31-AUG-06');老提示无效的月份,是怎么回事,如何使用to_date()
用这个方式试试
如果是字符型要转化成日期格式,才可以插入
會因系統的設定
而有固定日期格式認定
其他格式則需TO_DATE去轉換