Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of UPDATE command?
- 8 Answers
- 12369 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shalya
UPDATE <table name> SET <column name>=<new value> WHERE
<condition>;
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / guest
update tablename set columnvalue=newvalue where condition;
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / rajini
As per my knowledge first and third one is correct.That is
UPDATE <table name> SET <column name>=<new value> WHERE
<condition>;
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / mohan
update tablename set columnname=newvalues where conditions;
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vishal b. patel
1. Below SP apply for all records of the Table
UPDATE <table name> SET <column name>=<new value>
----------------
2. Below SP apply for those records which are match with
the <condition>...
UPDATE <table name> SET <column name>=<new value> WHERE
<condition>
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / naweed ahmad
UPDATE TABLE NAME SET COLUMN NAME=NEW VALUE
WHERE CONDITION;
--(WHERE CONDITION IS OPTIONAL)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jyoti ranjan samal
Update table name
set <column name>= New value
where <condition>
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guest
select * from tablename
where(col1=>10)update col2=234;
| Is This Answer Correct ? | 2 Yes | 11 No |
How to call a trigger inside a stored procedure?Give an example.
what is shell?
How to login to the server without an instance?
How to pass a cursor variable to a procedure?
Write a simple Store procedure and pass parameter to it ?
What is difference between SQL and SQL*PLUS?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is a relational database management system?
how to clone 9i Database on to 10g Database.
What is system tablespace?
How are the index updates?
Explain a segment?
Oracle General 
