Ask The Oracle Mentors

Recently Answered

	Oracle 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...
	Daily 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...
	Dynamically 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...
	Options 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 ...
	Ranking 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...