Answer / nishi

select sal, (to_char(to_date(sal,'j'), 'jsp')) from emp;

How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

0 Answers   TCS,

---

What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  

---

Can we create more than one constraint to column ?

6 Answers  

---

What is the function of Optimizer ?

1 Answers  

---

---

How will you identify oracle database software release?

0 Answers  

---

How to write a query with an inner join in oracle?

0 Answers  

---

What are the original export and import utilities?

0 Answers  

---

How to use group functions in the select clause using oracle?

0 Answers  

---

Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 Answers  

---

what are Triggers?

7 Answers   TCS,

---

What is a table in oracle?

0 Answers  

---