Gaurav Soni

Gaurav Soni has asked 11 questions and find answers to 19 problems.

Stats

About

A Software Engineer by Fate :StackOverflow is the best Place to learn.

Gaurav Soni questions

auditing 50 columns using oracle trigger
Bulk Collect Twice over same nested table
passing table and column name dynamically using bind variables
PL/SQL: ORA-00942: table or view does not exist V$SQL
difference between explain plan and execution plan
ORA-00947 Not enough values while declaring type globally
Selecting the second row of a table using rownum

Gaurav Soni answers

How to login to the scot account after installing Oracle 11g [closed]
Oracle : How to have only one row active in a table?
when should I go for procedure or function in PL/SQL?
Is it a slow query? Can it be improved?
Difference between SKIP locked and nowait
Use a variable with "LIKE %" (e.g. "variable%") in PL/SQL?
Creating materialized view that refreshes every 5 min
Can an Oracle trigger be disabled for the current session?
Generate a random date in Oracle with DBMS_RANDOM
When should I use 'for update nowait' in cursors?