怎么向表中插入这条数据，急！！！

Question

insert into window_object(window_name,parent_name,control_name,property,value,control_type,scope,sys_update_time,sys_create_time,sys_updated_by,sys_created_by)
values('w_ci_detail','w_ci_detail.tab_1.tabpage_address.uo_ci_address','cb_chg_address_role','visible','N','commandbutton',null,'10/12/2010 4:09:38 AM','10/7/2010 11:59:52 PM',
'MPOASIS','DTI_QA')
to_date('1996-12-03','yyyy-mm-dd')
数据是这样,正确的insert 该怎么写啊？在线等!!!

Answer 1

WINDOW_NAME VARCHAR2(50) N 
PARENT_NAME VARCHAR2(250) N 
CONTROL_NAME VARCHAR2(50) N 
PROPERTY VARCHAR2(50) N 
VALUE VARCHAR2(250) N 
CONTROL_TYPE VARCHAR2(50) N 
SCOPE VARCHAR2(200) Y 
SYS_UPDATE_TIME DATE Y 
SYS_CREATE_TIME DATE Y 
SYS_UPDATED_BY VARCHAR2(30) Y 
SYS_CREATED_BY VARCHAR2(30) Y

Answer 2

insert into window_object(window_name,parent_name,control_name,property,value,control_type,scope,sys_update_time,sys_create_time,sys_updated_by,sys_created_by)
values('w_ci_detail','w_ci_detail.tab_1.tabpage_address.uo_ci_address','cb_chg_address_role','visible','N','commandbutton',null,
to_date('10/12/2010 4:09:38 AM','dd/mm/yyyy hh12:mi:ss AM','nls_date_language=AMERICAN')
,to_date('10/7/2010 11:59:52 PM','dd/mm/yyyy hh12:mi:ss PM','nls_date_language=AMERICAN'),'MPOASIS','DTI_QA',to_date('1996-12-03','yyyy-mm-dd'))

Answer 3

--to_date('1996-12-03','yyyy-mm-dd')你搞这个东西放在那干什么
insert into window_object(window_name,parent_name,control_name,property,value,control_type,scope,sys_update_time,sys_create_time,sys_updated_by,sys_created_by)
values('w_ci_detail','w_ci_detail.tab_1.tabpage_address.uo_ci_address',
'cb_chg_address_role','visible','N','commandbutton',null,
to_date('10/12/2010 4:09:38 AM','mm/dd/yyyy hh:mi:ss AM','nls_date_language=AMERICAN'),
TO_DATE('10/7/2010 11:59:52 PM','mm/dd/yyyy hh:mi:ss AM','nls_date_language=AMERICAN'),
'MPOASIS','DTI_QA'
)

Answer 4

时间栏位insert时，字符串要转换成date格式：
to_date('10/12/2010 4:09:38 AM','dd/mm/yyyy hh12:mi:ss AM','nls_date_language=AMERICAN')to_date('10/7/2010 11:59:52 PM','dd/mm/yyyy hh12:mi:ss PM','nls_date_language=AMERICAN')

Answer 5

insert into window_object(
window_name,
parent_name,
control_name,
property,
value,
control_type,
scope,
sys_update_time,
sys_create_time,
sys_updated_by,
sys_created_by)
values(
'w_ci_detail',
'w_ci_detail.tab_1.tabpage_address.uo_ci_address',
'cb_chg_address_role',
'visible',
'N',
'commandbutton',
null,
to_date('10/12/2010 4:09:38 AM','dd/mm/yyyy hh12:mi:ss AM','nls_date_language=AMERICAN')
,to_date('10/7/2010 11:59:52 PM','dd/mm/yyyy hh12:mi:ss PM','nls_date_language=AMERICAN'),
'MPOASIS',
'DTI_QA')