DBMSLOB. The DBMSLOB package provides subprograms to operate on BLOBs, CLOBs, NCLOBs, BFILEs, and temporary LOBs. You can use DBMSLOB to access and manipulation. Data Access for Triggers. When a trigger is fired, the tables referenced in the trigger action might be currently undergoing changes by SQL statements in other users. We experienced a failure on one of our MS SQL servers this morning and we are currently investigating the cause. One thing I have noticed is a massive jump in the. Sql9_4.png' alt='Update Column From Another Table Oracle Sql Substr' title='Update Column From Another Table Oracle Sql Substr' />In cross join one table of each row compare with each row another table is called Cartesian Join. I need to query the database to get the column names, not to be confused with data in the table. For example, if I have a table named EVENTLOG that contains eventID. SQL wmconcat function. Question I have a table testtest and I need to. Name    Mark ABC     1. DEF     1. 0GHI     1. JKL     2. 0MNO     2. PQR     3. 0The result should. ABC,DEF,GHI2. 0       2. JKL,MNO3. 0. 1     PQRAnswer. By Laurent Schneider  You could write your own. Here is another example of using wmconcat select deptno, wmconcatdistinct ename from emp group by deptno DEPTNO. WMCONCATDISTINCTENAME. CLARK,KING,MILLER2. ADAMS,FORD,JONES,SCOTT,SMITH3. ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARDAnother reader asks Question  I have some questions about. I have been told that I. I ran into. some issues. Using wmconcat returned some errors. I added a. CAST statement. VARCHAR cast. Is there a need to use SUBSTR as well If the result of the wmconcat is 1. Microsoft Storage Server Hardware Requirements Of Wan. I. use the following to truncate the results to 1. Assuming the result of the wmconcat is 1. I wanted to CAST it to 4. I get a bunch of white space to go with itAnswer  Oracle Guru Laurent Schneider has. CAST and wmconcat Regarding the results returned by wmconcat, The use of. CAST does indeed resize or expand to the specified length. As for. using varchar. An example of the use of CAST selectabcdef,castabcdef. ABCDEF V3         LV3. V9               LV9. SQL create view v as. View created. Name              Null    Type. VC9                        VARCHAR29 SUB                        VARCHAR26.