What is difference between cartesian join and cross join?
No Answer is Posted For this Question
Be the First to Post Answer
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain the features of oracle?
How to change user password 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
Define Normalization with example?
How to recover a dropped index?
What is an Index Segment ?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is the meaning of recursive hints in oracle?
Explain the use of online redo log files in oracle.
How to get execution path reports on query statements?