Answer / rajesh venati

It is also work,

UPDATE TABLE_NAME SET COL_NAME=NEW_VALUE WHERE
COL_NAME=OLD_VALUE;

EX:-

SQL> SELECT * FROM RAJ;

EMPNO
----------
100
200
300
4

SQL> UPDATE RAJ SET EMPNO=400 WHERE EMPNO=4;

1 row updated.

SQL> SELECT * FROM RAJ;

EMPNO
----------
100
200
300
400

Answer / geetha

create a table with one column
select sno,rowid from test_table;
then use the rowid to update the col..
update test_table set sno = value where rowid =' '

Answer / manjuanth

Answer - point 1, 2, 3, and 4 All are correct.

Answer / prerit

update table_name set coloumn_name=value;

Answer / geetha

create a table with one column
select sno,rowid from test_table;
then use the rowid to update the col..
update test_table set sno = value where rowid =' '

How to avoid duplicate records in a query?

0 Answers  

Explain the concept of normalization.

3 Answers  

How does one load ebcdic data? : aql loader

0 Answers  

what is the order of pre-defined exceptions.

6 Answers   TCS,

Can unique keys be null?

0 Answers  

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

What is sql constant?

0 Answers  

How do you create a db file?

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 does pl sql developer do?

0 Answers  

What is foreign key sql?

0 Answers