Answer / satya

Hi,

By using Update command we can update the data in a
table from one value to another value..


Regards,
Satya.k

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.

Answer / kotravel. b

to manipulate the data in exisiting row



by
kotravel
nathakkadiyur
erode

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

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?

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...

Answer / vasan

Update command is used to modify, we can modify column
name,Values etc.,

how to create a database in oracle?please gve anser with example

1 Answers  

Explain the purpose of %type and %rowtype data types?

0 Answers  

What is sap sql anywhere?

0 Answers  

How to get help at the sql prompt?

0 Answers  

What is an invalid partition table?

0 Answers  

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

Can we write dml inside a function in sql server?

0 Answers  

Why schema is used in sql?

0 Answers  

Describe types of sql statements?

0 Answers  

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

How many postgresql users are there, worldwide?

0 Answers  

How do I upgrade sql?

0 Answers