I am using an Oracle 8i Database my data contains Clob data.
I am using toad version 7.6 i am able to get the data in
toad but unable to extract the data in excel.when trying to
extract the data into the excel the toad error says out of
memory.
Can any body please help me to extract the data through the
same toad version.
Thanks in advance
No Answer is Posted For this Question
Be the First to Post Answer
Differentiate between post-database commit and post-form commit?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is a trigger and what are its types?
What is a Data Dictionary ?
What are the components of Logical database structure of ORACLE database?
State the difference between a primary key and foreign key?
query optmization techniques and quwry analyser+projects+ppts
What are oracle functions?
How to add a new column to an existing table in oracle?
How many types of tables are there in oracle?
SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.