Can you tell me how to add new column in existing views?how?How is possible?

0 Answers   FIS,

---

What are the ansi data types supported in oracle?

0 Answers  

---

which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help

5 Answers  

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

what is the difference between substr and instr function in oracle?

0 Answers  

---

---

What is the difference between a user and a schema in oracle?

0 Answers  

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

0 Answers   Oracle,

---

What are the differences between interval year to month and interval day to second?

0 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

What are the different types of record groups in oracle? Explain each of them

0 Answers  

---

what is the use of rank function?

1 Answers  

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

0 Answers  

---