Ask The Oracle Mentors

Recently Answered

	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...