Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of update command in oracle?
- 7 Answers
- 13908 Views
- MBT, I also Faced
- E-Mail Answers
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 |
Can a varchar be a primary key?
Can we create table in function?
Why do we go for stored procedures?
how is exception handling handled in mysql? : Sql dba
How do I run sql profiler?
Why partition by is used in sql?
Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?
What are the advantages of normalization?
Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.
how will you find out the last three records in a table with n no of records and delete them
Why truncate is used in sql?
What is nosql db?
-
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)
