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 ?
2306Hi 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 5686Post New Oracle General Questions
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What to do if the startbd.bat failed to start the xe instance?
What is meant by a deadlock situation?
How to view all columns in an existing table?
What are the different types of record groups in oracle? Explain each of them
Explain mutating triggers.
How to sort output in descending order in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to use "in out" parameter properly?
How to test null values?
Write a trigger example in oracle?
What are the different oracle database objects?
Explain how you would restore a database using RMAN to Point in Time?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Can select statements be used on views in oracle?