Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 





Le sildénafil et le tadalafil - en savoir plus sur le site sont des médicaments qui sont utilisés pour traiter la dysfonction érectile. Le sildénafil est le médicament le plus couramment prescrit pour traiter la dysfonction érectile, tandis que le tadalafil est un médicament plus récent qui est également utilisé pour traiter la dysfonction érectile. Les deux médicaments sont efficaces pour traiter la dysfonction érectile, mais ils ont des effets secondaires différents. Le sildénafil est généralement considéré comme plus sûr et plus efficace, tandis que le tadalafil peut être plus efficace pour certains patients. Exemple de syntaxe de colonne: Médicament | Effets Secondaires ------------ | ------------- Sildénafil | Plus sûr et plus efficace Tadalafil | Peut être plus efficace pour certains patients



Oracle alter table add column example

Oracle Database Tips by Donald Burleson

We have "alter table" syntax from Oracle to add data columns in-place in this form:

alter table
   column1_name column1_datatype column1_constraint, 
   column2_name column2_datatype column2_constraint,
   column3_name column3_datatype column3_constraint

Here are some examples of Oracle "alter table" syntax to add data columns.

alter table
   cust_sex  varchar2(1) NOT NULL;

Here is an example of Oracle "alter table" syntax to add multiple data columns.

      cust_sex             char(1) NOT NULL,
      cust_credit_rating   number

Sometimes, we find that a piece of data that we did not maintain becomes important, and we need to add a new table column to the database. We can add a table to hold the new data or add it to our current schema by adding a column to a current table.

For example, we discover that we need to keep a record of the last date that each author published and what they published. We need to add two columns to the author table, author_last_published (a date) and author_item_published (a varchar2(40)). To do this, we use the ALTER TABLE ADD command.

SQL> alter table author add (author_last_published date);

Table altered.

SQL> alter table author add (author_item_published varchar2(40));

Table altered.

SQL> desc author
Name Null? Type
------------------------------------- -------- ------------------AUTHOR_KEY VARCHAR2(11)
. . .

Notice that the new columns are at the end of the AUTHOR table. All current rows in the table now contain NULLs for the new columns.

I added each column separately, but you can add as many columns as needed in one command by separating them with commas.

alter table
   (author_last_published date,
    author_item_published varchar2(40));

If I define a default value for the new columns, all the current columns will have the default value. (I dropped and recreated the original author table.)

SQL> alter table author add (
2 author_last_published date default SYSDATE,
3 author_item_published varchar2(40)
4 default 'Magazine Article' not null
5 );

Table altered.




Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.