creat view V_PERMIT
as
SELECT PERMIT.PERMITID, PERMIT.ITEMID, PERMIT.COMPANYCODE, PERMIT.PERMITNO, PERMIT.LOCATION,
PERMIT.BUILDAREA, PERMIT.PERMITAREA, PERMIT.SELLTYPE, PERMIT.NUMS, PERMIT.FLOORS, PERMIT.BUILDNO,
PERMIT.SETS, PERMIT.OUTAREA, PERMIT.OUTNUMS, PERMIT.OUTBUILDNO, PERMIT.OUTSETS, PERMIT.OUTNO,
PERMIT.INAREA, PERMIT.INNUMS, PERMIT.INBUILDNO, PERMIT.INSETS, PERMIT.PRICE, PERMIT.GIVEDATE,
PERMIT.STRUCTURE, PERMIT.[USE], PERMIT.STRUC1, PERMIT.STRUC2, PERMIT.STRUC3, PERMIT.STRUC4,
PERMIT.STRUC5, PERMIT.USE1, PERMIT.USE2, PERMIT.USE3, PERMIT.USE4, PERMIT.USE5, PERMIT.USE6,
PERMIT.USE7, PERMIT.USE8, PERMIT.OPENDATE, PERMIT.BUILDDATE, PERMIT.AGENTNAME, PERMIT.APPLYDATE,
PERMIT.CONSTRUCTUNIT, PERMIT.AGENTUNIT, PERMIT.REMARK, PERMIT.CONFIRMED, PERMIT.LOGINID,
PERMIT.NETWORKAREA, PERMIT.NETWORKSETS, PERMIT.CONSTRUCTNO, PERMIT.SELLTEL, PERMIT.SCALENO,
PERMIT.HOUSELOGID, PERMIT.LANDNO, PERMIT.CHECKFLAG, PERMIT.CHECKDATE, PERMIT.COMMITFLAG,
PERMIT.ALLFLOORS, PERMIT.ADDTJDATE, ITEM.DISTRICT,
ITEM.ITEM, COMPANY.COMPANYCODE AS
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......