Select SysID, TBName, TBAlias, TBCaption, TBType
from PUB_SYS_TBInfo
Where Sys_Code = 'DBG'
and Gsdm = '888'
and kjnd = '2012'
and TBName <> 'DBG_ZCLYSJ'
and TBName <> 'DBG_SRLYSJ'
and (trim(TBName) in (select trim(Tbname)
from pub_sys_fldinfo
where Gsdm = '888'
and Kjnd = '2012'
and Sys_Code = 'DBG'
and Sys_Code = 'DBG'
and KeyFld = 'DZKDM') and
(TBType = '0' or TBType = '1'))
and (TBName in (select NAME from Sysobjects where xtype = 'U') or
TBAlias in (select NAME from Sysobjects where xtype = 'U'))
order by TBType, SysID
/*
服务器: 消息 195,级别 15,状态 10,行 8
'trim' 不是可以识别的 函数名。
服务器: 消息 195,级别 15,状态 1,行 8
'trim' 不是可以识别的 函数名。
服务器: 消息 156,级别 15,状态 1,行 16
在关键字 'or' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 17
第 17 行: ')' 附近有语法错误。
*/
from PUB_SYS_TBInfo
Where Sys_Code = 'DBG'
and Gsdm = '888'
and kjnd = '2012'
and TBName <> 'DBG_ZCLYSJ'
and TBName <> 'DBG_SRLYSJ'
and (trim(TBName) in (select trim(Tbname)
from pub_sys_fldinfo
where Gsdm = '888'
and Kjnd = '2012'
and Sys_Code = 'DBG'
and Sys_Code = 'DBG'
and KeyFld = 'DZKDM') and
(TBType = '0' or TBType = '1'))
and (TBName in (select NAME from Sysobjects where xtype = 'U') or
TBAlias in (select NAME from Sysobjects where xtype = 'U'))
order by TBType, SysID
/*
服务器: 消息 195,级别 15,状态 10,行 8
'trim' 不是可以识别的 函数名。
服务器: 消息 195,级别 15,状态 1,行 8
'trim' 不是可以识别的 函数名。
服务器: 消息 156,级别 15,状态 1,行 16
在关键字 'or' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 17
第 17 行: ')' 附近有语法错误。
*/
解决方案 »
- 根据百分比,例如55.55%,百分比精确2位的。如果是90%为100分,下降0.1个百分点扣2分,扣完就是0分,怎么写呀
- Oracle表结构如何导入到Access中
- 物化视图 能同步视图吗
- 如何从PowerDesigner中导出表结构?
- 还是多表查询的问题!
- 哪位高人指点一下
- 一个简单的ORACLE存储过程的问题
- 怎样从oracle数据库中导出某个用户下的所有存储过程,包,函数?
- 我的服务器linux系统下的oracle访问别的oracle访问不成,但别人能访问我的,是什么原因?
- 请问考Oracle认证要多少钱?
- Oracle安装时Oracle_Base放到存储上还是本地磁盘呢?
- oracle导出数据表到excel文件中
from PUB_SYS_TBInfo
Where Sys_Code = 'DBG'
and Gsdm = '888'
and kjnd = '2012'
and TBName <> 'DBG_ZCLYSJ'
and TBName <> 'DBG_SRLYSJ'
and (rtrim(ltrim(TBName)) in (select rtrim(ltrim(Tbname))
from pub_sys_fldinfo
where Gsdm = '888'
and Kjnd = '2012'
and Sys_Code = 'DBG'
and Sys_Code = 'DBG'
and KeyFld = 'DZKDM') and
(TBType = '0' or TBType = '1')))
and (TBName in (select NAME from Sysobjects where xtype = 'U') or
TBAlias in (select NAME from Sysobjects where xtype = 'U'))
order by TBType, SysID
不行,还是一样的错,是SQL的语句。
Select SysID, TBName, TBAlias, TBCaption, TBType
from PUB_SYS_TBInfo
Where Sys_Code = 'DBG'
and Gsdm = '888'
and kjnd = '2012'
and TBName <> 'DBG_ZCLYSJ'
and TBName <> 'DBG_SRLYSJ'
and (trim(TBName)) in (select trim(Tbname)
from pub_sys_fldinfo
where Gsdm = '888'
and Kjnd = '2012'
and Sys_Code = 'DBG'
and Sys_Code = 'DBG'
and KeyFld = 'DZKDM') and
(TBType = '0' or TBType = '1'))
and (TBName in (select NAME from Sysobjects where xtype = 'U') or
TBAlias in (select NAME from Sysobjects where xtype = 'U'))
order by TBType, SysID
oracle早期版本里面没有trim函数,你可以按照2楼的方法变通一下。