SQL Plus - what is ALTER TABLE?HOW WE USE IT TO ADD A NEW ROW?

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 98 of 132

what is ALTER TABLE?
HOW WE USE IT TO ADD A NEW ROW?

Total Answers and Comments: 6

Last Update: July 06, 2006 Asked by: ing huang

Sponsored Links

Best Rated Answer

—

Submitted by: na123

Alter table is a DDL language.we cannot insert a new row thr' alter command but we can add new column thr' Alter command.

Above answer was rated as good by the following members:
ashaRane

February 28, 2006 22:43:09

sivakumar

RE: what is ALTER TABLE?HOW WE USE IT TO ADD A N...

Alter is a DDL command which is used to change the structure of the table.We cant add a new row using the alter but we can do with insert which is a DML command.

Is this answer useful? Yes | No

March 03, 2006 11:03:10

rupal

Member Since: March 2006 Contribution: 16

RE: what is ALTER TABLE?HOW WE USE IT TO ADD A N...

Alter table is DDL language which is allow us to edit table schema. The syntax is following: alter table <tablename> <add/subtract/modify> <column_name> <datatype(length)>;

Is this answer useful? Yes | No

March 21, 2006 01:54:49

pawan ahuja

Member Since: March 2006 Contribution: 6

RE: what is ALTER TABLE?HOW WE USE IT TO ADD A N...

Alter is a ddl statement thru which we can modify the datatype add the column etc.

only insert is command thru whic u can be insert the data.

Regards

Pawan Ahuja

Is this answer useful? Yes | No

March 24, 2006 10:38:21

na123

Member Since: March 2006 Contribution: 10

RE: what is ALTER TABLE?HOW WE USE IT TO ADD A N...

Alter table is a DDL language.we cannot insert a new row thr' alter command but we can add new column thr' Alter command.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 28, 2006 02:23:57

Abdul Mannan

RE: what is ALTER TABLE?HOW WE USE IT TO ADD A N...

to insert a column in a table dml command should be used i.e. INSERT. A column cannot inserted in a table through ALTER command - only the data in a table is modified thru alter.

Is this answer useful? Yes | No

July 06, 2006 09:04:04

sandeep dasari

RE: what is ALTER TABLE?HOW WE USE IT TO ADD A N...

by using alter table we can alter only column not the rows. by using alter command we write query like this........

alter table table_name add column_name datatype;

for drop that column ;

alter table table_name drop column_name datatype;

it's the answer.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank