python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How to load special characters (non-English letters) in SQL Loader
Some of my developer_id are in foreign language (special character). I googled how to handle those characters, and what people said was using
NVARCHAR2()
or use:
INSERT INTO table_name VALUES (N'你好')...
sweetlemon
Votes: 0
Answers: 0
Loading a huge CSV file with high performance in Oracle table
I have a CSV File which its size is about 20 Gig. The file has three Persian columns. I want to load it to Oracle Table. I searched and found that sql loader has high performance. But, when I load the...
M_Gh
Votes: 0
Answers: 1
Find length of a column in Sql loader
I am trying to add a missing ending double quotes using sql loader code for a specific column. Looks like "LENGTH" is not a valid sql loader command.
Eg:
SR_ARTIST_TX CHAR(400...
Bharathi mohan
Votes: 0
Answers: 1
sql loader case statement- how to populate a column based on another table and column values
I have a table named Addresses(having multiple address line num column) and another table named Phy_Addr
Table 1: Addresses
Columns: EmployeeID, Addr_Line_1, Addr_Line_2, Addr_Line_3
Table 2: Phy_Add...
Darshak
Votes: 0
Answers: 0