title: toad for oracle alter table ddl export
body: <p>I use Toad for Oracle v12.6 and able to see DDL export for full table under the Database menu. 
  Does anyone know is it possible to generate DDL for spesific columns of a table?</p>
  
  <p>With an example; I have table <strong>Employees</strong> with 5 columns like:</p>
  
  <pre><code>EmpID    INTEGER,
  Name     VARCHAR2(100),
  SurName  VARCHAR2(100),
  Age      INTEGER,
  Address  VARCHAR2(200)
  </code></pre>
  
  <p>I want to generate alter script for <strong>Age</strong> and <strong>Address</strong> columns only using Toad for Oracle. </p>
  
  <p><strong>Edit:</strong> I do not want to alter the table, I want to have an "alter table add column Age and Address with datatypes" script as below; </p>
  
  <pre><code>ALTER TABLE Employees ADD Age Integer;
  ALTER TABLE Employees ADD Address VARCHAR2(200);
  </code></pre>
  
  <p>Any help would be appropriated. </p>