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.

2 comments:

Shayari pro said...

best tic tok shayari. job for a wider motley of tips in this

d said...

Real Bike Racing Mod Apk
As you have now understood the usage of ‘Record and Playback’ tool, the following are the different posts using which you can explore the functioning of ‘Selenium IDE’