Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
> 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).Received on Fri Jun 14 2002 - 12:41:23 CDT