Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of UPDATE command?
- 8 Answers
- 11956 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 find full database size
1 Answers BirlaSoft, Consultancy,
What is the use of oracle?
What does ROLLBACK do ?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
how to retrieve data from different tables ,place this data in different excel worksheets.
Is oracle a relational database?
25. Display the client number and the value of the highest value order placed by that client.
How to increment dates by 1 in oracle?
How to compare dates in oracle sql?
how many types of index?
How to write a left outer join with the where clause in oracle?
How to define and use table alias names in oracle?
Oracle General 
