id      link_id         code            Type
1001    2001            ABC-123         Reg
1002    2002            ABC-345         Reg
1003    2003            ABC-123         Act
1004    2004            ABC-123         Reg

{
  "took": 4,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 9,
    "max_score": 12.906438,
    "hits": [
      {
        "_index": "replacement",
        "_type": "doc",
        "_id": "VizyEWQB3JLlyWOUWyyY",
        "_score": 12.906438,
        "_source": {
          "@timestamp": "2018-06-18T08:10:53.037Z",
          "@version": "1",
          "link_id": 2001,
          "type": null,
          "id": null,   // ----> this is have some value in oracle DB
          "code": "ABC-123",
         }
      },

input {
  jdbc {
    jdbc_driver_library => "D:1SearchEnginedataojdbc8.jar"
    jdbc_driver_class => "Java::oracle.jdbc.OracleDriver"
    jdbc_connection_string => "jdbc:oracle:thin:@localhost:1525:XE"
    jdbc_user => "demo"
    jdbc_password => "abc2011"
    statement => "select * from product
                    FULL OUTER JOIN product_link
                    ON product.id=product_link.product_id
    }
}

output {
  elasticsearch {
    hosts => ["localhost:9200"]
    index => "replacement"
  }
}