what is the syntax of update command?
Answers were Sorted based on User's Feedback
Answer / arijitnit
update table_name set column_name=value where condition
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / shahnaz
UPDATE <TABLE_NAME> SET
COLUMN1=VALUE1,COLUMN2=VALUE2,COLUMN3=VALUE3.... WHERE
<CONDITION>
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ajeet singh
Update <tablename>
set <columnname=values......> where <condition> ;
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an oracle data file?
What is an UTL_FILE.What are different procedures and functions associated with it?
What is the difference between I and G in Oracle?
what is the difference between UNION AND UNIONALL
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What is oracle in java?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
how to use sequence and what use of sequence cache
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
What are privileges and grants?