Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Test - Delete me
--------------030004050507010909090506 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit
delete from oracle-l where subscriber = 'Gene Sais'; commit;
select count(*) from oracle-l
where subscriber = 'Gene Sais';
COUNT(*)
0
-- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals Gene Sais wrote: > > --------------030004050507010909090506 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bitReceived on Wed Mar 19 2003 - 13:23:03 CST
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"> <title></title>
</head>
<body>
<tt>delete from oracle-l where subscriber = 'Gene Sais';<br>
commit;<br>
<br>
select count(*) from oracle-l<br> where subscriber = 'Gene Sais';<br>
<br>
COUNT(*)<br> ----------<br> 0</tt><br>
<br>
<pre class="moz-signature" cols="$mailwrapcol">--
Daniel W. Fink
<a class="moz-txt-link-freetext" href="http://www.optimaldba.com">http://www.optimaldba.com</a>
IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals</pre>
<br>
Gene Sais wrote:<br>
<blockquote type="cite"
cite="midF001.0056D8E2.20030319085421_at_fatcity.com"> <meta http-equiv="Content-Type" content="text/html; "> <meta content="MSHTML 6.00.2600.0" name="GENERATOR"> <br> <br>
</blockquote>
<br>
<pre class="moz-signature" cols="$mailwrapcol">
</pre>