Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CLOB and Impromptu
- Thread starter windjuly
- Start date
Hi Windjuly,
Yes, Impromptu 7 supports Oracle CLOB data type. If you want to extract data from the CLOB, you first need to create a table containing an XMLType column. Then you can insert the the data from your table that contains the CLOB.
Step 1:
CREATE TABLE TEST_CLOB
{
ID NUMBER (38) NOT NULL,
XML XMLType NOT NULL
};
Step 2:
ALTER TABLE TEST_CLOB
ADD CONSTRAINT TEST_CLOB_PK
PRIMARY KEY (ID);
Step 3:
insert into TEST_CLOB
select id, XMLType(XML)
from ORIGINAL_TABLE;
Finally, you can use the SQL extract command to retrieve the data.
Let me know if this is helpful.
Latonya
Yes, Impromptu 7 supports Oracle CLOB data type. If you want to extract data from the CLOB, you first need to create a table containing an XMLType column. Then you can insert the the data from your table that contains the CLOB.
Step 1:
CREATE TABLE TEST_CLOB
{
ID NUMBER (38) NOT NULL,
XML XMLType NOT NULL
};
Step 2:
ALTER TABLE TEST_CLOB
ADD CONSTRAINT TEST_CLOB_PK
PRIMARY KEY (ID);
Step 3:
insert into TEST_CLOB
select id, XMLType(XML)
from ORIGINAL_TABLE;
Finally, you can use the SQL extract command to retrieve the data.
Let me know if this is helpful.
Latonya
- Status
Similar threads
- Locked
- Question
- Locked
- Question