title: How to backup table data to a simple text file using SQL query in sqlplus
body: <p>I have tried to load data following:</p>
  
  <pre><code>create table emp_data (fname varchar2(20), lname varchar2(20))
  
  orgaization external(type oracle_loader default directory dir1
  access parameters( records delimited by newline
  NOBADFILES NOLOGFILES fields terminated by ','
  (fname char,lname char))
  location('t1.txt'))
  parallel 5
  reject 200;
  </code></pre>
  
  <p>I am learning SQL. i learn how to upload data from a text file to the database using ORACLE_LOADER, but i want to simultaneously back up my data from tables into a simple text file. </p>
  
  <p>How to back up data from particular table on a simple text file using SQL in sqlplus environment (RED HAT)?</p>