How to load text file content into CLOB column using Oracle sql loader

How to load text content into oracle table CLOB column?

---------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------

This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 10 years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

---------------------------------------------------------------------------------------------------------------------------

[kartheekbeeramjula]

Hi Siva, Thanks for sharing videos with clear explanation.
Please can you share a video on - How to load pdf file content into a table column with and without using Oracle sql loader

[mahnars]

Please explain the same process of inserting and retrieve the clob and blob using procedure plsql

[svivekviswesh]

Hi Siva, your video is very useful to learn about loading text files into Oracle tables. Can you also provide some insights on how to export clob columns from oracle database? I am trying to export clob data from my oracle database and import the same into SQL server using varchar(max) datatype. Thanks in advance.

[shivakrishna]

Hi siva, I have a table column as CLOB, when i am running select statement on this table column in sql developer via Run Script F5 it only prints limited data, how to get complete data in this case

[swapnilpatil]

if i have a flat file, delimited by, nad have string larger than 4000 thnen how to load using sqlldr

[LGGift]

how your brain is working bro greate..thank you ..

[surendarsakthivel]

1. can we use blob datatype to store .txt file which contains unicode characters ?
2. And please suggest if we can use blob to store json, xlsx and xml files.

[rammurthybhukya]

HI Siva, Can you advise, how to load TEXT file without any DELIMITER using SQLLDR or external file concept

[gomathinama]

Can you post a vedio on how to load binary content also

[robertcrues]

How can I load excel file data (not CSV file)to Oracle db without using SQL developer or toad. It would be Really helpful

[suryaSaimanisetty]

Hi Siva, Could you please help me in how to create a .ctl file ?

[robertcrues]

Hi Siva,
How load multi line data into oracle column. Please do the needful

Thanks in advance