Hi,
I have a table called TESTOUPUT in Oracle 10g and it contains 3 columns
ID_ VARCHAR2(7),
TEXT CLOB,
PROCESSED NUMBER
and same table I have created in SQL 2008 Express.
now I want to copy the data in CLOB of Oracle to TEXT field
How should I do this.
Format of my CLOB is as below: -
=============================================================
{1:F01SGL1XXXXXXXX0000000000}{2:I541ABCIBHBMXXXXN}{3:{108:1212}}{4:
:16R:GENL
:20C::SEME//RS5100801
:23G:NEWM
:98C::PREP//20100223094459
:16S:GENL
:16R:TRADDET
:98A::SETT//20100227
:98C::TRAD//20100219090000
:90B::DEAL//ACTU/EUR10,
:35B:ISIN ES0113900J37
BANCO SANTANDER
:16S:TRADDET
:16R:FIAC
:36B::SETT//UNIT/5000,
:97A::SAFE//REC050
:16S:FIAC
:16R:SETDET
:22F::SETR//TRAD
:22F::STCO//PART
:16R:SETPRTY
:95P::SELL//AAALSARI
:97A::SAFE//76767676
======================================================
Please help me as SQL 2008 doesn't support the Query Analyzer capabilities.
Thanks,
Sandeep