<div>
If the data was like what you posted in your original question it is the POSITION that I posted. &nbsp;Unless your data column is first in the file then the control file you posted won't work.<br />
<br />
<a href="https://www.experts-exchange.com/questions/29044154/sqlldr.html?anchorAnswerId=42216129#a42216129" rel="ugc">https://www.experts-exchange.com/questions/29044154/sqlldr.html?anchorAnswerId=42216129#a42216129</a>
</div>


If the data was like what you posted in your original question it is the POSITION that I posted.  Unless your data column is first in the file then the control file you posted won't work.

https://www.experts-exchange.com/questions/29044154/sqlldr.html?anchorAnswerId=42216129#a42216129 [https://www.experts-exchange.com/questions/29044154/sqlldr.html?anchorAnswerId=42216129#a42216129]

<div>
NO, still iam wating for solution
</div>


<div>
&gt;&gt;i tried this my ctl script was successful<br />
<br />
Check the generated LOG file. &nbsp;It may complete but still not load any data. &nbsp;The log file will tell you why.<br />
<br />
If you cannot decipher the file, please attach it.
</div>


>>i tried this my ctl script was successful

Check the generated LOG file.  It may complete but still not load any data.  The log file will tell you why.

If you cannot decipher the file, please attach it.

<div>
<div class="content wysiwyg-content">
Not tested but you might try -<br />
LOAD DATA<br />
INFILE 'yourdatafile'<br />
APPEND INTO TABLE yourtable<br />
FIELDS ENCLOSED BY ','<br />
(<br />
desc &quot;substr(:desc,1,1)&quot;<br />
)<br />
<br />
<br />
first i would like to say thanks<br />
<br />
i tried this my ctl script was successful<br />
<br />
but when iam triying to retriving the data from the table it will show no rows selected <br />
<br />
can u tell me the reason
</div>
</div>


Not tested but you might try -
LOAD DATA
INFILE 'yourdatafile'
APPEND INTO TABLE yourtable
FIELDS ENCLOSED BY ','
(
desc "substr(:desc,1,1)"
)


first i would like to say thanks

i tried this my ctl script was successful

but when iam triying to retriving the data from the table it will show no rows selected 

can u tell me the reason

sqlldr

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.