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 |
why use cursors?
What are different sql data types?
How do I remove duplicates in two columns?
Can %notfound return null after a fetch?
if a string is there like s1,s2,s3,s4.How to find count of commas in this.
Is big data nosql?
What is sqlerrd?
What is a sql trace file?
What are local and global variables and their differences?
Why indexing is needed?
define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.
Does user triggers have entry for trigger with compilation errors?