title: How to get information back from tables in Oracle?
body: <p>Hi i am using oracle sqlplus on the sample HR database tables.</p>
  
  <p>I have 2 tables, employees and jobs in which i have job_id in both of them.</p>
  
  <p>I want to be able to enter the input of the job_ID and then it displays the first_name, last_name (which is inside employees table)</p>
  
  <p>I am new to sql and learning. Thanks in advance</p>