Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dual having more than 1 row

dual having more than 1 row

From: <babu.nagarajan_at_mail.iflexsolutions.com>
Date: Thu, 7 Sep 2000 17:03:15 +0530
Message-Id: <10612.116392@fatcity.com> 





This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.



------_=_NextPart_000_01C018BE.E67952DC


Content-Type: multipart/alternative;


        boundary="----_=_NextPart_001_01C018BE.E67952DC"




------_=_NextPart_001_01C018BE.E67952DC


Content-Type: text/plain;


        charset="iso-8859-1"



Hi
 


In one of the databases here, count(*) from dual gave me 3. I deleted tow
rows based on the rowid's and now things are working fine...
 


I was wondering how it could happen in the first place... No, no one logging
in as sys inserted this. then how???
 


Babu Nagarajan


i-Flex, Bangalore


#91-80-5597600-3381

 




------_=_NextPart_001_01C018BE.E67952DC


Content-Type: text/html;


        charset="iso-8859-1"



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD>

<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">





<STYLE>

<!--



body, P.msoNormal, LI.msoNormal 


{

background-position: top left;
background-repeat: repeat-y;
background-color: #FFFFFF;




margin-left: 8em; 


font-family: arial;


font-size: 12pt;


color: #000000;


}


P.msoNormal, LI.msoNormal 


{

margin-left: 8em;
margin-top: 0em;
margin-bottom: 0em; 




font-family: arial;


font-size: 12pt;


color: black;


}


-->


</STYLE>




<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>

<BODY background=cid:752513111_at_07092000-284c>

<DIV><FONT face="Book Antiqua" size=2><SPAN 

class=752513111-07092000>Hi</SPAN></FONT></DIV>


<DIV><FONT face="Book Antiqua" size=2><SPAN 

class=752513111-07092000></SPAN></FONT>&nbsp;</DIV>


<DIV><FONT face="Book Antiqua" size=2><SPAN class=752513111-07092000>In one of 

the databases here, count(*) from dual gave me 3. I deleted tow rows based on 
the rowid's and now things are working fine...</SPAN></FONT></DIV>


<DIV><FONT face="Book Antiqua" size=2><SPAN 

class=752513111-07092000></SPAN></FONT>&nbsp;</DIV>


<DIV><FONT face="Book Antiqua" size=2><SPAN class=752513111-07092000>I was 

wondering how it could happen in the first place... No, no one logging in as sys 
inserted this. then how???</SPAN></FONT></DIV>


<DIV><FONT face="Book Antiqua" size=2><SPAN 


class=752513111-07092000></SPAN></FONT>&nbsp;</DIV>




<DIV><FONT color=#0000ff face="Courier New" size=2>Babu Nagarajan</FONT></DIV>

<DIV><FONT color=#0000ff face="Courier New" size=2>i-Flex, 

Bangalore</FONT></DIV>


<DIV><FONT color=#0000ff face="Courier New" 

size=2>#91-80-5597600-3381</FONT></DIV>


<DIV>

<P>&nbsp;</P></DIV></BODY></HTML>




------_=_NextPart_001_01C018BE.E67952DC--



------_=_NextPart_000_01C018BE.E67952DC


Content-Type: image/gif;


        name="Chess.gif"


Content-Transfer-Encoding: base64


Content-Disposition: attachment;


        filename="Chess.gif"


Content-ID: <752513111_at_07092000-284c>



R0lGODlhQAZlAPcAAP////7+/v39/fz8/Pv7+/r6+vn5+fj4+Pf39/b29vX19fT09PPz8/Ly8vHx
8fDw8O/v7+7u7u3t7ezs7Ovr6+rq6unp6ejo6Ofn5+bm5uXl5ePj4+Li4uHh4eDg4N/f397e3t3d
3dzc3Nvb29ra2tnZ2djY2NfX19bW1tXV1dTU1NPT09LS0tHR0dDQ0M/Pz87Ozs3NzczMzMvLy8rK
ysnJycjIyMfHx8bGxsXFxcTExMPDw8LCwsHBwcDAwL+/v76+vr29vby8vLu7u7q6urm5ubi4uLe3
t7a2trW1tbS0tLOzs7KysrGxsbCwsK+vr66urq2traysrKurq6qqqqmpqaioqKenp6ampqWlpaSk
pKOjo6KioqGhoaCgoJ+fn56enp2dnZycnJubm5qampmZmZiYmJeXl5aWlpWVlZSUlJOTk5KSkpGR
kZCQkI+Pj46Ojo2NjYyMjIuLi4qKiomJiYiIiIeHh4aGhoWFhYSEhIODg4KCgoGBgYCAgH9/f35+

fgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAQAZlAEAI/wBvXPlC


sKDBgwgTKlxY8M2XK0duvDjxoaLFixgzntj44sWNHz+OPLky8Mybk3dS3nlz5ckPihAQIABAs6bN
mzhz6tzJs6fPn0CDCh1KtKjRo0iTKl3KtKnTp1CjSp1KtarVq1izat3KtavXr2DDih1LtqzZs2hz
nvD4YyRBk29S/pl75wzDu3ffnIH4YyLFjIADC764cW3HGxgSx5yZtrHjx5AjS55MubLly5gza97M
ubPnz6BDmxVc2PDHkCNLmlQ5909dvAb18vU7uLZtwaJz697Nu7fv38CDCx9OvLjx48jT3rZd+jBI
kQO/wGVN1+TeI303Lt9+O7n37+DDi/8fT768+fPo06tHzr194OYeP8L+csR9+/X48+vfz7+///8A
BijggETZZyBpJ8yn4Bc/2EfggxBGKOGEFFZo4YUY9nfghhhttOCHsN1gUYYklmjiiSimqOKKLJqI
1xN/cYggiDTCNhEGEMTU4o489ujjj0AGKeSQT9Wo0BExbuehkUwm5NILH2AgE5FUVmnllVhmqeWW
wzVpJJIVLenlmE9GOSWXaKap5ppstunmmziNSaZbq90xl0NywlamlIzB6eefgAYq6KCElpdnk3p9
8URENzT60RHQvYWSna3hyeSeZxaq6aacdurpp6BidSiTsmFH22CFHXbaE25JN2lrf1j/ehCmfYZq
66245qrrrmy+EFJJKtk1KkOlZpfkgRSlGl9I0EUH0g0n4Jgpr9RWa+212GYLoEUcsYUaSdLVSalr
wpJ6nbEyuqftuuy26+678Oqm5AfKettsuHHJVZ1CxZ6a7nbxBizwwAQXbDBU/wIG32n3SpcQmAkv
d/DEFFds8cXrRmygmDQ2+C/GIIcs8sgkr6mxfRwPa5DHuJXs8sswxyxzhQbBeDJzCaoM4rQz9+zz
z0AHLVyNNqebss56RgQTz0I37fTTUEftFdIFQfxezlQrSKvUXHft9ddg/5S1gh9FNzZDW4et9tps
ty3z2bAl+lBBZ0w3bqw6p+323nz3/+33u3Dj1a92YXbbKLOt2g2rrC/2ZWatf0cu+eSUF3pD4MSe
6y93yh4uEp12q3RHS47zWfnpqKeuOpYeHVES5rFpTjiyhq8K+kknLep4jpCv7vvvwAdPIVsj1dna
a1kPfuy/nT8KqV+K9S789NRXb315HHnuumr5jou8nMrffPUJMpV//fnop68+cB12/lxq+FJHbo3h
i9/y+vjnr//+lN1WL8OJE9fxyrWQ+tkPMPxLoAIXyECtbIxehrEXq94iwH01RHbLO2BFGsjBDnrw
g0HRWPPeF526TcpSppqdBi8Cwha68IUMXGGysgfACS6kPivcIAx3yMMeUi+HCOoIiP9wqDEfGvGI
SJQcEGvzAjmxzEBJjKIUp9i1Jc4IaU+sDRW3yMUuxsyKV4PdF0SUES+a8YxoPFjRwMgtrInxIGmM
oxzniC2FrFGDR3vjF6TFNDr68Y+A9NOC7sg8N+qRID+AVpR0FMhGOvKRWfKS1VBmyEOSDkrSgqQm
N8nJFulskqiqpB4v+QHedfKUqEzlhDBHRMKIUo9lWowqZ0nLWubnkFVrIi5rtjtG2vKXwAzmcXZZ
ENS4inGBi2UfhcnMZjqTM8RMCFzyVamxxdKXz8ymNrcJmWh+IVGsgtTnSjipcSHzUrtbJjfXyc52
iiqaxZIIR9aivcSVs5o0uqb03Mn/z376MyneHBy9NJKqepKze/hEWzr3+c+GOvShcYInBpVUO9TY
E6F34iWUTAnRjnoUor56wi4NyDkImsZ54DqmSlhiqsd99KUwdWfrrgAXAsKNpBuqaFsCeIZFKVJK
MQ2qUJ9JPFdR6nvJm2jERggpVl2hUZiU5VCnStVZrsWY36SmBXWG06XW7iMViZ46q0rWstIxe1g1
ofz+YNMxdfVmzeGd+cxK17r60aQSBJda9TU/tyrVijNhqF0HS9gpttFwJOTeWtu6oLdqsLCQjSwX
Fea+bymWr0idj2MPKNnOetaItflfYuPHV7Zq9q9L/KxqVwtCzkUQgCWsYF/5hVog/7L2trhN4MZe
m9i6yda0B9ms/XJL3OKij0NMjRRpvScs4YrPuNCNLvASJlrLqlR0d5DObFRoW+l697uTg2tBYUtB
3NUMWhl8LHjXy9624bFbyxonQ0Cp3vba975SW+LCnIeXLD4XvwAOMNDYiNfDLKiVRRSwghfsMgIP
FIK6BJF/OcTgClv4Yg4+rJcmrK4Le/jDAstwGw/F4e6A+MQo1paIC6ezEgcmxTCO8a5WDMGxuXhE
Ms6xjjtF4zxi8X47DrKQ/dTjV46NjDgespKXnKYiE1NETI6ylK9EEELq18iwE+yUt8zlEyHEygf0
sRgXo+Uum/nMELpLer3qzUVKFf/NcI4zgeYDZqNhGXPy5KOc98xn/oCozrv1pktEpOc+G/rQhjIS
oCnqTb4srcyIjrSkeyMn+m4nwrskHUVMN+lOe/o3w1o0Qb2pqNKN9dOoTvVlqGbp9pFab6qOtawr
A7dWixl2pMzkrHfNa8eIcZK3ht2esNnrYhv7K7hE0loaDetjO/vZVvHmEQRtakhD+9rYJoo3P1I8
Sw7b2tkOt7h1Iu0JriZWjKXat8fN7naLLZokKcmr6HK2XJ/a3fgOtzfrZhATYtQ16q52vgee74Da
pSWsuqhWAX6oXBOb4BDHtsEVhR2QIO6g8jtnPkv38Ih7/NgG54tEOhJf5YYuoSBosje4P85yT4fc
VH5pjkEl9W+NKxST9265zjv98r5MpH00vDjNMw4bh69850jnc883B3R6PsqpQ+erzUsd1aMn/epo
Received on Thu Sep 07 2000 - 06:33:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US