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 difference between locking and multi-versioning?

0 Answers  

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

Explain the collation?

0 Answers  

How many types of Outer Joins?What are they?

1 Answers  

What are number line correlation administrators will use while working with a subquery?

0 Answers  

Explain how does the report manager work in ssrs?

0 Answers  

What is faster join or union?

0 Answers  

What are pages and extents? : SQL Server Architecture

0 Answers  

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

what is the system function to get the current user's user id? : Sql server database administration

0 Answers