set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go Create PROCEDURE [dbo].[import_csv_dec] @user_created varchar(40), @file_name varchar(200) AS DECLARE @Err INTEGER DECLARE @ErrMsg VARCHAR(200) RETRY: BEGIN TRY –BEGIN TRANSACTION declare @jum int set @jum = (select count(*) from tbl_ft100_dec where file_name=@file_name) if @jum<1 begin exec (‘delete from tbl_ft100’) exec (‘delete from tbl_ft100_dec where file_name=”’+@file_name+””) exec (‘BULK insert tbl_ft100 … Continue reading
Create database directories Execute the following commands to create a database directory. This directory must point to a valid directory on the same server as the database: Login SQLPlus 1. Start Menu > run > type “cmd” <enter> 2. c:\>set oracle_sid=<oracle_sid> 3. c:\>sqlplus system/<pwd> SQL> CREATE DIRECTORY dmpdir AS ‘/opt/oracle’; Directory created. SQL> GRANT read, … Continue reading