Oracle Help

Select max within max
Hi all, 10.2.x on Linux ... Is there a "neater"/more efficient way of selecting the maximum value for a column based on the maximum value of another column. Gods that reads poorly, I'll try an example ... SomeTable ColX ColY ColZ .... MoreCols A 1 8 .... A 1 9 .... A ... 13 Jul 2008 06:55

setting currval in a sequence without recreating the sequence
Can you set the currval in a sequence without having to drop and recreate the sequence? I rather not have to drop and recreate something because I have to do a lot more paperwork. Can't we just use alter or update? please provide example. ... 10 Jul 2008 20:38

Split Query
Hi, My requirements have been changed. I want to know if a query can be created that does the following, or am I stuck creating a function in PL/SQL. A string will be available in this format: A:3,B:2,C:5 Basically, I need to query using the left side of the colon as a value, returning the number of rec... 10 Jul 2008 11:20

Last sync of a context index
Hi, how can I find out when the last synchronization of the context index was done? I'm using the ctxsys.ctx_ddl.sync_index package. In dba_objects I can see the creation date of the context index, but not the last usage of the ctxsys.ctx_ddl package. Thanks & Regards Michael ... 8 Jul 2008 08:59

Last sync of a context index
Hi, I'm using context indexes in my database. For synchronization the ctxsys.ctx_ddl.sync_index package is used. How can I find out when the last synchronization was done? In the dba_objects table I've just found the creation time of the index, not the last synchronization. Thanks Michael ... 8 Jul 2008 05:55

Difference between ‘*’ and ‘.*’
Hi, Does anybody know if there is any difference between ‘*’ and ‘.*’ regular expressions in Oracle? Both seem to work similarly. Best regards, lp ... 10 Jul 2008 11:20

prioritize inserts i.s.o replication
Hi all, I set up two dbs with streams replication (A and B) A gets all inserts that are replicated to B. When replication stops and is started again inserts into A lead to unacceptable commit times (20 seconds i.s.o the normal 200ms) while replication catches up at full speed. Is there a way to prioritize the ... 8 Jul 2008 04:53

Error updating materialized view
Hi all, I'm trying to update a materialized view: EXECUTE DBMS_MVIEW.REFRESH('NED_PRODUCT_CARD_MV', 'C'); This commands hangs for a very long time (no idea if it'll ever complete). Hm, reminds me of the halting problem. When I terminate it with a Ctrl-C, I get the error message: ERROR at line 1: ORA-12008: e... 7 Jul 2008 13:31

Free Webinars on PMP Certification Awareness and Roadmap
Dear Freinds I came across a website which conducts Free Webinars on PMP Certification (Project Management Institute, USA) Awareness and The Roadmap. It proved to be quite useful. This Training Institute also provides live online lectures on PMP Certification Preparation at very competitive rates and also have f... 7 Jul 2008 10:25

FREE SOFTWARE DOWNLOAD ONLINE
FREE DOWNLOAD SOFTWARE http://freesoftware20.blogspot.com/ ... 7 Jul 2008 07:21