db2,oracle,mysql³£ÓÃÃüÁî±È½Ï
¡¶oracle,db2,mysqlÀà±È¡·×÷ΪÈýÖÖÊý¾Ý¿âÒ»¸öÀà±È£¬Ä¿µÄÔÚÓÚͨ¹ýÀà±È£¬Á˽âÏÖÔÚÊý¾Ý¿âÏàËƵãÓëÒìͬµã£¬Í¬Ê±¿ÉÒÔ°ïÖú´ó¼ÒÔÚÁ˽âÒ»ÖÖÊý¾Ý¿â£¬Äܹ»Ñ¸ËÙµØѧ»áÆäËûÊý¾Ý¿â¡£³õ²½¶¨ÒåΪoracle,db2,mysqlÈýÖÖÊý¾Ý¿â£¬ÒÔºó¿ÉÄÜ»¹ÊÇ×·¼Óinformix,sysbase,sql serverµÈÊý¾Ý¿â¡£
±¾Æª×÷ΪÊ×ƪ£¬Ä¿µÄÊÇÈôó¼Ò¶ÔÕâÈýÖÖÊý¾Ý¿â³£ÓõÄ֪ʶµãÓÐÒ»¸ö¸ÐÖªµÄÈÏʶ¡£
Ò»¡¢³£ÓÃ֪ʶµã
1¡¢²é¿´¿ÉÒԵǽµÄÊý¾Ý¿â£º
oracle:²é¿´tnsname.ora »òÕß echo $ORACLE_SID
db2:
mysql:show databases --²é¿´µ±Ç°Êý¾Ý¿â£ºselect database()
2¡¢²é¿´Óû§±í£¬ÊÓͼ£¬±íË÷Òý£¬±íÁУ¬
oracle:
select table_name from user_tables;
select view_name from user_views;
select constraint_name,constraint_type from user_constraints where table_name='';
select column_name from all_tab_columns where table_name='';
db2:
list tables or select tabname from syscat.tables;
select view_name from syscat.views;
describe indexes for table table_name;
select tabname from syscat.columns where tabname='';
mysql:information_schema
select table_name from information_schema.tables where table_schema='USER'; or show tables;
select table_name from information_schema.views where table_schema='USER'; or show table status where comment='view';
select constraint_name,constraint_type from information_schedma.table_constraints where table_name='';
select index_name,table_name from information_schema.statistics where table_name='';
select column_name from information_schedma.columns where table_name='' and table_schema='USER';
3¡¢²é¿´±í¿Õ¼ä
oracle:select name from v$tablespace
db2: list tablespaces
mysql:
4¡¢²é¿´±í½á¹¹
oracle:describe table_name
db2:describe table table_name
mysql:describe table_name
5¡¢È¡Ç°nÐÐÊý¾Ý
oracle:select * from table_name where rownum<n
db2:select * from table_name fetch first n rows only
mysql:select * from table_name limit n
6¡¢loadÊý¾Ý
oracle: sqlldr username/passwd control=ctr.ctl data=data.txt
db2:load from data.txt of del insert into table_name
mysql:load data local infile 'e:Mysqlmysql.txt' into table test lin
Ïà¹ØÎĵµ£º
ÕâƪÎÄÕ²ûÊöÁËÈçºÎ¹ÜÀíoracle ERPµÄinterface±í
ÕâƪÎÄÕ²ûÊöÁËÈçºÎ¹ÜÀíoracle ERPµÄinterface±í
http://blog.oraclecontractors.com/?p=212
There are a number of tables used by Oracle Applications that should have no rows in them when all is running well, and if any, only a few rows that are in error. ......
±íÖÐÒª¸üеÄÊý¾Ý£¬±ØÐëҪͨ¹ýºÍÁíÒ»¸ö±íÀ´¹ØÁª²ÅÄÜÈ·¶¨Òª¸üеÄÌõÄ¿£¬mssql¿ÉÒÔÖ±½ÓÓà from t1.id=t2.id À´¸üУ¬¶øOracleÔò±¨´í
×îºógoogleµ½ÕâÑù£¬Ö±½Ó½«¹ØÁªºóµÄ±í×÷Ϊһ¸ö±íÀ´¸üС£¡£¡£¡£
update (select * from us_cm_cat_petrol_gun g
left join us_cm_ci c on g.machine_sn ......
ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê &nb ......
1¡¢Á¬½ÓOracleÊý¾Ý¿â
Æô¶¯SQL*Plus£¬ÒªÇóÊäÈëUser Name¡¢Password¡¢Host StringÕâÈý¸ö²ÎÊý£¬ÀýÈçÎÒÔÚ°²×°µÄʱºòĬÈÏ´´½¨µÄÊý¾Ý¿âΪorcl£¬Ò²¾ÍÊÇSID£¬ÃÜÂëҲΪorcl£¬¶ÔÓ¦ÉÏÃæµÄÈý¸ö²ÎÊýÈçÏÂËùʾ£º
User Name£ºorcl
Password£ºorcl
Host String£ºorcl as sysdba
¾Í¿ÉÒԵǼ³É¹¦¡£
»òÕßÒ²¿ÉÒÔʹÓÃĬÈϵÄscottÀ´µÇ¼£º
......
ÐèÇó1£ºÔÚÒ»¸öselect ²éѯ¼¯ÖÐÔٴβéѯ
SELECT * from (SELECT field from table) AS alias
ÐèҪעÒâºóÃæµÄalias£¬ÔÚmysqlÖУ¬ÕâÊDZØÐëµÄ
ÐèÇó2£ºÒ»¸ö²éѯ¼¯µÄ½á¹û²»ÔÚÁíÒ»¸ö²éѯ¼¯ÖÐ
SELECT feild1 from table1 WHERE feild1 NOT IN (SELECT field2 from table2)
ÐèҪעÒ⣬ӦÓÃIN/NOT IN×Ó¾äʱ£¬±ØÐëÖ¸¶¨²éѯ×Ö¶ÎÃû£ ......