Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of UPDATE command?
- 8 Answers
- 12312 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 do we get field details of a table?
How can we find out the current date and time in oracle?
What is the order of defining local variables and sub procedures/functions?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
how do u know the total no of rows in a table?
how may join possible between (requisition with purchase order)
Which are the five query types available in oracle?
What are the various oracle database objects?
How to select some rows from a table in oracle?
does the query needs a hint to access a materialized view?
What is a deadlock in SQL? How can you prevent it?
What is a cluster?
Oracle General 
