Here is my weird situation..nnHave been always interested in working with Oracle technologies and have always enjoyed exploring it to my level atleast if not to expert level .nYour site is huge bonus for me..if answering questions gives you kick......

nSELECT HIST_COST n FROM STORE_DETAIL_HISTORYn WHERE HIST_MONTH MONTHn AND KEY_NUM KEY_NUMn AND HIST_TYPE HIST_TYPEn ......

hi Tom nnwhy the bellow queries is not working nselect from emp where rownum 10nselect from emp where rownum 10nselect from emp where rownum 10nresult norowsnwhat is oracle mean rownum internally...

Dear Tom nnRecently a user came to me and complained the below query did not return all the required results BrioQuery was used in this case . nnSELECT field_a FROM table WHERE field_a SOMETHING ; nnHis complaint was valid as the column fie......

We are in the planning stages of implementing a fairly large datawarehouse. The current thinking for size estimates is 250 GB to start and to grow by about 100 GB per year. We don t require high availability but we would like to be able to scale-up ......

Tom nnI have a table nnCreate table tn account char 10 n product char 16 n year integer n jansales number 10 2 n febsales number 10 2 n marsales number 10 2 n aprsales number 10 2 n maysales num......

Tom nnWe have been storing XML data in CLOB datatype. As we are in 9i now we would like to take advantage of XMLTYPE datatype. So we are planning to convert the datatype to XMLTYPE.nnCan you show us how to do the conversion in DB.nWhat changes ......

How to tune the below query nnSELECT NVL SUM DECODE TXN_CODE 0 TXN_AMT TXN_AMT -1 0 nFROMn DEALER WHERE CONT_NUMBER B2 AND DOC_DATE B1 AND TXN_PACN n 0270 AND DOC_TYPE TJ nnncall count cpu elapsed disk ......

hi nnRAC uses the the global resource directory and some special background process to sync access to resource shared by the multiple instances.nnEach instance masters some of the resources using memory allocated in the SGA.nnMy question is the......

We are developing in VB.NET I know you don t use this technology . We have the need to pass record sets into PL SQL stored procedures. Since the ODP.NET does not support passing ref_cursor IN value and arrays still involve looping one record at a......

Hi TomnnMy question is really simple and came from the doc SQL Reference Manual nn" The GROUP BY clause groups rows but does not guarantee the order of the result set. To order the groupings use the ORDER BY clause." nnOk but I can not find a......

Hi tom nGood Morning.nWhile reading PL SQL book there is a reference to the link below which discusses about how PL SQL deals with open cursors.nnnhttp www.gennick.com open_cursors.htmlnnAt the end of the article it is mentioned as follows......

Well. I do follow your recommendation on update tables with millions of tows to create a temp table and rename them after droping the original table. nnProblem I have now is that I have to update all most all the tables.nnnI tried a sql to creat......

Hi Tom - nnWith all the cool new stuff available in RMAN for 9i and 10g do you see any reason to continue doing online tablespace backups e.g. alter tablespace begin end backup; instead of using RMAN nnI m having trouble finding a reason ......

Hi Tom. I asked this question on another expert" weblog but was a laughed at and then b given a bogus answer.nnDo you know why it is not possible to create both a Bitmap Index and a Btree Index on the same column in a table nnORCL create t......