SQL|同列多行数据，同一行显示 2019-02-15 Franky SQL SQL, function 将同列多行数据，同一行显示 Oracle wm_concat(column) 该函数将多列数据聚合成一行数据，以","号分隔，并且字段类型为clob类型。 Read more →
SQL|EXISTS 2019-01-18 Franky SQL SQL, function WHERE EXISTS ( subquery ) EXISTS用在相关子查询中 The result of EXISTS is a boolean value True or False，EXISTS returns true if the subquery returns one or more records. It can be used in a SELECT, INSERT, UPDATE, or DELETE statement. Read more →