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
How to delete an existing row from a table in oracle?
How many types of cluster table in Oracle?
How to convert a string to a date in oracle database?
What is a Schema ?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
How to view the tablespaces in the current database?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
What are the Limitations of a CHECK Constraint ?
What types of joins are used in writing subqueries?
What are the different types of record groups in oracle? Explain each of them
How do I limit the number of rows returned by an oracle query after ordering?