How to define an external table with a text file?
No Answer is Posted For this Question
Be the First to Post Answer
State and explain the different types of data models?
What is an Oracle sequence?
What is the difference between post-database commit and post-form commit?
What is meant by joins? List out the types of joins.
What are virtual columns?
List out the components of logical database structure of oracle database.
What is the difference between sharding and partitioning?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
master table and child table performances and comparisons in Oracle ?
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
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
Shall I get Pro*C Compiler in Oracle-10g release ?