# Inserting a column when altering a table

**URL:** <https://forums.toadworld.com/t/inserting-a-column-when-altering-a-table/40667>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 6, 2018, 9:33am UTC](https://forums.toadworld.com/t/inserting-a-column-when-altering-a-table/40667 "2018-03-06T09:33:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![William.Stallings](https://avatars.discourse-cdn.com/v4/letter/w/74df32/32.png) [@William.Stallings](https://forums.toadworld.com/u/William.Stallings)\
**Post date:** [March 6, 2018, 9:33am UTC](https://forums.toadworld.com/t/inserting-a-column-when-altering-a-table/40667/1 "2018-03-06T09:33:01Z")

</div>

How can you insert a column into an existing table when altering that table?

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [March 7, 2018, 12:57am UTC](https://forums.toadworld.com/t/inserting-a-column-when-altering-a-table/40667/2 "2018-03-07T00:57:14Z")

</div>

alter table xxxx add (col\_yyy number);
