Questions tagged [nclob]
35 questions
0
votes
1 answer
How to Copy Only First 4000 Characters from Oracle NCLOB to NVARCHAR2(4000) Value?
I am a programmer, and I am writing some SQL code to pull data from a remote Oracle database and insert it into some tables on our local MS SQL Server.
I need to bring an Oracle NCLOB column to an NVARCHAR column in our MS SQL Server database.
We…
qxotk
- 2,384
- 5
- 24
- 39
0
votes
1 answer
How to perform a search and replace on a NCLOB?
With an Oracle 11g database, and a NCLOB column in a table, I'm trying to replace some text with another text. At a high level, it's pretty simple, I did it successfully on a SQL Server version of a SQL script, but with Oracle, things are getting…
sgy
- 2,922
- 2
- 35
- 42
0
votes
0 answers
turkish character decode of nclob data to html in oracle
I see nclob data in editor of oracle pl sql developer as
Detayları resmi yazı ile iletilen tüberküloz ...
But I want to decode this into
Detayları resmi yazı ile iletilen tüberküloz ...
My sql query is like:
SELECT T.Aciklama…
serefbilge
- 1,654
- 4
- 29
- 55
-1
votes
1 answer
Oracle insert NCLOB data into NVARCHAR2
I am tyring to insert NCLOB data into NVARCHAR2.it is showing error ORA - 06512 in stored procedure.
How to fix this error?.
Ram
- 727
- 2
- 16
- 33
-1
votes
1 answer
How should I work with CLOB or NCLOB datatype in oracle?
I read these datatypes are for storing long String, so I decided to use NCLOB for storing comments and Bio.I just wanted to try, I created a table :
create table cmd(content NCLOB);
and tried to insert a long string in the table but just three…
saba safavi
- 160
- 7
- 20