what is the syntax of UPDATE command?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / ppp

8 Answers
10602 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the syntax of UPDATE command?..

Answer / shalya

UPDATE <table name> SET <column name>=<new value> WHERE
<condition>;

Is This Answer Correct ?

23 Yes

2 No

what is the syntax of UPDATE command?..

Answer / guest

update tablename set columnvalue=newvalue where condition;

Is This Answer Correct ?

9 Yes

0 No

what is the syntax of UPDATE command?..

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

what is the syntax of UPDATE command?..

Answer / mohan

update tablename set columnname=newvalues where conditions;

Is This Answer Correct ?

5 Yes

0 No

what is the syntax of UPDATE command?..

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

what is the syntax of UPDATE command?..

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

what is the syntax of UPDATE command?..

Answer / jyoti ranjan samal

Update table name
set <column name>= New value
where <condition>

Is This Answer Correct ?

1 Yes

0 No

what is the syntax of UPDATE command?..

Answer / guest

select * from tablename
where(col1=>10)update col2=234;

Is This Answer Correct ?

2 Yes

11 No

Post New Answer