clob_开发者

How to insert string in CLOB type column in oracle db using c#.net

i am trying to save a xml file as a string in clob type column in oracle db from c# am not sure how to insert clob type data from c#.[详细]

2023-04-13 03:14 分类：问答

Converting CLOB to a usable String in VB.NET

I\'m writing a tool the retrieves data from an Oracle database.The majority of the fields are VARCHAR2, but there\'s one particular field I want to retrieve that is a CLOB.I\'m trying to convert the t[详细]

2023-04-11 12:24 分类：问答

spooling a clob value with multiple lines using sqlplus to a single cell of a CSV

I tried to spool a CLOB to a CSV file using code that looks like below: set pagesize 0 set heading off set long 30000[详细]

2023-04-09 03:44 分类：问答

Inserting Clobs in Oracle with JDBC is very slow

Hi i am trying to insert a clob using the jdbc, through a maven plugin.But it is taking about 10 minutes to insert.This is exceptionally slow, and i was wondering if there was another way to do it.The[详细]

2023-04-08 12:39 分类：问答

Explanation of a BLOB and a CLOB

I am looking for a r开发者_JAVA技巧eal good explanation of a BLOB and CLOB data. I am looking for the great of that explains in plain English.BLOB\'s (Binary Large OBject) store binary files:pictures,[详细]

2023-04-08 09:32 分类：问答

Oracle 10g small Blob or Clob not being stored inline?

According to the documents I\'ve read, the default storage for a CLOB or BLOB is inline, which means that if it is less than approx 4k in size then it will be held in the table.[详细]

2023-04-03 14:52 分类：问答

Update Clob column in Oracle

I have an table with name ABC which has CLOB data. I want to update the column to insert string in specific position in this Clob column.[详细]

2023-03-30 13:45 分类：问答

Mapping a long text string in Oracle and NHibernate

Using NHibernate 3.1 with both SQL Server and Oracle DBs, we need to store a text string that is longer than 4000 characters. The text is actually XML, but that is not important - we just want to trea[详细]

2023-03-28 02:28 分类：问答

Uploading excel sheet in Java using blob or clob

I 开发者_StackOverflow中文版am new to java. I have a task of uploading Excel sheet to database (MySQL). Can anyone help me with the code ? Mention the steps and also suggest which jar file to use? Tha[详细]

2023-03-26 02:42 分类：问答

What is the need of CLOB while having varchar,Bfile,NCLOB?

Clob are used to store the dat开发者_开发百科a character upto 4 GB. It is similar to Varchar. Then what is need for clob?We can use BFile to store documents,pdf.. and so on.[详细]

2023-03-24 05:47 分类：问答