Skip to Main Content

Can't see the Ask Question button?

Connor and Chris will be back taking questions again soon. Click Notify Me to be emailed when we're back taking new questions.

In the meantime, you can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Questions

QuestionUpdatedAsked

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...
11 hours ago3.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 ago3 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...
18 hours ago3 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 ago4 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 ago3 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 ago19.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...
21 hours ago16.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 ago7.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 ago8 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 ago4 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 ago3 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 ago3 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 ago3 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 ago4 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 ago14.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 ago4.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 ago20.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 ago2 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 ago7 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 ago3.9 years ago