oracle日常总结

1.更改表字段默认值的语句：
alter table a modify(b  date default to_date('20010101','yyyymmdd'));
2.导入导出语句：
exp userid=bjdx_12/bjdx@cbsparam owner=bjdx_12file=d:\sql\BJDX.dmp
imp userid=cbsparam/cbsparam fromuser=cbsparam touser=cbsparam file=d:\sql\BJDX.dmp