Cool SQL ( send sms with sql )

When I was 17 ( year 2001 ), my cracking days, one of the famous tool we used was “Soft ICE”. People made plugin’s and can play MP3 using Soft ICE.. neat huh. Well check this out, I can send SMS using sql… hehe. Is this kewl or what…

Example:
Select Send_SMS(‘[Dest Number]’,’Hello World!’) from dual;

Do u want to know how!, well here is what I did. I wrote a oracle package using the UTL TCP Package, to connect to SMS gateway and send the message, simple as is. The best part of this is, you have a table like this :

Table ‘Contacts’

+-------------------------+
| Name    | Number        |
+-------------------------+
| Ahmed   | 77XXXXX       |
| Aishath | 99XXXXX       |
| Hussain | 603XXXXXXXXXX |
+-------------------------+

And u do a select statement like this

Select Name, Send_SMS(Number,’Hi’ || NAME || ‘, I know what u did last night!’ ) as SMS from Contacts;

Result :

+-------------------------+
| Name    | SMS           |
+-------------------------+
| Ahmed   | SENT          |
| Aishath | SENT          |
| Hussain | SENT          |
+-------------------------+

The simple select statement will send an sms to each contact in my contact table. The sms will be like this for Aishath : 'HiAishath, I know what u did last night!'. Oh Boy! would she be surprized or what!!!... heheh!!!...

Now comes the fun part… just sit back and wait till they send back bogus replies... HEHEHEHEHEHE.