Skip to Main Content

Questions

QuestionAsked

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...
--3.4 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...
--41 hours 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...
--40 hours ago

Hello Team,CAN ANYONE PLEASE SUGGEST HOW TO CREATE EMAIL NOTIFICATION OF LONG RUNNING BACKUP JOB REPORT FROM EOM....
--2 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...
--39 hours 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 ...
--35 hours 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...
--2 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...
--3 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...
--3.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...
--9 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 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 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.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...
--3.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 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 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 ...
--9 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 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 ...
--9 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 ago