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... | 12 hours ago | 3.4 years ago |
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... | 12 hours ago | 3 days ago |
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... | 19 hours ago | 3 days ago |
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... | 19 hours ago | 4 weeks ago |
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 ... | 21 hours ago | 3 days ago |
hi tom,i have seen lot of answers from you regarding sql trace and tkprof for sql performance tuning.but i am still not clear with few things.i hope you will explain me clearly those things1.how does this sql trace and tkprof differ from set autotrace on.2.if ... | 21 hours ago | 19.1 years ago |
Hi Tom, I have a table in which one column is CLOB datatype. Data in this column are 100 lines. ( single record has 100 lines) Each line has been separated by chr(13) ( enter key's ascii value). My requirement is I... | 22 hours ago | 16.1 years ago |
When I query a database that includes a particular field (Condition), it returns multiple rows of Conditions associated with the same result from another column (NCT_ID). See sample output below. NCT_ID CONDITION NCT00531284 Multiple MyelomaNCT0... | 2 days ago | 7.8 years ago |
<u></u>Hello Masters,I hope you are OK, it was impossible to ask TOM during many days...Two weeks ago I was testing, with RMAN, the "RECOVER TABLE" command. It helped me to restore a dropped table, with RMAN backups : a very powerful and useful feature, thanks... | 2 days ago | 8 days ago |
Hi,I saw the following depreciated features in Oracle APEX 20.1 release notes:<b>6.1.4 Support for Internet Explorer 11 DeprecatedSupport for Internet Explorer (IE) 11 is deprecated.Starting with release 20.2, only the current and prior major release of Micros... | 2 days ago | 4 weeks ago |
sample example:/* This procedure is taking approx 20-25 mins to complete because of selecting large volume of data,Is there any way to reduce execution time ? */<code> procedure sample ( a_in IN varchar2) IS v_row number; v1_row number; v2_row n... | 3 days ago | 3 days ago |
Oracle Audit sentence: audit execute on [package] by access; How Can I Do something like this?audit execute on [package.function] by access;I need to audit execution of functions inside packages with Oracle Audit options.Is it possible to audit arguments sent ... | 3 days ago | 3 days ago |
Dear Ask-Tom-Team, I've to apologize up front because I think I've something missed in the Documentation regarding dbms_redact setup, or restrictions therewith.If so I'm sorry for wasting your time just to point me in right direction.I've a simple test-case on... | 3 days ago | 3 days ago |
Hi,In APEX SOD, it says there will be additional Oracle JET-based components. May I know if there will include the following paging control in Oracle JET?https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=pagingControl&demo=basicPagin... | 3 days ago | 4 weeks ago |
Hi Tom , I have your book and am still not able to understand the mechanism of hash join . it just says similar to this ( I do not have book at work so can not exactly reproduce it )one table would be hashed into memory and then the other table would be used t... | 3 days ago | 14.1 years ago |
Hi Tom,I am getting "ORA-06531: Reference to uninitialized collection" even after initializing collection to assign a value. Could you please help. Please find the code below.create or replace TYPE TYP_GRP_ID is object (grp_id number); create or replace TY... | 4 days ago | 4.4 years ago |
I have read several books which have repeatedly mentioned creating indexes on foreign keys. I know one advantage is that it eliminates table-level locks and, I have seen the benefit since I have encountered a similar problem. However, I would like to know if y... | 4 days ago | 20.1 years ago |
Hi, I have an issue performing a parallel merge of clob data.I am developing a new process for for part of the solution I am preparing data set for use case testing with randomized data of various data type. I use a function to create a CLOB of randomized size... | 5 days ago | 2 weeks ago |
Hello Tom,I have a question about inline functions.The following statement runs without problems (sorry for the German names of the functions and variables). The function is quite simple and subtracts 12 months from a reference date sttag until it is smaller t... | 5 days ago | 7 days ago |
Hello,I am attempting to delete a record / object (that may use several tables at the DB level) from an application.The delete statement is raising aORA-02292: integrity constraint <constraint name> violatedHow can I find the Delete statement (DML) being execu... | 5 days ago | 3.9 years ago |