AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 36 min 3 sec ago

Database link queries

Tue, 09/11/2018 - 00:00
create or replace procedure P_POP_ILC (P_POL_NO VARCHAR2 DEFAULT NULL) is cursor c1 is select * from rsds_locn_exposure@dmn_rsk_150 where RLE_ULM_NO = NVL(P_POL_NO , RLE_ULM_NO); begin DELETE FROM IDS_LOCN_CLM@dmn_rsk_150; comm...

How to use partial indexes for PK/UK keys

Fri, 09/07/2018 - 00:00
LiveSQL link: not working post link into LiveSQL link, but link works https://livesql.oracle.com/apex/livesql/s/g78ij8jxinq4409pp8dbz3owo Hello all, we have a BI solution (Oracle 12c + ODI11). We have a lot of partitioned tables (daily and mont...

Regexp_Replace Help- Column Level Data Masking

Tue, 09/04/2018 - 00:00
Hi Tom, I have this requirement but regexp_replace is behaving odd here. It gives me all NULL Requirement for function- Suppose a number 9845-089160 ? function logic should convert one digit at a time and not entire number in one go. ? First ...

sql performance

Tue, 09/04/2018 - 00:00
Hi Tom,I have met a SQL that with the latest statistics and the execution plan is in the wrong estimate-rows ,that's to say,it's a large difference between the estimate and the actual,the sql statement and execution is below: <code>select t1.card_no...

Storage XMLs in Oracle 12cR2 database

Fri, 08/31/2018 - 00:00
Hello! I created a database in order to store XMLs. I'm going to storage a large amount of data. I was told that Oracle 12cR2 allows to storage XMLs and handle them very good. I created a table with a xmltype column. <code>CREATE TABLE test...

Want to use single select statement instead of various union all's for fetching previous quarter data

Fri, 08/31/2018 - 00:00
I have 5 select statements using union all(showing a few in here) want to use a single statement to fetch the revenue from a table . So based on the condition that AND period_id>=1009 AND Opp_Created_Date_Period_Id<=1009(for every previous quart...

TABLE function and where clause parameters retrieving

Fri, 08/31/2018 - 00:00
Hi there, My goal is to return fieldX or fieldY depending on the where clause (which I don't have any control on since it's generated by a third party software). The TABLE() function is very close to what I want to achieve : select * from T...

Issue with Trigger creation

Wed, 08/29/2018 - 00:00
I am having issues with Trigger. Trigger creation is successful but Once user try to test it, It is failing. Before trigger creation, tester is able to add new email to email_t table. But Once I place trigger, they are getting this : <code> ...

Pages