oracle
hefei95
123
展开
-
oracle导入导出
一、将指定的表导出备份 Host Exp tables = (emp,dept) grants = y Host imp fromuser = scott touser = test tables = (emp,dept) 例一: Host exp system/jsj rows=y tables = emp file=e:\back\emp.dmp Drop tab翻译 2013-12-09 16:30:18 · 489 阅读 · 0 评论 -
oracle管理表
insert into qq (name,id,relation,gender) values ('宝儿','33796776','朋友','女'); insert into qq values ('宝儿','33796776','朋友','女'); alter table qq modify (gender varchar(6));//修改外键类型 alter table qq add原创 2013-12-04 16:34:41 · 401 阅读 · 0 评论