nWe have a requirement to pull data from tables at a remote location to a another site. We also need to n- massage" the attributes - keep some add othersn- sync it with the current data - add rows if they do not exist update if different etc.n......

Tomnn1.If you haven the information of different releases of Oracle and the respctive year and month of their release can you please share with us.nnFurther if there is a document which shows major enhancements in each release that will really b......

HinI am trying to use SQLPlus to connect to database directly using just the connect string ie without referencing to tnsnames.ora nnI have this in my tnsnames.oranPOD n DESCRIPTION n ADDRESS_LIST n ADDRESS PROTOCOL TCP H......

I am looking to the Best Practice for the configuration of an Apps Server Connection Pool keep alive. I ve seen where we use select 1 from dual; to keep the connection alive. Couldn t we use something like show user" to do that nnYour thoughts......

CREATE OR REPLACE TRIGGER dd before delete on table1nfor each rowndeclarenbeginn insert into table2 select old. from table1; nend; n nnnThat is i want insert the date into table2 what ever deleted in table1.nnplz find the solution for me...

In your book Effective" you showed different ways on how to avoidnouter join but the first example wasn t clear to me. Can you give mena few examples using scalar subqueries.nnnnThanks nnnJeann...

Hi Tom nnWe have a big de-normalized table that stores the summary statistics calculated from a detail table. Detail table contains under 20 columns and usually have 1000 rows for each summary row. The summary row stores about 900 different attrib......

Hi Tom nnI have recently faced a question from respectable person from Oracle. nnHe asked me which kind of statements generate undo I said insert update delete merge .. etc. nnHe asked me where select statement generates undo I said no. He ......

First I would like to thank you for all of the good information on your site I ve used it a lot for research. Now for my simple question my application vendor insists on running their system with rule based set at the instance level as the optimiz......

Hi Tom nnThis is my statspack report.nnSTATSPACK report fornnDB Name DB Id Instance Inst Num Release OPS Hostn------------ ----------- ------------ -------- ----------- --- ------------nCTIORA 135762511 ctiora ......

I have two tables nncreate table t1 a_id number b_id number col varchar2 1 ; ncreate table t2 a_id number b_id number col2 varchar2 1 ; nncreate unique index t2_uidx on t2 a_id b_id ; nninsert into t1 values 1 null a ; ninsert into......

Tom n In your presentation at OGUC you highlighted Transparent Data Security as one of the cool features available in 10g R2. Could you please shed some light on the following questions nn Who makes the encryption transparent in oracle I......

Hi Tom nnWe are using DBMS_JOB to achieve multiprocessing. We submit 9 jobs simultaneously. This code ran absolutely fine in production for 15 days and then suddenly one day 2 jobs got suspended and didn t execute at all for 6hrs. We restarted the ......

I would like to know the Installation Requirement details on XP machine. I a trying to install Oracle 9i on Windows XP. It is not moving forward after certain stage on CD2 while copying oci library file . This istallation is on Intel Celeron process......

I have the following table nName Null Typen----------------------------------------- -------- -----------nINDICE NOT NULL NUMBERnFECHA ......