Database is hung. Old and new user connections alike hang on
impact. What do you do? Your SYS SQLPLUS session IS able to
connect.
No Answer is Posted For this Question
Be the First to Post Answer
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
What to do if dba lost the system password?
How do you handle duplicate records in a database?
What are the common oracle dba tasks?
How to enter a new row into a table interactively?
How to pass a parameter to a cursor in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
What is the difference between view and materialized view in Oracle?
How to sort the query output in oracle?
Can u make a synonym for deptno=10 only from emp table.
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?