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

What is the fillfactor concept in indexes?

0 Answers  

What is the difference between primary key and unique constraints?

0 Answers  

Explain cdc and sql injection?

0 Answers  

What is equi join with example?

0 Answers  

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

How to update a field in SQL after ALTERING a row?

0 Answers   Amdocs,

Where are sql server usernames and passwords stored in the sql server?

0 Answers  

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

Describe in brief databases and sql server databases architecture.

0 Answers  

What are different types of schemas?

0 Answers