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.

12 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

Domnic said...

Anybody want to know How to trace the mobile with location and get more details for tracking.Read this blog...

Mobile Number Tracker | Phone Number Tracker With Location | Mobile Location Tracker | How To Track A Phone Number | Phone Number Tracker | Phone Number Search

Guru Guru said...

This is so informative blog and i have used this 5 minutes thing very useful too happy with this blog........
SAP FICO Training in Chennai

rp ap said...

I gain lot of information from this article........thank you
Cloud computing certification in chennai

Appu Pappu said...


Thankyou for sharing this useful info and keep it up

isoft innovations facebook

isoft innovations faq

isoft innovations about us

isoft innovations address

isoft innovations contact us

isoft innovations software company

isoft innovations chennai

isoft innovations employees

isoft innovations careers

isoft innovations consulting services




Rohi Shri said...


I hope it will help a lot for all. Thank you so much for this amazing post
3D printing in Chennai
3D printing companies in

Chennai

3D printing service Chennai
3D printing service in Chennai

Shriya Iyash said...


It is imperative and useful......Keep it up


Hadoop Training Institute in Chennai

Deva nikitha said...

This information is impressive; I am inspired with your post writing style.Its a wonderful post and very helpful, thanks for all this information.
SAP HR Training in Chennai
SAP SD Training in Chennai
SAP Basis Training in Chennai