Can group functions be used in the order by clause in oracle?
What is the usage of analyze command in oracle?
How do we represent comments in oracle?
Can multiple columns be used in group by in oracle?
Can a field be used in a report without it appearing in any data group ?
What are temporal data types in oracle?
What is the usage of control file in oracle?
How many categories of data types?
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
How to update values on multiple rows in oracle?
How to check the oracle tns settings?
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
What is a Data Segment ?