Answer / rupa bagherwal

You can not exactly delete the column value.
alternatively what you can do is use update statment and
update the value with blank.

update users
set user_adr = ''
where user_id = 'userid'

Answer / subramaniam

Rupa Bagherwal is told the answer is correct
we cant delete particular value in one column
we can update onle

delete from employee where employeeid=2

suppose we wil give like this means it will delete one row

for this questions update only possible

Answer / nilesh

Update tablename set Column_name = '' where f_name = 'student'

Answer / nadeer

we can't delete a particular value of column,
instead of this we can make that column value as
blankspace,or u can rewrite a values on it by "update emp
set id=5555 where id=4444;

Answer / krish

DELETE FROM tablenameWHERE columnname AND columnname

Answer / sunil kumar basuru

we cant delete the particular column because oracle two
dimensional structure.but instead of delete we can do column
'null'

Answer / elumalai.k

delete from tablename where columnname=datatype
examples:
delete from employee where employeeid=2

Answer / suresh.s

Example:
Delete from STUDENTDETAILS where StudentID = 101

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

What are the 10 characteristics of data quality?

0 Answers  

Distinguish between commit and rollback?

0 Answers  

List out some of the requirements to set up a sql server failover cluster?

0 Answers  

Explain indexes disadvantages?

0 Answers  

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

Can you name some of the dml commands in sql?

0 Answers  

What is split brain scenario in DB mirroring?

1 Answers  

What are different types of statement?

0 Answers  

How to delete existing triggers using "drop trigger"?

0 Answers  

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

query processing

0 Answers