I use the database to declare (and enforce) as much application logic as I can.
What I'd like to do is to enforce application constraints across related rows, if
possible.
As a contrived example, suppose we have a table of Agreements and a secon...
<code>Hi,
We have a requirement where are supposed to load 58 millions of rows into a FACT Table in our DATA WAREHOUSE. We initially planned to use Oracle Warehouse Builder but due to performance reasons, decided to write custom code. We wrote a c...
<code>Hi Tom,
As always, thanks for your help. I have a regarding which JDBC client side driver to use: Thin or OCI.
Our web application uses Servlets and JSPs (we do not use applets), which are housed in a Tomcat engine. We presently use the t...
<code>insert /*+ append */ into t
select rownum,mod(rownum,5)
from all_objects
where rownum <=1000
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- -----...
<code>Your help is always the best. Please repeat it this time
I want to create a table with 12 partition (for each month) then within each month's data should be categories based on a column(CityId). The CityId will have 5 possible values (107,1...
I have the following data (ID, TYPE, DAY, BASE_DAY) and would like to create the column BASE_TYPE in a single, efficient query statement.
create table t (id int, type char, day date, base_day int, base_type char);
with this data in it;
insert...
Sir,
Putting this as new question now.
Suppose I have Server-1 and Server-2. And I have Oracle-10g installed on both, say Oracle-1 and
Oracle-2 respectively. I want to export data from Oracle-1 to Oracle-2.
Using the tradition Import-Exp...
<code>Hi Tom,
After normal shutdown Oracle9i DB, if i lose all UNDO files and dont have backup, could i just create a new UNDO tablespace & files and drop the old to recover the DB? Since the DB was shut down normally, it rolled back all uncommited ...
