I am trying to insert data into table from an text file. One of my field is having carriage returns in between such as given below :-
This is the
test data and we
cannot work with it
suppose the data field name is description. My problem is when I am using the following control file to load the data in sqlldr :-
INTO TABLE JOBS
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
with the above control file it is not loading the data properly in description field all other fields it is loading data for first record. Wherever carriage returns are there in description field its breaking the information and taking data to new record in the first field such as reqnum. Can anybody help me out from this problem.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Subquery in Oracle:
Sub queries are one of advance queries in oracle.
Types of advance queries:
• Sub Queries
• Hierarchical Queries
• Set Operators
Sub queries are know as the query called from another query or another subquery. It can …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines