Sunday, May 06, 2007

Neat...

Ran in to Laurent Schneider's blog at http://laurentschneider.com/ and found tons of nifty neat tricks. One of this using dbms_xml package neatly to achive things like getting the number of rows in all the tables in a schema. And this which neatly throws out a table in a csv file without needing much due.. Just a sql, xmlsequence (a table function) and reg exp. Quite neat. There were few more good post of what I scanned thru, like this one talking about a modelling technique of abstracting all the common attributes across the entities under one table/view and this which has a neat way to extract the sql with the values for bind variables. Its always great to pick up good handy tricks from the folks around and apply them in the day-to-day work. And there are many which are becoming accessible thru things like blogs, forums and all this web 2.0 phenomenon.

5 comments:

Adrian said...

Hi! Thank you for that post. I found your blog while I was doing research on live help and live support software.
I see you are enjoying your google blogger :) Well, I think it's great that Google are making such good products like Blogger here, but also Picasa and other Google Apps. They have a great impact on what happens in the internet. I also wanted to tell you that it would be awesome if you would find a little time to visit my web site, it would be greatly appreciated. Maybe you are looking for live chat solution for your web site? If yes, please try LIVECHAT Contact Center. Using this application will help you maximizing online conversion, increase sales and customer satisfaction. My company's offer contains also LIVECHAT Communicator - multiprotocol instant messenger for business use. You can contact all of your friends (who use different applications like MSN, ICQ, etc) with it, but also organize instant messenging network in company. 14-day trial versions of both applications are free and you can download them directly from the web site.

Adrian said...

Hi! Thank you for that post. I found your blog while I was doing research on live help and live support software.
I see you are enjoying your google blogger :) Well, I think it's great that Google are making such good products like Blogger here, but also Picasa and other Google Apps. They have a great impact on what happens in the internet. I also wanted to tell you that it would be awesome if you would find a little time to visit my web site, it would be greatly appreciated. Maybe you are looking for live chat solution for your web site? If yes, please try LIVECHAT Contact Center. Using this application will help you maximizing online conversion, increase sales and customer satisfaction. My company's offer contains also LIVECHAT Communicator - multiprotocol instant messenger for business use. You can contact all of your friends (who use different applications like MSN, ICQ, etc) with it, but also organize instant messenging network in company. 14-day trial versions of both applications are free and you can download them directly from the web site.

Mahalya sree said...

Usually I do not read post on blogs, but I would like to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Thanks, very nice article.
Office Interior Designers in Coimbatore
Office Interior Designers in Bangalore
Office Interior Designers in Hyderabad

Melina Mia said...

Someone essentially lend a hand to make severely posts I would state. That is the very first time I frequented your website page and thus far? I surprised with the analysis you made to create this particular submit incredible. Fantastic job!
Delivery service singapore
Singapore delivery service
24 hour delivery singapore

meenumaga said...

These ways are very simple and very much useful, as a beginner level these helped me a lot thanks fore sharing these kinds of useful and knowledgeable information.
Self Employment Tax
Tax Preparation Services
Tax Accountant
Tax Consultant
Tax Advisor
Online Tax Services
Tax Professional
Online Tax Preparation
Income Tax Preparation
Instant tax service