If your database is running slow from last 2 hrs.you can't wait for Statspack report generation. What will be your first step to handle the problem? Where can be the problem?
Explain how the cursor can become stuck between two items, resulting in a navigation trap.
Latest Answer: It can be some application interacting the oracle as a server/database. Forms, Toad etc. ...
Latest Answer: Dude Remember!when its your first job you should say"It doesnt matter if you pay me less or more i believe with my good work I would get a handsome salary today or tomorrow and I am sure organisation of your repute doesnt have salary indifferences I am ...
Latest Answer: Try thisCREATE OR REPLACE FUNCTION FIN2008.rowtocol( p_slct IN VARCHAR2,p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2AUTHID CURRENT_USER ASTYPE c_refcur IS REF CURSOR;lc_str VARCHAR2(4000);lc_colval VARCHAR2(4000);c_dummy c_refcur;l number;BEGINOPEN ...
Latest Answer: with triiger we can do this......but in sql there is no such thingbut we can do it by viewfor example emp1 is a table and emp2 is view .if you iinsert rows into view tht may maynot reflect in the base table ...
hi how to place different column in on columneg:if we have address column in that we have to place addr1,addr2,addr3.
Latest Answer: Generally oracle uses Cost_based optimisation. In this method it will calculate all the execution plans for the query to execute and chooses the best optimal plan. Sometimes we may know the best execution plan to you rather which is selected by optimisation ...
Latest Answer: B-Tree indexes are usually associated with the index that stores a list of ROWIDs for each key.While Bitmap is also organized as B tree , but the leaf node stores a bitmap for each value instead of a list of ROWIDs. B tree can be used for OLTP while bitmap ...
Latest Answer: nvl2 function is the upgraded form of nvl function.In nvl function we need to pass two parameters.i.e. nvl(interest_rate ,returned_value) if the value of interest_rate is null then the nvl function returns the value of second parameter 'returned_value'.In ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
