Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.
- 8 Answers
- 32810 Views
- Intelenet, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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'
| Is This Answer Correct ? | 96 Yes | 12 No |
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
| Is This Answer Correct ? | 31 Yes | 7 No |
Answer / nilesh
Update tablename set Column_name = '' where f_name = 'student'
| Is This Answer Correct ? | 17 Yes | 7 No |
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;
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / krish
DELETE FROM tablenameWHERE columnname AND columnname
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / sunil kumar basuru
we cant delete the particular column because oracle two
dimensional structure.but instead of delete we can do column
'null'
| Is This Answer Correct ? | 2 Yes | 5 No |
delete from tablename where columnname=datatype
examples:
delete from employee where employeeid=2
| Is This Answer Correct ? | 13 Yes | 71 No |
Answer / suresh.s
Example:
Delete from STUDENTDETAILS where StudentID = 101
| Is This Answer Correct ? | 20 Yes | 82 No |
What are the 3 types of schema?
What are dml triggers and types of dml triggers?
Write a program to fetch first 10 records from a file?
Define DML and DCL statements?
How do I setup a local sql server database?
What is the use of MOVE keyword in restore command
What is a view? is View updatable?
17 Answers IBM, L&T,
What are partitioned views and distributed partitioned views?
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
What is normalization of database? What are its benefits?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is the Difference Between Primary and Foreign Key?
0 Answers Accenture, Deloitte, JPMorgan Chase, Maveric,
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
