| Welcome to [SHEPHARD FAMILY ENTERPRISE LLC]. We hope you enjoy your visit. You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. Join our community! If you're already a member please log in to your account to access all of our features: |
| "alter table" syntax from Oracle; Oracle SQL | |
|---|---|
| Tweet Topic Started: Jul 23 2010, 07:46 PM (152 Views) | |
| YouthHelp | Jul 23 2010, 07:46 PM Post #1 |
|
Advanced Member
![]() ![]() ![]() ![]() ![]()
|
We have "alter table" syntax from Oracle to add data columns in-place in this form: alter table table_name add ( 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_table add cust_sex varchar2(1) NOT NULL; Her is an example of Oracle "alter table" syntax to add multiple data columns. ALTER TABLE cust_table ADD ( cust_sex char(1) NOT NULL, cust_credit_rating number ); |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · PL/SQL - SQL Help · Next Topic » |





![]](http://z2.ifrm.com/static/1/pip_r.png)



3:49 AM Jul 11