what is the purpose of update command in oracle?
Answers were Sorted based on User's Feedback
Answer / zikku
update command sets the values of a particular column .
using this command we can manipulate data within a database.
update command can be used with where clause.using this we
can set the values in a column at any time.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kotravel. b
to manipulate the data in exisiting row
by
kotravel
nathakkadiyur
erode
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / highness
Update command is used to change the value of an
column/s (field) of a table
or
to change an existing value/s of a table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vidhun
update command is used to modify the values of existing
data.
here where clause is used to check the condition where we
want to make change?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kiran kumar
update command is used to modify the existing column by
using where clause...
if we dont use the where the enitire columns in the table is
updated...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vasan
Update command is used to modify, we can modify column
name,Values etc.,
| Is This Answer Correct ? | 1 Yes | 2 No |
how will be date change into string
Why do we need pl sql?
what is cursor procedure
Name the different types of indexes in sql and define them.
Explain autonomous transaction.
what are the join types in tsql? : Transact sql
What is the difference between rollback and rollback to statements?
What is time based sql injection?
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What is magic table?
What is trigger explain it?
What are synonyms in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)