Informix与Oracle的异同
5墨值下载
2013-4-20
1 , 17
INFORMIX ORACLE
Informix Oracle SMS
1
Informix oracle dbaccess sqlplus
Informix dbaccess $TELLIN_DBNAME
informix dbaccess
Oracle sqlplus /
Oracle sqlplus /
OPS sqlplus show user
Informix dbaccess delete update Oracle
commit
Tip
select table_name from user_tables;
desc tablename; desc eppc_service;
2 Load Unload
Informix
dbaccess $TELLIN_DBNAME << !
load from filename insert into table_name1;
unload to filename select * from table_name2;
!
2013-4-20
2 , 17
Oracle
Oracle .unl IIN myload
myunload
myload username/password filename delimate sqlcontent
myunload username/password filename delimate sqlstatement
myload / eppc_service.unl | insert into eppc_service
myunload / eppc_service.unl '|' select * from eppc_service
oracle sqlldr sqlldr
3 Grant
Oracle
scu1 scu2
scu1 sqlplus grant select on basetab_eppc to scu2; // scu1
basetab_eppc select scu2
scu2 sqlplus select * from scu1.basetab_eppc; //
select * from scu1. CMP_Supplyment //
Informix connect
scu1 scu2 scu1db scu2db
scu1db
grant CONNECT to scu2;
scu2db :
select * from scu2db:eppc_fee; //
of 17
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论