Re: Strange Bug

Are you executing two sql's from two different sessinons . Because it may happen that you might not have commited the records you inserted in tableA , as soon as you create a temp table oracle does commit by itself and you start finding records .
Can you try issuing a commit and then doing select on tableA without creating temp table.

-Bp

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, June 13, 2002 5:28 PM

> List,
>
> I have a table when I run a query on this table return nothing(no record
> returns!!!), but when I create a temp table from this table return the
> records
> E.G:
>
> select cola,colb,colc from tableA where cola=1 and colb='A'
> 0 records return
>
> Now: create table a_temp as select * from tableA
> then
>
> select cola,colb,colc from tableA where cola=1 and colb='A'
>
> cola colb colc
> 1 A xx
> 1 A yyyy
> 1 A mmm
>
> Any Idea? what's wrong and what's cause a problem?
> I appreciate any recommendation.
>
>
>
>
> Hamid Alavi
> Office 818 737-0526
> Cell 818 402-1987
>
>
>
>
>
>
> ======================= Confidentiality Statement =======================
> The information contained in this message and any attachments is
> intended only for the use of the individual or entity to which it is
> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law. If you have received
> this message in error, you are prohibited from copying, distributing, or
> using the information. Please contact the sender immediately by return
> e-mail and delete the original message from your system.
> ===================== End Confidentiality Statement =====================
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: BigP
  INET: big_planet_2000_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).