What are the set operators union, union all, minus & intersect meant to do?
No Answer is Posted For this Question
Be the First to Post Answer
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
When do we use group by clause in a sql query?
How to calculate date and time differences 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 meant by magic query
Can a formula column referred to columns in higher group ?
How to set a transaction to be read only in oracle?
What is a static data dictionary in oracle?
What is the difference between Sleep and Wait? (Java)
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.