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 |
Can the query output be sorted by multiple columns in oracle?
How to start your 10g xe server?
Give the constructs of a package, function or a procedure.
How to create a table interactively?
Display Odd/ Even number of records?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
When do you get a .pll extension in oracle? Explain its importance
Can a property clause itself be based on a property clause ?
How to Identify the previously inserted/updated records in already populated table.
Can you have more than one content canvas view attached with a window ?
Give syntax for SQL and ORACLE joins.
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.