Split comma separated values of a column in row, through Oracle SQL query. Do not use CONNECT BY or REGEXP which results in a Cartesian product on a complex query. Furthermore the above solutions expect you know the possible results A,B,C,D,E,F rather than a list of combinations. Use XMLTable SELECT c. 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. Tuning individual sql statements to remove full table scans and use bitmap and function based indexes. Featuring Oracle Database Bulletproofing, Backups, and Disaster Recovery Scenarios, Implementing Data Guard, lots of scripts and routines including emailing with. You may try something like this CREATE OR REPLACE TYPE STRTABLE as table of varchar2 create or replace function GetCollection iStr varchar2, iSplit char default. Update Column From Another Table Oracle Sql Substr' title='Update Column From Another Table Oracle Sql Substr' />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. 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. COLUMNVALUE EMAILADDRESS. CONTACTS c, CONTACTSTATUS s. Blackberry Backup Software Free Download For Windows 7 on this page. REPLACEEMAILADDRESS, ,. The COLUMNVALUE is a pseudocolumn that belongs to xmltable. This is quick and correct and allows you to reference a column wo know its values. This takes the column and makes a table of values item,item. CONTACTS. This was tested on thousands of rows. Note the in the xmltable is the separator in the column field.