If what you are describing is completely accurate,
( no DML, change S_A_S fixes the problem ) then
it would appear you have encountered a bug.
A search on MetaLink is in order, and failing that,
you need to open a TAR.
Jared
On Thu, 2004-01-29 at 04:59, Wendry wrote:
> I have the same problem li
I have the same problem like you Rajesh, the query also gives different
rowcount each time executed eventhough there's no one updating base
tables, in my opinion it's because of the sorting operation (your group
by clause). In my case after I remove some group functions, the result
goes well. Also
gt; Sent: Tuesday, January 27, 2004 2:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: UNION ALL Query: Riddle
>
>
> Q: What does "different results" mean?
>
> Different row count?
&g
PROTECTED]Sent: Tuesday, January 27, 2004
2:29 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: UNION ALL Query: RiddleQ: What does "different results" mean? Different row count? Completely different data? Partially different data? Some columns have incorrect value? What abou
Q: What does "different results" mean?
Different row count?
Completely different data?
Partially different data?
Some columns have incorrect value?
What about doing it without the parallel hints? The tables aren't
so big that it would take a long time to find out.
Jared
"Pillai, Ra
Yes, this is a trace file that
contains
ORA-07445: exception encountered: core
dump...
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Thursday, July 31, 2003 3:39
PM
Subject: RE: "union all" problems
What does the trace file says on the server ??? do you see a ora-7445
trace file?
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can h
Hi!
I haven't seen this issue before, but it seems like
a bug. Check for .trc files in your user_dump_dest.
The contents are probably quite cryptic, but you
can send it to Support through Metalink.
Tanel.
- Original Message -
From:
Ed Lewis
To: Multiple recipients of
Jonathan,
We use MINUS technique heavily in our DW environment to get the source
system changes since we last extracted.
We do 2-way minus (src to ods and ods to src).
Best Regards,
Prasad
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
There's nothing like a good high colonic to make you want to have kids!
> -Original Message-
>
> not very slick but I used MINUS yesterday to find parents with no
> children so as to purge them
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Le
not very slick but I used MINUS yesterday to find parents with no
children so as to purge them
we do this a lot in this 3rd party app. RI is sketchy at best and the
app blows up if childless parents exists
--- [EMAIL PROTECTED] wrote:
>
> Jonathan,
>
> I've used MINUS heavily in sql scrip
Jonathan,
I've used MINUS heavily in sql scripts and pl/sql
to determine the differences in schemas: both
structure and data.
Of interest to DBA's and developers, and least when I
did it it was for the developers.
Jared
On Thu, 24 Jul 2003, Jonathan Gennick wrote:
> I'm doing research for a
Jonathan,
I can't think of any specific examples but the four operators all have
their place:
UNION - A quick way to merge result sets. If, for example, you have actual
financial data in one table and budget financial data in another table and
need to spool all data to a file then UNION is an e
Jonathon,
I've got a query for you that uses all 3 set operators at once!
I wrote it to compare two different versions of our 3rd Party Student
Information System (SASI) in two different databases. We were getting
ready to upgrade Production, having already upgraded a Test instance. The
query
- Original Message -
> what do you mean by 'arc'?
> >
have a look:
http://www.docm.mmu.ac.uk/online/SAD/T07/erd2.htm
much better explanation than I can give here.
Cheers
Nuno Souto
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuno Sout
At a previous job, I used MINUS as part of a package to perform
automated testing of transaction processing. Compared actual result set
with expected result set via minus. IF rows returned then if failed and
returned rows were written to error table for review. Worked well for
what we needed it to
what do you mean by 'arc'?
>
> From: "Nuno Souto" <[EMAIL PROTECTED]>
> Date: 2003/07/24 Thu AM 09:39:29 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Union quries: INTERSECT, MINUS, etc
>
> - Origin
- Original Message -
> I'm doing research for an article on union queries. I'm
> interested in finding examples of problems that were solved
> using UNION, UNION ALL, INTERSECT, or MINUS, with the latter
> two being of special interest because I don't see them used
> very often. If you c
Use
ORDER BY 1 (ie, the first column)
At 10:31 AM 1/17/02 -0800, you wrote:
>Hi,
>
>I try to use union and order by first column of first select statment and
>also first column of second select statment but get error, Any Idea how to
>do this??
>
>SELECT A,B,C FROM TABLEABC
>UNION
>SELECT D,E,F
SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY 1
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 1:31 PM
> Hi,
>
> I try to use union and order by first co
Did a little testing.
I think that the columns names are decided by the first select only.
The union adds the rows from the second select to the result set
created by the first select.
That's mean that your columns are a , b , c.
So order by 'a' will work. It did in my test.
Yechiel Adar, Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 20:31
>
> SELECT A,B,C FROM TABLEABC
> UNION
> SELECT D,E,F FROM TABLEDEF
> ORDER BY A,D
SELECT A as ord_col,B,C FROM TABLEABC
UNION
SELECT D as ord_col,E,F FROM TABLE
Try:
select a,b,c from tableabc
union
select d,e,f from tabledef
order by 1;
Hamid Alavi wrote:
> Hi,
>
> I try to use union and order by first column of first select statment and
> also first column of second select statment but get error, Any Idea how to
> do this??
>
> SELECT A,B,C FROM TABLE
You have to use ORDER BY column position as in
SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY 1
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
Hamid Alavi wrote:
>
> Hi,
>
> I try to use union and order by first column of first select statment and
> also first column of second select statment but get error, Any Idea how to
> do this??
>
> SELECT A,B,C FROM TABLEABC
> UNION
> SELECT D,E,F FROM TABLEDEF
> ORDER BY A,D
>
> Hamid Alavi
>
Hamid,
Look in the Sql manual.
For UNION clauses, you must ORDER BY the item number:
SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY 1 <= lookee here
hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message---
select * from (
SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF) x
ORDER BY A,D
> -Original Message-
> From: Hamid Alavi [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, January 17, 2002 12:31 PM
> To: Multiple recipients of list ORACLE-L
>
In the order by section use the relative column numbers. Plus, you can not
individually order by a single column from each union. Its a comprehensive
sort of the entire column.
SELECT A,B,C FROM TABLEABC
UNION
SELECT D,E,F FROM TABLEDEF
ORDER BY 1
-Original Message-
Sent: Thursday, Jan
28 matches
Mail list logo
