| How can alter the table [message #68951] |
Tue, 02 October 2001 23:56  |
Viswanatha Reddy
Messages: 1
Registered: October 2001
|
Junior Member |
|
|
My problem is i am having one table (EMPLOYEE) in that i am having ENO,ENAME,SAL . That tbale contains 100 records. Now i want to create same table with the same name (EMPLOYEE) with the fields ENO,ENAME,SAL,ADDRESS,CITY,PIN. while creating i should not lost the existing data. i am facing this problem can any one help me with example
Regards,
Viswanatha Reddy
----------------------------------------------------------------------
|
|
|
|
| Re: How can alter the table [message #68955 is a reply to message #68951] |
Wed, 03 October 2001 09:43  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
Alter table employee
e.g:
alter table employee add address varchar2(30);
alter table employee add city varchar2(30);
alter table employee add pin varchar2(10);
SURESH
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
