I would like a code example (SQL query ...) in order to read and write an clob (external and internal)
with Oracle8i.
http://www.experts-exchange.com/Database/Oracle/Q_10291376.html
Zones:
OracleDate Answered: 02/11/2000 Grade: A Views: 5
I can logon to an Oracle 8 database without any problems and I have verified that I am connected to Oracle 8.1.6 by running a select * from gv$version query. When I create a new table and add colu...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_11246913.html
When i perform a upload file from local pc to the oracle database( using clob and blob)( the language used is java and JDBC), sometimes i get this error -->ORA-22920: row containing the LOB data to...
http://www.experts-exchange.com/Database/Oracle/Q_11517138.html
Zones:
OracleDate Answered: 10/27/2000 Grade: A Views: 0
my procedure is:
(c1 in denemex.col1%type,
l_clob2 in denemex.col2%type) is
l_clob clob;
amount_var INTEGER:=32768;
buffer varchar2(200);
begin
l_clob := null;
amount_var:=2;...
http://www.experts-exchange.com/Database/Oracle/Q_20024196.html
Zones:
OracleDate Answered: 05/26/2002 Grade: A Views: 0
how to search a clob for a particular pattern whether it
exists or not "irrespective of case(either upper,lower or mixed)" ?
Thanks in advance for Answering My question.
http://www.experts-exchange.com/Database/Oracle/Q_20082916.html
Zones:
OracleDate Answered: 06/05/2002 Grade: A Views: 0
How to use CLOB fields in WHERE clause?
---------------------------------------
create table t (id number, data clob);
...properly inserted number of records having clob data...
select id...
http://www.experts-exchange.com/Database/Oracle/Q_20192922.html
Zones:
OracleDate Answered: 10/23/2001 Grade: C Views: 40
I have table dcs_media_txt with one column as clob datatype
I have inserted data into dcs_media_txt and able to select the data using
select data from dcs_media_txt;
When i write pl/sql p...
http://www.experts-exchange.com/Database/Oracle/Q_20260711.html
Zones:
OracleDate Answered: 03/24/2002 Grade: A Views: 0
Hello,
can you please tell me, how can i insert some data in a clob field?
insert into mytable (num, clob_field) values
(1, '
.
.
.
here is ca. 20kb of text-data
.
.
.
);
I got th...
http://www.experts-exchange.com/Database/Oracle/Q_20485275.html
Zones:
OracleDate Answered: 02/20/2003 Grade: A Views: 0
I have a table "tab1" that has a field "f1" of type Varchar2. But the content needs to be stored in the f1 field of tab1 table is more than 4KB. So I need to replace the table tab1 by "tab2" with ...
http://www.experts-exchange.com/Database/Oracle/Q_20716630.html
Zones:
OracleDate Answered: 10/18/2003 Grade: A Views: 63
folks,
I have written a procedure in Oracle which returns CLOB output parameter which contains Plain HTML code. But I am unable to read the contents of the CLOB parameter. Please let me know If...
http://www.experts-exchange.com/Web_Development/Miscellaneous/Q_20739176.html
