title: Oracle text search across multiple tables and columns
body: <p>In my java web application want to put "global search" text box that would search against multiple tables (different columns) using "Oracle Text"? </p>
  
  <p>e.g. </p>
  
  <p>Table Student {name}</p>
  
  <p>Table Teacher {name}</p>
  
  <p>Table Department{name, description}</p>
  
  <p>Table subject{name, title}</p>
  
  <p>Now what I would like to do is that if user enter "Chem" that this word should be searched against Student:name, Teacher:name, Department:name, Department:description, Subject:name, Subject:title column and it would sort the result according to its Oracle Text Score?</p>
  
  <p>Can anyone advise what the best way to achieve this? Not sure how to search all those column across multiple tables with single query using "Contains" oracle text function?</p>
  
  <p>Also, please assume no relation between tables. Thanks in advance!</p>