How do we get field detail of a table?
No Answer is Posted For this Question
Be the First to Post Answer
How are the index updates?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
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 pass a cursor variable to a procedure?
What are triggers in oracle?
What is a system tablespace?
How to define an oracle sub procedure?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
Explain implicit cursor.
What is Redo Log Buffer in Oracle?
How to list all indexes in your schema?