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
大家好,我现在把oracle服务器上面的原始文件,下载到本机了.我想在本机访问数据库怎么设置啊.是不是类似可以建立一个什么虚拟服务器来实现.请大家出出主意
引用
大家好,我现在把oracle服务器上面 ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
