Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of UPDATE command?
- 8 Answers
- 12281 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 define and use table alias names in oracle?
what is the difference between sql& oracle?
What happens if you set the sga too low in oracle?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Explain the use of inctype option in exp command.
What is Java Pool in Oracle?
What is index in Oracle?
what is the difference between substr and instr function in oracle?
What does COMMIT do ?
How to end the current transaction in oracle?
Oracle General 
