How can we find out the current date and time in 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,

---

How to check your oracle database 10g xe installation?

0 Answers  

---

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

---

How to export your connection information to a file?

0 Answers  

---

What are the different types of database objects?

0 Answers  

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

0 Answers   MCN Solutions,

---

does Oracle has only one table space?

1 Answers   Oracle,

---

What are group functions in oracle?

0 Answers  

---

what is primary key and foreign key when and where have to use

5 Answers  

---

What is the difference between 10g OEM and 11g OEM?

0 Answers   MCN Solutions,

---

what is the difference between data migration and production migration.

0 Answers  

---