We have to create a Datamart containing the Customer characteristics like 'Heavy Buyer; Chocolate lover' etc., and this has to be done by evaluating...

guser78

03-24-2010 04:59 PM
Geoff Muldoon

In the 'Dependent Data mart' case, there is an ETL layer to extract the data from the central Data Warehouse to adapt and Load onto the 'Data...

guser78

03-21-2010 05:20 PM
Geoff Muldoon

Can streams replication be used for multi-source replication ? I have 5 source databases. I would like to replicate 1 schema from each of these...

Ora_DBA

03-20-2010 10:45 AM
Michel Cadot

Can the source database in streams replication be a physical or logical standby database ? If so, is the process of configuring streams the same as a...

Ora_DBA

03-19-2010 08:57 AM
ddf

Join us on Wednesday, March 25th, 2010 10:30 am – 12:00 pm GMT (4:00pm to 5:30pm IST) Oracle Application Express is a rapid web application...

iware

03-18-2010 02:02 AM
iware

I would like to know whether the content of the 'Data mart' tables be modified by the Marketing applications. I understand that the 'Data mart' is...

guser78

03-17-2010 05:16 AM
guser78

I have a questions for Oracle Gurus: We have a database that has about 70 tables. We need to replicate 32 out of these 70 tables into another...

Ora_DBA

03-13-2010 04:40 AM
Frank van Bortel

Hi ng, does anybody know a place, where I can find information about Oracle Spatial functionality? I like to learn something about these features...

Andreas Mosmann

03-12-2010 01:46 PM
Shakespeare

Hello. This is my first post to this group so if the question is too simple, be gentle with me. I have created a table called test like this "create...

Martin Frodderrer

03-10-2010 04:02 PM
ddf

1 am using 10g. I need code that returns the column name of the table and the value of a row of code. For example, assume I have a table called...

Rich

03-09-2010 09:35 AM
Kay Kanekowski

We are upgrading our vendor supplied application which requires a new server and an oracle upgrade. Production data is all contained in a single...

bontemps

03-05-2010 07:00 PM
joel garry

I have some old SQL scripts that use PCTFREE and PCTUSED. As now we have 10g, should I modify the scripts using ASSM instead of PCTFREE and...

moongeegee

03-04-2010 10:49 AM
Mladen Gogala

I saw some Oracle developers built sql scripts and they add "use tlm;" at the first line to the scripts. Does anyone know what it meant ? Thanks

moongeegee

03-04-2010 09:40 AM
Mark D Powell

Hi all We have a management programme, which uses Oracle DB. We (I) also make some intranet stuff etc for this system, which uses the same DB. Now...

jodleren

03-03-2010 09:42 AM
jodleren

Hi, For case of statistics there is made a copy from a database some time ago. I produced a SQL- Statement, that worked fine on the actual database,...

Andreas Mosmann

02-25-2010 09:45 AM
Mark D Powell

I am using 10g. I have an audit trail stored procedure to create. There is a customer table. Then customer_audit table. Customer and Customer_audit...

Rich

02-25-2010 09:42 AM
Mark D Powell

sil <schitroc (AT) gmail (DOT) com> writes: Glad you found the bug. Thanks also for reminding me why I'm so very pleased I no longer have to write...

sil

02-22-2010 02:19 PM
Gerard H. Pille

Hello, As promised in January, we are back with the latest refreshing issue of Oracle Connect...

iware

02-22-2010 03:08 AM
iware

Hello, I'm using the Report Builder included in Oracle Developer Suite 10g (10.1.2.0.2) for Microsoft Windows and the database is Oracle Database...

Cris

02-18-2010 10:08 AM
Cris

I have a very simple update statement. My version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production Update A set...

Sashi

02-11-2010 03:56 PM
Maxim Demenko

Do you know that you can find solar cells for less than 1 USD per Watt on www.ebay.com ? Regards.

..

02-10-2010 04:00 PM
..

Hello! First time poster in this forum -- please forgive me if this is the wrong place for my question. I've exhausted a web search on this issue,...

John Peterson

02-09-2010 08:39 PM
joel garry

I have Oradb11g_home1 it is a freeware stand alone for personal used. I download the software from Oracle web site. It is not easy to use cmd for...

moongeegee

02-09-2010 12:20 PM
joel garry

Hello, how is it possible to create a simple tablespace ucing Oracle SQL Developer based on Oracle 11g? I don't want to execute an sql statement...

Norbert Pürringer

02-08-2010 12:42 PM
Mark D Powell

Can anyone please point out the web site that I can download Oracle 11g for home Window 7 used. It is not for public business, for personal used only

moongeegee

02-05-2010 04:29 PM
Mark D Powell

Hello, spViewer Software is proud to announce new premier software product "dbTrends for Oracle AWR and STATSPACK". This new software is the...

spviewer

02-04-2010 11:33 AM
joel garry

Hi, Can you call a procedure from SQLPLUS that takes a collection as input? INSERT_PORTFOLIO_ARR ( p_customer_id NUMBER, p_price ...

The Magnet

02-03-2010 04:25 PM
Malcolm Dew-Jones

London Escort Agency present young, sexy, beautiful, tall, busty, English, Asian or any elite escorts in most of the cities in United Kingdom-...

Alica Jams

02-03-2010 06:35 AM
Alica Jams

Access Free Siebel 8.0 Core Consultant Exam Sample Questions Exam Code:...

iware

02-01-2010 08:17 AM
iware

Hello, is it possible to install/use this ODP .NET 10 on WINDOWS7? Are there any workarrounds? I read something in the net to edit the...

Achim Klausmann

01-31-2010 11:59 AM
Achim Klausmann

Hi, We have an immediate requirement for different Location in india Interested candidtes can send in their profiles to mamta (AT) jobworldindia...

mam

01-29-2010 04:14 AM
mam

Hi all, this is my first foray into optimization and I'm at a relatively beginner level. The situation that I have is an exceedingly simple one. I...

Sashi

01-28-2010 12:19 PM
Robert Klemme

Hi all, (How I wish there was a comp.lang.sql for generic sql questions!). I have a table structured thus: Emp_org, emp_dept, emp_sub_dept,...

Sashi

01-27-2010 11:13 AM
Sashi

I vaguely remember this has been asked and answered before, but can not find the answer anymore: Suppose I have a table in which a column has a value...

Shakespeare

01-26-2010 04:32 PM
Shakespeare

Is it possible to concatenate records in a field via Group By clause of an SQL statement? Untested script is : create table t1(country varchar2(32),...

dn.perl@gmail.com

01-26-2010 02:43 PM
Shakespeare

table 1 ref code 1 code_1 1 code_2 2 code_3 2 code_5 ........ ........ table 2

JIACHENG SUN

01-26-2010 11:24 AM
JIACHENG SUN

How do people copy tables from one database to another? The docs say that imp/exp are deprecated. I tried the copy command in sqlplus but it destroys...

Andrew

01-21-2010 05:10 PM
Andrew

Hi All, Im new to Oracle. I have a Rowtype and i want to Loop through that Rowtype without mentioning the Column name. My code as below...

FB

01-20-2010 03:57 PM
Gerard H. Pille

hi, thinking about going the OCP exam but not sure if it's best to go for 10g or 11g? we use 10g at work but not sure how widespread 11g is yet -...

harryajh

01-18-2010 09:32 AM
Mark D Powell

See why to go for a Warehouse Automation http://www.iwarelogic.com/blog/warehouse-automation-301 Also what oracle offers for the same.

iware

01-12-2010 12:33 PM
joel garry

I have a strange issue which I will probably report as a bug but thought i would pass by you guys 1st. I have an update statement EXEC SQL UPDATE...

Steve Rainbird

01-10-2010 10:29 AM
Shakespeare

... wrote: -- Regards, Frank van Bortel

Frank van Bortel

01-08-2010 09:07 AM
Frank van Bortel

I am searching for the best ebooks for : 1-database systems 2-oracle 11 sql/pl 3-oracle 11 developer Please recommend them for me . Also I need to...

happy

01-06-2010 06:12 AM
Frank van Bortel

Dear Readers, Thanks for your overwhelming response to this sample question paper series. In continuation of same we are back with Siebel 8.0...

iware

01-04-2010 01:27 AM
iware

Greetings, I am currently using Oracle9i Enterprise Edition Release 9.2.0.4.0. I have a table with following data Table 1 (Sample...

Pankaj

01-03-2010 02:43 PM
Pankaj

I'm trying to create an Oracle 10g Lite database using the .NET DataAccess components packaged with the Mobile SDK. I have been able to successfully...

caban

12-29-2009 03:07 PM
caban

I am doing maintenance on a 9i forms application that we are migrating to 10g. It mostly works without change, except for a FRM-92100 exception that...

David Shochat

12-28-2009 01:49 PM
David Shochat

Oracle Connect Newsletter – December 2009 Issue This month's issue focuses on the different aspects of Oracle e- Business...

iware

12-28-2009 08:13 AM
iware

Hi, in a large table OUR_TABLE we have a calculated index for a persons-name with a simple soundex function OUR_SOUNDEX in the same schema...

Norbert Winkler

12-22-2009 02:09 PM
Lisa

Hi, I need help with a query which involves the 2 tables defined below. What I need to do is choose the record with the max “Eff Date” from “Table...

Sandy80

12-15-2009 02:53 PM
Maxim Demenko