Question { HSBC, 6473 }

How to fetch records from a partitioned table?

Answer

select * from tabe_name partition (partition_name );

Question { CG, 3478 }

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

Answer

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.

Question { HSBC, 11447 }

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

Answer

Yes we can, the trigger will get compile also if you use commit inside it and that is without using PRAGMA AUTONOUMS TRANSACTION, but when you execute the DML operation it fails to execute.

So in compilation you won't get any error and while execute trigger will throw error.