How can we delete duplicate rows in a table?
does Oracle has only one table space?
What is a cursor variable?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how to find find & delete duplicate rows from two different tables?
How to find out what privileges a user currently has in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
After using set unused can we enable the column again to use? Please give me some answers....
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
difference between imlicit cursor and explicit cursor ?
Why is oracle database so popular?
Whats the benefit of dbms_stats over analyze?