Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonDaily Insert, Delete on table
I have a table tb_card_dataCARD_NO TYPE EMAIL MODULE CREATED_ON SEQ_NO------- ---- ----- ------ ---------- ---------12345 C x@a.com MOD_1 06/03/2017 20170306000001 (create_on + sequence number)..so on around 500k records for MODULE - MOD_1around 500k...
Chris SaxonSession wise rank ,change in value should lead to new rank
Hi Tom,I need help to get sequence no or rank whenever there is change in continuous sequence below is the example-Input seq,id,value 1,1,2002,1,2003,1,3004,1,2005,1,2006,1,5007,1,5008,1,700expected out put same combination of id,value as per sequen...
Connor McDonaldImpact on importing oracle predefined java libraries
Hi Tom,I am trying to import below predefined java libraries to identify the language of the given text. Is there any impact on the data base by importing these libraries like such as slowness or any application connecting to database. loadjava -u DB_USER orai...
Connor McDonaldDB upgrade guidelines/ practices in enterprise applications
Dear Team,As in any enterprise application, we have many in-house developed Microsoft.NET applications that connect to a central DB, Oracle 10G in this case. We have many web-services based on REST/ SOAP, Microservices, Oracle Reports, small tools and utilitie...
Connor McDonaldRAC cluster_interconnect config
Hi Tom,Is it ok to use Fiber and Ethernet for cluster_interconnect type mixed?Ex.ib0 192.168.3.0 global cluster_interconnect,asm ==> InfiniBand Fiber Interfaceeno4 192.168.5.0 global cluster_interconnect,asm ==> Fast Ethernet InterfaceAny potential risk on ...

Resources