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 |
Explain the the update statement in sql?
What is int identity in sql?
create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
What are the two types of exceptions.
What is pls integer?
I need to write a simple query,which one is better select statement or stored procedure?and why?
What are sql functions? Describe the different types of sql functions?
How to write pl sql program in mysql command prompt?
How does postgresql compare to "nosql"?
In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;
Is stored procedure faster than query?
Can dml statements be used in pl/sql?
Oracle (3253)
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)