title: populate the database in oracle (sqlplus)
body: <p>I have a database with a bunch of tables and I want to populate the database using the SQL insert command. Now I am new to this so cut me some slack. Now here is an example: </p>
  
  <p>I have a table like this </p>
  
  <pre><code> TECH PERSONNEL (pplSoft, fname, lname, pittID, expertise, office phone)
  </code></pre>
  
  <p>Where fname is first name, and lname is last name. And I want to put in </p>
  
  <pre><code>table TECH_PERSONNEL 
  
  pplSoft  fname     lname    pittID  expertise        office_phone  expYears  supervisor
  
  
  1110001  Bob       Hoffman  bh1     Unix systems     412-624-8404  15        1110001
  
  1110002  Terry     Wood     tw1     Hardware         412-624-8831  14        1110001
  </code></pre>
  
  <p>However there is many lines of data for that table would I have to put code such as </p>
  
  <pre><code> INSERT INTO TECH_PERSONNEL pplSOFT ('1110001', '1110002'); 
  </code></pre>
  
  <p>after the declaration of my table? I'm just confused.</p>