select * from sms;
Table Structure
----------------------
Message_Clob CLOB
email_subject varchar2(500)
sms_email char(1)
allowed_tags varchar2(4000)
menu_name varchar2(4000)
enabled char(1)
description varchar2(1000)
message varchar2(4000)
service_code varchar2(25)
Sample Data
-------------------
insert into sms (SERVICE_CODE, MESSAGE, DESCRIPTION, ENABLED, MENU_NAME, ALLOWED_TAGS, SMS_EMAIL, EMAIL_SUBJECT, MESSAGE_CLOB)
values ('OTP', null, 'OTP SMS', 'Y', null, null, 'S', 'Your OTP for transaction',
'Your OTP for your SIP registration request under folio <$FOLIO_NO$> is <$USER_ID$>. This OTP will be valid for next 15 mins.
');
Requirement
------------------
I need to export this sms table along with clob column.
I am using oracle 11g.
I am using plsql and I need to move this table from plsql to toad ..
Will you please give suggestion , how to export the table.
Thanks in Advance
Venkat