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

Hi All,I would like to get the gaps between date range and needed it to separate the gaps by MM ID.could you please someone help me to resolve belowINPUT:ID | MM Number | From | To12345|4444444 |2015-01-03 |2015-02-0212346|4444444 |2015-02-03 |201...
17 hours ago3.5 years ago

hi tom,This is with reference to question asked earlier about MV. i don't know how to write the revert against the questions asked.https://asktom.oracle.com/pls/apex/asktom.search?tag=materialized-view-complete-refresh-getting-slowerActually in below pr_fact_x...
37 hours ago2 days ago

Hi Team,I have a same table in 2 environments Development and SIT. Both have the same index pptcode_1_3.Environment - DEVTable name - pptcode number of rows - 103819execution time - 9 secswhen i run execution plan on development it does TABLE ACCESS STORAGE FU...
44 hours ago2 days ago

Hello Team,CAN ANYONE PLEASE SUGGEST HOW TO CREATE EMAIL NOTIFICATION OF LONG RUNNING BACKUP JOB REPORT FROM EOM....
44 hours ago3 days ago

cordial greetings this is to check if there is a way to automatically obtain an age in a field when the user registered the date of birth...
47 hours ago2 days ago

Hi Tom,We are using utl_http in our PLSQL code to communicate with external system.We are using POST method to send message to external system and with certain transfer timeout we are waiting for response and reading the response.Now we are planning to remove ...
47 hours ago2 days ago

Hello Tom,we have a table with appointments. There is a appointment every 5 minutes like this an there may be holes because some appointments are already taken<code>create table AM_HILFSTABELLE( amht_num1 NUMBER, amht_dat1 DATE);insert into am_hilfstabelle...
47 hours ago2 months ago

We have quite a few very large tables that are interval partitioned ( 1 partition per day ). At any given point we store 120 days worth of data, i.e. we do daily partition maintenance and move the > 120 days data over to either Archival systems or purge them.M...
48 hours ago4 days ago

Hi, Ever since I have upgraded my database from 11.2.0.2 to 11.2.0.4 I started seeing these errors in my alert log: Sat Dec 10 06:00:12 2016 DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file. Errors in file D:\APP\ORACLE\diag\rdbms\v3prod\v...
48 hours ago3.5 years ago

Environment: Oracle 12.1.0.2 on Exadata I have a table with 30 columns, one of which is a CLOB, that contains about 26 million rows. I have a purge job (PL/SQL packaged procedure) that DELETEs rows from nine (9) other tables based on a list of IDs from the dri...
48 hours ago10 days ago

Hi,I am trying to find the downside of setting local_temp_tablespace to TEMP tablespace which is a shared temp.The reason is because of a bug, if local_temp_tablespace is NULL and dba_users.spare9 is NULL, then Oracle assigns SYSTEM tablespace as local_temp_ta...
2 days ago3 days ago

<b></b>Scenario: Oracle Recipe Tool / MicroservicesJNDI : jdbc/SOAXAOPSPLSQL : schema.pkg1.procedureThis is the entry point to an on-premise DB package.It can be called from cloud and non-cloud services.Now whenever I would compile schema.pkg1The callback wil...
2 days ago2 days ago

Hello,Is there a way to get all the keys that exist in a JSON column? JSON_VALUE function provides an easy way to access a value for a given key, but is there a way to obtain all the key names?Thanks,Gabi...
2 days ago2.5 years ago

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...
2 days ago3.4 years ago

Hello,It would be great if you can help me here.Can you please share if Oracle has any feature similar to the "Always Encrypted" feature offered by SQL server? Link pasted at end has information on "Always Encrypted".I understand that Oracle offers data redact...
3 days ago3 days ago

I am trying to get the currval of all the user sequences in the schema. When I run the below sql it gives me invalid sql statement.I am not sure if the below is the right way to achieve it. Please advise.Assumption: The current value of the sequences are alrea...
3 days ago4 days ago

Hello, Tom.We have a fact table, that is partitioned by day and stores the last 90 days of data. Sometimes users of the application can change the status of record from 'ACTIVE' to 'CANCELED'.There are a lot of heavy analytical queries against that table that ...
3 days ago9 days ago

i want to make rankning of trucks exit based on break more than 1 hourlike eg belowTRUCK EXITT1 10:00 PMT2 10:05 PMT3 12:00 PMT4 12:05 PMT5 12:10 PMT6 12:20 PMResult should be like...... leaving break more than 1 hours gaps10:00...
3 days ago3 days ago

Hi,I am currently working on developing apex web application which requires to capture CLOB data and save it to DB.I am using Rich text editor to capture the content and noticed that only max of 32k characters can be loaded through the page item.when I try to ...
3 days ago9 days ago

Hi dear AskTOM team. Have a great day to everyone. I have some confusion about UPDATE TABLE statement in Oracle DB 12cr2. Let's assume we have 3 users: U1; U2; U3;U1 has a table called TEST_1, and U2 and U3 both have UPDATE privilege on that table.My ...
3 days ago4 days ago