Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonOracle has any feature similar to "Always Encrypted" that is offered by SQL server?
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...
Chris SaxonDaily Insert, Delete on table
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...
Chris SaxonDynamically passing sequence name to get currval
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...
Chris SaxonOptions to quickly access large portions of rows
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 ...
Chris SaxonRanking based on time break
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...

Resources