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)想问一下其中的 '''' 是什么意思?
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