How can we add a column to a table without altering the same?

How can we add a column to a table without altering the
same?

Question Posted / s.sandip

4 Answers
20599 Views
BNP Paribas, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we add a column to a table without altering the same?..

Answer / shoaib

you can add new column by using CAST keyword.

Eg:

Suppose your existing table say #EMP contain the following
Columns:

empid,
empname,
empaddr

you want to add empsal columns.

Query:
select
empid,
empname,
empaddr,
(null as decimal(18,2))empsal
from #EMP
into #EMP1;

Is This Answer Correct ?

18 Yes

10 No

How can we add a column to a table without altering the same?..

Answer / sandip

Thanks Devraj.
But i just mean is their any way of adding colum without
using alter statement?

Is This Answer Correct ?

8 Yes

9 No

How can we add a column to a table without altering the same?..

Answer / sanjay rawat

In oracle,
1. take data in new table from existing table
2. add a new column in new table by using alter command
3. drop existing table
4. rename new table with existing table name
5. Check by select query

Is This Answer Correct ?

1 Yes

3 No

How can we add a column to a table without altering the same?..

Answer / devraj

In Oracle - create nother table with new column
2. insert complete data into this
3. drop orignal table
4. rename the created table to orignal table

Is This Answer Correct ?

12 Yes

26 No

Post New Answer