Sitemap

Amicuk Programming Answers

Can we check CLOB datatype to null?

2015-10-11   Views:1

Advertisement

Hi , i want check clob datatype to null so i have used decode(col1,null,n1,n2) ..it executes the query but it gives nothing ..doesn't return data only show o .. can you please tell me how to do ?Take a look at http://docs.oracle.com/cd/E11882_01/appd

Hi ,
i want check clob datatype to null so i have used decode(col1,null,n1,n2) ..it executes the query but it gives nothing ..doesn't return data only show o ..
can you please tell me how to do ?

The replay answer
Advertisement
Take a look at http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_lob.htm#ARPLS66622
CONVERTTOBLOB Procedure
Regards
Etbin

Go to See the other 2 answers

Can we check CLOB datatype to null?

Category:DefaultRelease time:2015-10-11Views:130

Hi , i want check clob datatype to null so i have used decode(col1,null,n1,n2) ..it executes the query but it gives nothing ..doesn't return data only show o .. can you please tell me how to do ?Take a look at http://docs.oracle.com/cd/E11882_01/appd[More]

Clob DataType, NULL and ADO

Category:DefaultRelease time:2015-10-11Views:130

Hello, First, I'm french so my english isn't very good I have a problem with Oracle Clob DataType. When I try to put NULL value to CLOB DataType with ADO, changes aren't not made. rs.open "SELECT ....", adocn, adOpenKeyset, adLockOptimistic rs.F[More]

LogMiner puzzle - CLOB datatype

Category:DefaultRelease time:2015-10-11Views:130

Hello, everybody! Sorry for the cross-post here and in "Database\SQL and PL/SQL" forum, but the problem I am trying to dig is somewhere between those two areas. I need a bit of an advice whether the following behavior is wrong an requires SR to[More]

A clob datatype and LogMiner question?

Category:DefaultRelease time:2015-10-11Views:130

HI, I am using Logminer to caputer all DMLs agaist rows with clob datatype, find a problem. --log in as scott/tiger conn scott/tiger SQL> desc clobtest Name Null? Type SNO NUMBER CLOBTYPE CLOB --make a update update clobtest set CLOBTYPE = 'Hello New[More]

Problem on CLOB datatype after import

Category:DefaultRelease time:2015-10-11Views:130

I got problem and call to Oracle support and they use DUL for extract data from datafile to dump file and I import everything is done and no error but when I check in CLOB datatype that have space(blank character) separate each character see below Or[More]

QUERYING CLOB DATATYPE

Category:DefaultRelease time:2015-10-11Views:130

Hello Everyone, Before I go to my question let me give you the context. I wanted to upload the description of a set of products with their IDs into my database. Hence I created a table 'demo' with two columns of INT and CLOB datatypes using the follo[More]

Importing CLOB datatype

Category:DefaultRelease time:2015-10-11Views:130

Dear All, I'm facing a problem whle importing a table (specifically a column with CLOB datatype) to the existing tablespace as explained below. Kindly let me know the solution, you can mail me to [email protected] Importing a CLOB datatype from a dif[More]

CLOB Datatype (Assgin more than 32k fails)

Category:DefaultRelease time:2015-10-11Views:130

Dear All Can anyone tell me why i am getting this error if i assign more than 32k character to clob variable in pl/sql but i can assign it from table to a variable Pl/sql 1(ORA-06502: PL/SQL: numeric or value error: character string buffer too small)[More]

CLOB Datatype with JDBC Adapter

Category:DefaultRelease time:2015-10-11Views:130

Hi, we try to fill a Clob Datatype to JDBC Database. We try 2 ways with the JDBC Adapter: action="SQL_DML" with an SQL Statment and $placeholders$ But how can i say the key element that it is a CLOB type? He used this a VARCHAR and there a not m[More]

Using CLOB datatypes in WHERE clause

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have a table with two columns as CLOB datatype. I'm using Oracle 8i Enterprise Edition. I can do a query, insert, update and even delete the data in the CLOB field using Oracle's SQL Plus. What I want is to do a search on those fields.. tha[More]

Hot
Attached is the error log. I've tried creating a new library and running disk utility. iPhoto crashes after a few minutes of use, especially when trying to edit photos. Any advice? The crashing is chronic and has occured for some time now (months). P [More]
I currently have a mac version 10.4.11 (2 GHz Intel Core 2 Duo), and I am unable to download the new version of itunes or sync my iphone with this. How do i go about updating my software? My computer says no system updates available.You need to purch [More]
The constructor won't allow me to use the variable I am passing in to it through my main class for my arrayList size. Method class: public class CList {      public CList(int d) {           int index = d;      int[] arrayList = new int[index];      p [More]
Hi All, I am using SBO 2005 B. After adding Excise Invoice and Comm. Invoice. I am checking the A/c. effect from Comm. Invoice -> Accounting Tab. and click on the link. It is creating two entries. The Entry it opens is as below.. Account              [More]
WWant to move want to copy music from one iTunes account to another.Hello, Sharbs17.   Thank you for visiting Apple Support Communities.   I understand that you want to transfer previously purchased music to a new Apple ID.  At this time all purchase [More]
I have a UK iTunes account but am currently living in Qatar and for banking reasons wish to make purchases using a Qatar credit card only.  For some idiotic reason Apple will not allow me to do this.  If I have to open a new account to use my Qatar c [More]
Hello, I understad that I can add both Catalysts to MARS and that I can add primary FWSM as a module to primary catalyst as well. But how can I add secondary FWSM. Any ideas appreciated ThanksIf you have already configured the primary, you don't have [More]
My iMAC G5 has had it's second logic board failure in the past 1.5 years. The repair shop says it's going to cost $550 to repair, and Apple's not going to cover a 2nd board replacement under the extension program. Given that the computer's 4 years ol [More]
Hi Experts, when we create a variable normally will get a icon of the variable which say equal to symbol on the varaible icon. Hope everybody know that. Now how can we change that variable icon to less than or equal. Please can you provide me that in [More]
Hi everyone, I have some existing C++ application code that extracts data from a file in a special format (HDF5). This code uses a static library (third party) to decode the file format. I would like to wrap this application code in a JNI wrapper so [More]