tag:blogger.com,1999:blog-13668718.post1933400547793380330..comments2023-10-30T12:24:51.923+00:00Comments on Halis way: Oracle SQL to return a alphabetical subsetHampushttp://www.blogger.com/profile/12826832242493809239noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-13668718.post-8731278991192482612011-05-16T19:42:34.971+01:002011-05-16T19:42:34.971+01:00this is want comenet helo thank blogs admins post ...this is want comenet helo thank blogs admins post come turkey antalya<br /><a href="http://www.turkeyphotostours.com/" rel="nofollow">Marmaris Hotel </a> turkey Holidayscomen travelmarmaris toursphotos fine city see pool gooAnonymoushttps://www.blogger.com/profile/12592850868590554910noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-20288530769966786652011-05-16T19:41:40.346+01:002011-05-16T19:41:40.346+01:00ooo dostum güzelbir paylaşımda bulunmuştun konuhar...ooo dostum güzelbir paylaşımda bulunmuştun konuharika istanbulda ismek kursları elsanatı bilgisayar yemek spor güzellik ibb<br /> <a href="http://www.ismekkurslari.org/" rel="nofollow"> Kurdele Nakısı</a> kurdele işi nakıs kursu ücretsiz eğitimMrkhttps://www.blogger.com/profile/00839292106204987750noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-23070447608492529732010-11-03T23:16:48.580+00:002010-11-03T23:16:48.580+00:00I've been testing out the Ubuntu network insta...I've been testing out the Ubuntu network install environment today. All you need to use the PXE installer is to configure a DHCP server and TFTP server on your network,<a href="http://www.dominicalcostaricatours.com" rel="nofollow">dominical costa rica tours</a> if you want a more hands off install you can use a "preseed" file. Quite easy to use and it is much more flexible then the ananconda kickstart files.<br />Ubuntu actually support the kickstart file format as well, so if you don't want to learn the new preconfigure "preseed" format you can just write a normal kickstart syntax file and netboot Ubuntu exactly the same way you would a Redhat/Centos/Fedora box.<a href="http://www.dominicalcostaricatours.com" rel="nofollow"><br />http://www.dominicalcostaricatours.com</a>pedro velasquezhttps://www.blogger.com/profile/04906868750940934366noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-54447775865446061002007-11-01T14:38:00.000+00:002007-11-01T14:38:00.000+00:00I think your result is not correct, I got a differ...I think your result is not correct, I got a different result:<BR/><BR/><BR/>Connected to:<BR/>Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<BR/>With the Partitioning, OLAP and Data Mining options<BR/><BR/>SQL> with t as (<BR/> 2 select 'Atest' a from dual union all<BR/> 3 select 'Btest' from dual union all<BR/> 4 select 'Etest' from dual union all<BR/> 5 select 'Htest' from dual union all<BR/> 6 select 'Wtest' from dual union all<BR/> 7 select 'Dtest' from dual union all<BR/> 8 select 'dtest' from dual),<BR/> 9 data as (<BR/> 10 select ascii (upper (substr (a, 1, 1) ) ) a_val, a<BR/> 11 from t)<BR/> 12 select ascii ('A'), ascii ('D'), data.*<BR/> 13 from data<BR/> 14 where a_val not between ascii ('A') and ascii ('D')<BR/> 15 order by a;<BR/><BR/>ASCII('A') ASCII('D') A_VAL A<BR/>---------- ---------- ---------- -----<BR/> 65 68 69 Etest<BR/> 65 68 72 Htest<BR/> 65 68 87 Wtest<BR/><BR/><BR/>I think the values of Dtest and dtest should not be displayed because their ascii value (68) is between 65 and 68.Anonymousnoreply@blogger.com