Answer Posted / arkchowdary

we use Dept table or Any table Insert Command

Insert into dept(Dname,deptno,location.....)values
('Darway',30,'Sweadon');

Or

Insert into dept values('&dname',deptno,'&location'....)

How to use existing values in update statements using oracle?

1069

---

What is query image?

985

---

Please explain drop constraint oracle?

1112

---

What are the varoius components of physical database structure of oracle database?

1006

---

How to rename an index?

1073

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1051

---

How to define a variable to match a table column data type?

990

---

How can Oracle users be audited?

1118

---

How to define a variable of a specific record type?

1078

---

What is the difference between substr and instr?

1038

---

What is a proxy class?

1059

---

How to get execution statistics reports on query statements?

1095

---

What is meant by joins?

1062

---

Does oracle charge for java?

1058

---

What is the relationship among database, tablespace and data file?

989

---