Answer Posted / 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

How does rowid help in running a query faster?

1157

---

What are the types of subqueries?

768

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

871

---

Can we create table in function?

730

---

What is the purpose of my sql?

684

---

---

How to use boolean type in select statement?

749

---

Define sql delete statement.

744

---

how to write date and time literals? : Sql dba

698

---

Why having clause is used in sql?

726

---

Which data dictionary views have the information on the triggers that are available in the database?

941

---

what is a relationship and what are they? : Sql dba

749

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1838

---

How can get second highest salary in sql?

690

---

what is the difference between join and union? : Sql dba

720

---

How do you identify a primary key?

813

---