Answer Posted / irshad ahmad

SQL> UPDATE table_name SET column1=value,
column2=value2,...
[WHERE condition];
for Example:-
Sql> UPDATE customers SET address = ‘250 Azad Road’ WHERE
customerid = 4;

How to use "while" statements in oracle?

1323

---

what is the difference between functional dependecy and multilevel dependency?

2458

---

Is oracle a programming language?

985

---

Explain the use of online redo log files in oracle.

1036

---

State any two functions of oracle?

1044

---

What is the difference between view and materialized view in Oracle?

1149

---

What is merge in oracle?

1054

---

What happens to the indexes if a table is recovered?

993

---

Please explain joins in oracle?

1059

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1927

---

How to export your own schema?

1007

---

Can we write insert statement in function in oracle?

1089

---

How to view all columns in an existing table?

936

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

---

What is the difference between sharding and partitioning?

986

---