i have migrate sql server oracle database obligated change bulk query use lot of delimeted csf files. of various of them use below bulk query in sql server. know equivalent query in oracle database? :
alter procedure [dbo].[bulk] @filename nvarchar(128), @table nvarchar(400) begin declare @query nvarchar(max) set @query =n'bulk insert ' + n'.' + quotename(@table) + n' '+ quotename(@filename , '''') + n' ( datafiletype = ''char'', fieldterminator = '','' , rowterminator = ''\n'')'; --print @query exec (@query) end
so need import data file table, right?
there few ways this, if you're talking bulk data need high-performance insert on, , it's going regular job, set external table. query able database, , configured read data file.
it not need insert data table, can treat regular table can query.
alternatively can:
insert /*+ append */ my_database_table select * my_external_table; if have file on client machine , need insert database sql*loader tool you. it's similar technology external table.
have @ oracle docs, , have crack @ method seems suitable, , if stuck ask question sample of data need insert , code far.
