Skip to Main Content
Ask The Oracle Mentors
Ask a Question
Recently Answered Report
Zip a .csv file present at DB directory using PL/SQL
We have a requirement where we are generating .csv file from DB and placed it to a DB directory. We want to zip these .csv files so that size can be optimised. Could you please suggest a way to achieve it by using PL/SQL....
Shuffle quantities between buckets
Hi Tom,I am given the "current" allocation of items to eight buckets, and I want to make it more efficient by filling as much as possible of bucket A, then of bucket B, then of bucket C (as indicated by the "priority"), by moving items between buckets by takin...
Synchronize PK values
Hi!We would appreciate your advice about problem we have.We have two tables of the same structure in different DB (DB1 and DB2) . Rows are inserted into table in DB1, and then some of them (based on simple condition) are being prorogated to the table in DB2 ...
email in PL/SQL
Tom:1. If you want to write something in PL/SQL application server that send email automatically to an administrator requesting approval after a user create a record, which oracle package would be using.Would you also use an after insert trigger for it or jus...
Is there an Oracle document that has a checklist to be able to answer whether database server will handle "peak" load
Greetings, A question from the client that comes up every few years is to predict if the Oracle database server will be able to handle a new application's peak load. Instead of trying to think of all that needs to be considered on the fly, it would be great i...
Upcoming Office Hours
All Office Hours
Free training, how-tos and Q&A with Oracle experts, every month!
Maximillian R Grossman
Cloud Coaching Office Hours...
Next: May 10 17:00 UTC
OML usage highlight: Oracle...
Next: May 11 15:00 UTC
Next: May 11 19:00 UTC
AskTOM Database Security
Next: May 12 14:00 UTC