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

What is keys and its types?

0 Answers  

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

How to rename a column in the output of sql query?

0 Answers  

What is trigger types in sql?

0 Answers  

how to drop an existing table in mysql? : Sql dba

0 Answers  

What is nvl function?

4 Answers   Cap Gemini,

Hi Guys, I have a situation where I need to access the column values from rowtype variable. However, the column names are dynamic. below is sample code: declare Cursor c1 is select * from emp; Cursor c2 is select column_name from xyztable; v_c2 c2%rowtype; v_str varchar2 v_value varchar2(200); begin for rec in c1 loop open c2;---this cursor has column names like EMPLOYEE_ID, FIRST_NAME, LAST_NAME etc. loop fetch c2 into v_c2; exit when c2%notfound; /* now lets say i want to access value of LAST_NAME from cursor c1, so I am writing below code, however it does not work as expected */ v_str:= 'rec.'|| v_c2.column_name; -- this will give me string like "rec.EMPLOYEE_ID" v_value:=v_str; end loop; end loop; end; / Plz help ASAP.Thanks.

2 Answers  

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

Can a composite key be null?

0 Answers  

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,