Oracle

[Amar]

can anyone tell me how to insert data into database tables by using where condition in oracle ?

[ruchi_patel]

in oracle we can not write where condition but we can write where condition in the select statment

[donald]

i am not getting your question properly......
what you want to do...?
table in oracle.........?
tell me some thing more for that.....
.......CONFUSED.........

[djk]

can anyone tell me how to insert data into database tables by using where condition in oracle ?

first you create the table .
and using the query.
for insert also use insert (data), type of the data.
this is the way for it

[donald]

first you create the table .
and using the query.
for insert also use insert (data), type of the data.
this is the way for it

i am not getting clear idea from that...
can you explain me with some more details.......
....CONFUSED.....

[seanslotter]

can anyone tell me how to insert data into database tables by using where condition in oracle ?

Using WHERE statement is no use for inserting data but in updating data, deleting data and query the data.

[anurdh65]

insert ,into table name where column name = relevant info
or
insert ,into table name where tablename.column name = relevant info

[donald]

Using WHERE statement is no use for inserting data but in updating data, deleting data and query the data.

if i have made my table already in mssql...
and then i want to add one new column then how it can be done...???
please tell me.......

[anurdh65]

Hi,


alter table <table name> add < column name> variable

This is the procedure for add new column in a table

[donald]

Hi,


alter table <table name> add < column name> variable

This is the procedure for add new column in a table

hey my question is after the making the column how can i fill directly that particular column...???
i can not fill the data directly intio that extra added column....
thanks......!!