Wednesday, February 13, 2013

Oracle : Finding tables with given column name

One of my colleague today come to me asking where  can i find this column (LANDING_PAGE) in DB of our application. Actually he was not even sure of the column name. It was a field in UI. Our application has more than 200 tables and my tables are heavy (having many columns). So human search was futile. Thankfully there is a query in oracle which came to rescue.

select * from user_tab_columns where column_name like '%PAGE%';

Sunday, February 10, 2013

Movie Review: Special 26

This weekend we decided to watch movie "Special 26". The reviews were quite favorable and it had been some time since we had seen movie in theater.
We prefer going on an early morning show because the movie ticket rates are one third of the regular afternoon or evening show (Rs 90 only for Platinum seat at E-Square multiplex at University Road in morning).
The main actors of this movie are Akshay Kumar, Anupam Kher, Manoj Bajpai and Jimmy Shergil.
It is based on the life of con-men who duped several people and business person during the 1980s. They posed as fake CBI agents or Income Tax Officials.
The movie is decently paced and has good elements of comedy to make you laugh. I liked the scene where applicant answers - "Milke ukharenge Sir. Kuchh Hum. Kuchh Aap.".
Even though Akshay Kumar is the lead actor, i will say the movie revolves more around Anupam Kher and Manoj Bajpai. They have done superb acting.
There are some loose ends in the story (the story of Jimmy Shergil is not that convincing and the love interest of lead actor seems unnecessary.) However it is worth watching for a good relaxing time.