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

difference between oracle 8i and oracle 9i

8 Answers  

Can we insert in sql function?

0 Answers  

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

What is sql injection vulnerability?

0 Answers  

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

Explain what is sql?

0 Answers  

What is sql server and ase?

0 Answers  

What does plv msg allows you to do?

0 Answers  

What are the blocks in stored procedure?

6 Answers   Microsoft,

Explain 3 basic parts of a trigger.

0 Answers  

What does varchar include?

0 Answers  

What has stored procedures in sql and how we can use it?

0 Answers