skip to main
|
skip to sidebar
About
Contact
Today :
Tech Netting
Home
Handling Single Quotes in Column Content
0
dbms_xmlgen.convert( rtrim( extract( Xmlagg( xmlelement(e,Sq_Sql.Attr_Value) order by Sq_Sql.line_no
), '//text()').getclobval() , ','), 1)
Sq_Sql.Attr_Value , Sq_Sql.line_no are column names
0
Awesome Comments!
Leave Your Response
Newer Post
Older Post
Home
Page views
Blog Archive
►
2021
(4)
►
August
(1)
►
May
(1)
►
February
(2)
►
2020
(10)
►
November
(1)
►
October
(2)
►
September
(2)
►
August
(1)
►
May
(3)
►
March
(1)
►
2019
(3)
►
May
(1)
►
January
(2)
►
2018
(14)
►
December
(2)
►
November
(3)
►
October
(1)
►
June
(1)
►
May
(1)
►
March
(2)
►
February
(2)
►
January
(2)
►
2017
(37)
►
November
(1)
►
October
(8)
►
September
(1)
►
August
(1)
►
July
(1)
►
May
(5)
►
April
(9)
►
March
(6)
►
February
(1)
►
January
(4)
►
2016
(36)
►
December
(4)
►
November
(4)
►
October
(3)
►
September
(5)
►
August
(3)
►
June
(2)
►
May
(2)
►
April
(3)
►
March
(4)
►
February
(2)
►
January
(4)
▼
2015
(75)
►
December
(4)
►
November
(1)
►
October
(1)
►
September
(6)
►
August
(2)
►
July
(3)
►
June
(6)
►
May
(19)
▼
April
(11)
Difference between Connected and Unconnected Looku...
Using an Oracle PL/SQL block in pre SQL
Maximum number of Columns in Oracle
Mapplet Input is One To One
Oracle Syntax for Update with Joins
Target update override - Informatica
Handling Single Quotes in Column Content
Session on Parameters and Variables
Scope of Informatica Parameter File
Naming Conventions for User-Defined Session Parame...
►
March
(16)
►
February
(3)
►
January
(3)
►
2014
(18)
►
December
(18)
Search
Popular Posts
Operation not allowed for reason code “7” on table in DB2
This issue generally occurs when we altered/modified already existing table in IBM DB2. We have to execute below Query when we get this erro...
tAggregateRow and tAggregateSortedRow in Talend
This is our input for demonstration. tAggregateRow vs tAggregateSortedRow in Talend I know these many columns not required but still wanted ...
Versioned table in Netezza
One QC process need to obtain tables and their row counts in a database in Netezza. We use the below SQL query to do so: "...
TO_CHAR Date Format in Informatica To_Char(Date_column,Format)
Format String Description AM, A.M., PM, P.M. Meridian i...
Creation of Informatica connections Using Infacmd
When a connection is created from command line, multiple options need to provide in -o option: infacmd.sh createconnection [ICMD_10023] Miss...
Workflow Execution through PMCMD
Executing PMCMD command on UNIX and Syntax By Mahender on May 15, 2011 Steps to start workflow through PMCMD command, Generally we get be...
Talend MetaServlet API
How Jobs are handled via Talend Administration Center Talend Jobs are scheduled from Talend Administration Center , which provid...
ORA-31061: XDB error: special char to escaped char conversion failed.
Error : ORA-31061: XDB error: special char to escaped char conversion failed. Cause : This is error is due to the presence of control chara...
[ICMD_10033] Command [defineDomain] failed
ERROR: "[ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002] Cannot create the domain because of the fo...
REPLACECHR in Informatica
REPLACHR is used to replace one character with another or remove particular character from a string 1. REPLACECHR ( ...
Labels
Informatica
Mysql
ODI
Oracle
SQL Server
Talend
0Awesome Comments!