Inserting data from table (SELECT) with REF - Oracle Database -

itemprop = "text">

I am trying to insert all data from Pacient table to Pacient_OR table (object relational) table. If there is a column with the Pacient table Pojistovna_ID (foreign key) and in the Pacient_OR table there is the REF to Pojistovna_OR, that is an easy way to (a script). . Both Pojistovna and Pojistovna_OR are filled with the same data, but one is relational, the second is based on the type of object

I tried this (more optical fiber cable):

  insert pacient_or.id, pacient_or.id, pacient_or.id, pacient_or.prijmeni, pacient_or.datum_narozeni, pacient_or.rodne_cislo, pacient_or.telefon, pacient_or.telefon, pacient_or.krevni_skupina, pacient_or.rodinna_anamneza, pacient_or.adresa , Pacient_or.pojistovna) select pacient.id, pacient jmeno, pacient.prijmeni, pacient.datum_narozeni, pacient.rodne_cislo, pacient.telefon, pacient.krevni_skupina, pacient.rodinna_anamneza, Adresa_typ (pacient.ulice, pacient.mesto, pacient.psc ), (Selection Ref (poj) pacient By Isi, Pojistovana_ or pause where Piseepiojistovna_aid = Piajikaid) the pastor;  

This code throws error:

Single line subquery returns more than one line