oracle存储过程中SELECT CHECKDATE,CHECKRESULT,CHECKCAUSE,e2.STATUSCODE CHECKCAUSECODE,e2.STATUSNAME CHECKCAUSENAME,
e2.STATUSID STATUS,ASSETID,ASSETCODE,ASSETNAME,USEPLACE,b1.PLACENAME USEPLACENAME,'''' FIRUSEPLACE,'''' FIRUSEPLACENAME,
'''' SECUSEPLACE,'''' SECUSEPLACENAME,ASSETSTATUS,e1.STATUSNAME ASSETSTATUSNAME,'''' FIRASSETSTATE,'''' FIRASSETSTATENAME,
'''' SECASSETSTATE,'''' SECASSETSTATENAME,SPEC,MODEL,FACTORY,m.LSWLDW_DWMC FACTORYNAME,'''' FIRDATE,'''' SECDATE,
'''' FIRDATEDISPLAY,'''' SECDATEDISPLAY,ORGIONSTATUS,e3.STATUSNAME ORGIONSTATUSNAME,
'''' BILLSTATE,'''' BILLSTATENAME,'''' APPRODATE,'''' APPROMAN,'''' PROCESSINSTANCEID
FROM ASSETCARD
LEFT JOIN LSWLDW m ON trim(m.LSWLDW_WLDWBH) = trim(FACTORY)
LEFT JOIN ASSETPLACE b1 ON TRIM(b1.PLACEID) = TRIM(USEPLACE)
LEFT JOIN ASSETSTATUS e1 ON TRIM(e1.STATUSID) = TRIM(ASSETSTATUS)
LEFT JOIN ASSETSTATUS e2 ON TRIM(e2.STATUSID) = TRIM(CHECKCAUSE)
LEFT JOIN ASSETSTATUS e3 ON TRIM(e3.STATUSID) = TRIM(ORGIONSTATUS)想问一下其中的 '''' 是什么意思?
e2.STATUSID STATUS,ASSETID,ASSETCODE,ASSETNAME,USEPLACE,b1.PLACENAME USEPLACENAME,'''' FIRUSEPLACE,'''' FIRUSEPLACENAME,
'''' SECUSEPLACE,'''' SECUSEPLACENAME,ASSETSTATUS,e1.STATUSNAME ASSETSTATUSNAME,'''' FIRASSETSTATE,'''' FIRASSETSTATENAME,
'''' SECASSETSTATE,'''' SECASSETSTATENAME,SPEC,MODEL,FACTORY,m.LSWLDW_DWMC FACTORYNAME,'''' FIRDATE,'''' SECDATE,
'''' FIRDATEDISPLAY,'''' SECDATEDISPLAY,ORGIONSTATUS,e3.STATUSNAME ORGIONSTATUSNAME,
'''' BILLSTATE,'''' BILLSTATENAME,'''' APPRODATE,'''' APPROMAN,'''' PROCESSINSTANCEID
FROM ASSETCARD
LEFT JOIN LSWLDW m ON trim(m.LSWLDW_WLDWBH) = trim(FACTORY)
LEFT JOIN ASSETPLACE b1 ON TRIM(b1.PLACEID) = TRIM(USEPLACE)
LEFT JOIN ASSETSTATUS e1 ON TRIM(e1.STATUSID) = TRIM(ASSETSTATUS)
LEFT JOIN ASSETSTATUS e2 ON TRIM(e2.STATUSID) = TRIM(CHECKCAUSE)
LEFT JOIN ASSETSTATUS e3 ON TRIM(e3.STATUSID) = TRIM(ORGIONSTATUS)想问一下其中的 '''' 是什么意思?
解决方案 »
- SCN问题求解?
- 如何将Clob类型改成Varchar类型?
- pl/sql developer中建立sql server的链接
- 重新定义Tablespace的extent等存储参数是否会影响此表空间中的已存在表和索引的存储参数?
- 请问用rman如何做几个TABLE的备份。或者是对不同的表空间做分别备份
- 为什么我在SQLplus里建的表,在Enterprise manager console里看不见?
- sql server下的ldf文件是日志文件,oracle下是哪个啊?
- 触发器的使用,请大家帮忙啊~~~~~~~~~~~~~~~~~~~~~~~~谢谢你们了!!!!!!!!!!!!!!!!
- 关于视图的问题
- 关于sql的一个小问题?急!!!!!!!!
- 问一个时间查询的问题...
- 求助两个sql的区别
EMPNO ENAME ENAME
----- ----- ----------
7369 ' SMITH
SQL> 执行下看看.
''''对应',SECUSEPLACE是别名
SQL>
id status time
' ' '
' ' '
' ' '自己理解
东西要自己去试就知道'''' SECUSEPLACE 把'''' (''''结果为')的记录的列名显示为SECUSEPLACE
1* select id,'''' name,name from tt
SQL> /ID N NAME
---------- - --------------------
wkc168 '
2 '
2 '
2 '
2 '
2 '
8 '
test '
168 ' wkc168
128 ' wkc128
18 ' wkc18