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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).