title: Inserting values to table using text file in Oracle SQL
body: <p>I tried to do following task</p>
  <p>First I created a table</p>
  <pre><code>CREATE TABLE my_table(
  order_id Int,
  id_number VARCHAR(50),
  con_number VARCHAR(50),
  action_code VARCHAR(50)
  );
  
  </code></pre>
  <p>I have a text file called index.txt. The contents of the text file are as follows</p>
  <pre><code>[ 2022-01-24 00:38:12 ]|[ URL ]|&quot;https:\/\/kafkawewy.dc.efwe.vb\/app.kyc\/28950294&quot;
  [ 2022-01-24 00:38:12 ]|[ LOG_PARAMS ]|{&quot;order_id&quot;:28450294,&quot;id_number&quot;:&quot;466054543&quot;,&quot;con_number&quot;:&quot;344354501983&quot;,&quot;action_code&quot;:&quot;verifier_approved&quot;}
  [ 2022-01-24 00:38:12 ]|[ RESPONSE ]|&quot;Success\n202&quot;
  [ 2022-01-24 01:15:32 ]|[ URL ]|&quot;https:\/\/kafkawewy.dc.efwe.vb\/app.kyc\/28948509&quot;
  [ 2022-01-24 01:15:32 ]|[ LOG_PARAMS ]|{&quot;order_id&quot;:28945509,&quot;id_number&quot;:&quot;46653156V&quot;,&quot;con_number&quot;:&quot;117546476356&quot;,&quot;action_code&quot;:&quot;verifier_approved&quot;}
  [ 2022-01-24 01:15:32 ]|[ RESPONSE ]|&quot;Success\n202&quot;
  [ 2022-01-24 01:15:45 ]|[ URL ]|&quot;https:\/\/kafkawewy.dc.efwe.vb\/app.kyc\/28951964&quot;
  [ 2022-01-24 01:15:45 ]|[ LOG_PARAMS ]|{&quot;order_id&quot;:28948964,&quot;id_number&quot;:&quot;14896103756&quot;,&quot;con_number&quot;:&quot;345434353024&quot;,&quot;action_code&quot;:&quot;verifier_approved&quot;}
  [ 2022-01-24 01:15:45 ]|[ RESPONSE ]|&quot;Success\n202&quot;
  [ 2022-01-24 01:16:02 ]|[ URL ]|&quot;https:\/\/kafkawewy.dc.efwe.vb\/app.kyc\/28952134&quot;
  [ 2022-01-24 01:16:02 ]|[ LOG_PARAMS ]|{&quot;order_id&quot;:289745834,&quot;id_number&quot;:&quot;1187402899&quot;,&quot;con_number&quot;:&quot;45445946461&quot;,&quot;action_code&quot;:&quot;verifier_rejected&quot;}
  [ 2022-01-24 01:16:02 ]|[ RESPONSE ]|&quot;Success\n202&quot;
  
  </code></pre>
  <p>I want to insert value to table (order_id ,id_number,con_number,action_code) using index.txt file.</p>
  <p>Any one can help me</p>
  <p>Thank you</p>