Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of UPDATE command?
- 8 Answers
- 12033 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 |
Explain the dml?
What is the difference between primary key and unique key and foreign key in oracle?
Does oracle database need java?
How would you optimize a slow SQL query?
how to produce numbers from 1 to 10 using dual table
What is null value in oracle?
sql query to get zero records from a table
Can the default values be assigned to actual parameters?
what r routers?
Can we write dml statement in function in oracle?
How to pass parameters to procedures in oracle?
What happens if you lost a data file?
Oracle General 
