How do I find the database name in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Briefly explain what is literal? Give an example where it can be used?
what is the syntax of update command?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
What are set operators?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
Which are the five query types available in oracle?
How will you write a query to get a 5th rank student from a table student_report?
Can we create more than one constraint to column ?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Explain user account with reference to oracle.