Interested to Buy Any Domain ? << Click Here >> for more details...
My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
- 2 Answers
- 4626 Views
- CG, I also Faced
- E-Mail Answers
Answer Posted / nitinsharma06
1.Table is being Locked by any other resourse or not.
2.Table is reach to high water mark, REUSE STORAGE or SHRINK SPACE could resolve the issue.
3.Table or Indx(if any) stats are gather or not.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is data types in sql?
How to avoid using cursors?
Is it possible to update views?
what is the use of double ampersand (&&) in sql queries?
what are the differences between char and varchar? : Sql dba
what are date and time data types in mysql? : Sql dba
How can you save or place your msg in a table?
What is difference between hql and sql?
What are sql functions? Describe in brief different types of sql functions?
how to create a table index in mysql? : Sql dba
Explain select statements in sql?
What is the difference between null value, zero, and blank space?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
what is try_catch block in procedure
