I came across a very nice post about Autonomous Transactions in Oracle written by Kevin Meade on orafaq. Thought about sharing the link. His blog also has some very nice stuff. Comments Comment by Aman…. on 2008-03-09 12:28:30 +0530 Nice one Sidhu.learned some thing new about AT. 🙂 Cheers, Aman….
I came across a post about syntax highlighting for code in Wordpress on Thomas Roach’s blog who in turn saw it on Tyler Muth’s blog. There is a plugin called syntax highlighter which does all the beauty. Use is very simple: Download it from here. Upload to your blog’s plugins folder and extract it over there. Now (on Wordpress) go to Plugins page and activate the plugin. To use it wrap your code like ...
Today one of my colleague was working on a simple PL/SQL procedure. Based on some logic it was returning count(*) from all_tab_columns for few tables. It gave count incorrectly for one table out of around fifty in total. He just hard coded the table name and ran it but again it showed count as zero. Then he took the code out of procedure and wrote it in DECLARE, BEGIN, END and after running it showed the correct count. But ran as database procedure it always shows incorrectly. ...
From Eddie’s blog I got a link to 3 posts on Regular Expressions on OTN written by CD. Wonderful stuff. Check out. Part 1 Part 2 Part 3 & Thanks CD…wonderful work buddy ! Comments Comment by Tyler on 2008-02-28 07:51:45 +0530 I’ve been working with regular expressions in PL/SQL a lot lately and the one tool that’s helped me more than any other is Regex Buddy (http://www.regexbuddy.com/). Yeah, it’s not free, but it was the best $40 I’ve spent. There are free options, like regex coach and a few free online options, but the problem is you have to find one that matches the Oracle specific Posix ERE format. Regex buddy even has a drop-down for Oracle syntax (http://www.regexbuddy.com/oracle.html). I have no affiliation with this tool whatsoever, just found it to be exceptionally useful. ...
Well, it was in my mind for some time, to register my domain name and finally its here :) . I have imported all the posts from my blog on blogger. I will be checking and editing all the posts for any kind of issues with wordpress. If you see anything out of the way do let me know :) Comments Comment by Amritpal Singh on 2008-02-06 20:57:22 +0530 good work Sidhu saab, this proves JOSH haje hai baaki, so no tension, and Guru di kirpa naal chakki jao kam ...
Howard has posted a pdf on Oracle Administration on his new website. Do check out. Its awesome. Update: Howard has shutdown his website, so unfortunately this pdf is not available. Sidhu Comments Comment by Amritpal Singh on 2008-01-22 11:03:00 +0530 paaji no pdf, all the content is password protected. Comment by Sidhu on 2008-01-22 21:54:00 +0530 Due to some reasons Howard has password protected all the content 🙁 Read more at http://tinyurl.com/yvypmj ...
At my workplace we were facing a problem with refresh of a mview. Say it was created in schema of user1 but when I tried to refresh it from user2 it would give ORA-03113: end-of-file on communication channel. Then we raised a SR and have been following up with Oracle support for long but it was not getting anywhere. Yesterday that guy seemed to have reached some point. The mviews that we have created and are having problem with refresh are created on top of both local & remote objects and he said that up to 11gr2 there is no possibility of creating mviews on both local and remote objects. I did validate this thing. All the mviews failing to refresh are created on top of both local & remote objects. But again from the owner the refresh is fine but from another user it gives problem. By the way that guy hinted at bug 4084125 and also suggested a work around. I haven’t tried that yet. Will try and update about the results. ...
Last week I attended a training on AIX system administration from IBM (organized by company, obviously ;) It was a 7 days course covering all of the system administration stuff. There was a lot of new stuff to learn, LVM being the most number of times uttered word, once we did the chapter on LVM. It was a nice experience as a whole as for the first time I attended any training on Unix. ...
Eddie Awad started a new series Oracle in 3 minutes on his blog. In the first post he has discussed about multi-versioning. Its a must watch for everyone who is working on Oracle. Hoping to get more of such stuff from Eddie. Sidhu Comments Comment by Amritpal Singh on 2008-01-22 11:05:00 +0530 nice man, keep posting all the good work. Comment by Sidhu on 2008-01-22 21:55:00 +0530 Thanks man 🙂 Sidhu
Howard Rogers has done a post on his blog that is the site Dizwell worth it ? Do post your opinion. If he plans to close it down, we will miss a great resource for Oracle. Sidhu Comments Comment by Aman Sharma on 2007-10-23 09:20:00 +0530 Fingers crossed that he wont do that and thats the voice of all(almost) too!Hope he takes the right decision. Cheers, Aman….