1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

Question Posted / dev

Answers were Sorted based on User's Feedback



My select statement is not working as expected, So, to overcome from such issues what are the steps ..

Answer / nitin

Possibe Scenarios
1. Check table is being locked by any other resourse.
2. Table reach to HIGH WATER MARK, resuse the storage or SHINK SPACE could overcome this problem.
3. Check the data volume.
4. Table or index(if any) is analysed or their stats are gather or not.

Is This Answer Correct ?    2 Yes 0 No

My select statement is not working as expected, So, to overcome from such issues what are the steps ..

Answer / 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

More SQL PLSQL Interview Questions

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

What is example of database?

1 Answers  

What is delimiter in pl sql?

1 Answers  

can we call a procedure from a function?

9 Answers   Mind Tree,

What is partition in sql query?

1 Answers  

How do I order by ascending in sql?

1 Answers  

Explian rowid, rownum? What are the psoducolumns we have?

1 Answers  

How many tables can a sql database have?

1 Answers  

Is left join inner or outer by default?

1 Answers  

Is record in oracle pl sql?

1 Answers  

What is count * in sql?

1 Answers  

Can we call a function containing dml statements in a select query?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories