Answer / oracledba

Oracle does not have one tablespace
Minimum tablespaces in Oracle are
SYSTEM,TEMP and UNDO - oracle 9i
SYSTEM,SYSAUX,TEMP and UNDO - oracle10g

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?

0 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

0 Answers  

---

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

How to call a trigger inside a stored procedure?Give an example.

2 Answers  

---

How to initialize variables with default values?

0 Answers  

---

---

can you write commit in triggers?

4 Answers  

---

Explain cascading triggers.

0 Answers  

---

How many types of database triggers exist?

0 Answers  

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

0 Answers   Infosys,

---

Give the various exception types.

0 Answers  

---

What is a trigger oracle?

0 Answers  

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---