Today, I encountered a problem when the edits I made to ‘/etc/hosts’ file on a Linux box didn’t work as expected. In the /etc/hosts file I added the following line, 192.168.50.2 shaakunthala.com And to test, issued the following command, $ ping shaakunthala.com And the result was, PING shaakunthala.com (184.168.221.17) 56(84) bytes of data. That’s not the IP address I wanted ...
Today, I encountered a problem when the edits I made to ‘/etc/hosts’ file on a Linux box didn’t work as expected. In the /etc/hosts file I added the following line, 192.168.50.2 shaakunthala.com And to test, issued the following command, $ ping shaakunthala.com And the result was, PING shaakunthala.com (184.168.221.17) 56(84) bytes of data. That’s not the IP address I wanted ...
If you are into software development, you may have wanted to drop all tables of an Oracle database schema in a single shot. How do you do it? Here’s how I do it with a simple PL/SQL procedure. begin for i in (select * from tabs) loop execute immediate ('drop table ' || i.table_name || ' cascade constraints'); end loop; ...
If you are into software development, you may have wanted to drop all tables of an Oracle database schema in a single shot. How do you do it? Here’s how I do it with a simple PL/SQL procedure. begin for i in (select * from tabs) loop execute immediate ('drop table ' || i.table_name || ' cascade constraints'); end loop; ...
As per the documentation provided in the following page, once you query ALL_TAB_COLUMNS, database views and view columns are also included. There’s nowhere specified whether the table is actually a table or a view. http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm However, with the following SQL it’s easy to exclude views and retrieve table columns only. select table_name, column_name, data_type, data_length, ...
As per the documentation provided in the following page, once you query ALL_TAB_COLUMNS, database views and view columns are also included. There’s nowhere specified whether the table is actually a table or a view. http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm However, with the following SQL it’s easy to exclude views and retrieve table columns only. select table_name, column_name, data_type, data_length, ...
Yipee! Got a new job; got a new job! :) I’ll be in touch with different set of articles,… how could it be like being a JIRA administrator. During last few months I had nothing special to blog. I don’t do politics, rarely gossip, and I’m a tech-blogger.Filed under: blogging, lifestyle, tech Tagged: ආගිය කතා, blogging, jira, tech
Yipee! Got a new job; got a new job! I’ll be in touch with different set of articles,… how could it be like being a JIRA administrator. During last few months I had nothing special to blog. I don’t do politics, rarely gossip, and I’m a tech-blogger. Filed under: blogging, lifestyle, tech Tagged: ආගිය කතා, [...]
A rare mongoose hit my bike’s front wheel few minutes ago while I was riding, just near the entrance of the general cemetery. The shock felt like a severe hit, but luckily that guy survived. I turned back to see any injuries, but the engine’s scream made him run away, even though injured. This shocked me, because, nowadays we don’t ...
A rare mongoose hit my bike’s front wheel few minutes ago while I was riding, just near the entrance of the general cemetery. The shock felt like a severe hit, but luckily that guy survived. I turned back to see any injuries, but the engine’s scream made him run away, even though injured. This shocked me, because, nowadays we don’t ...
My 3-year old laptop’s DVD drive no longer works correctly, so I had to find an alternative method to install the fresh out of the oven Maverick Meerkat. So it’s USB. First I tried unetbootin but it seemed not installing the bootloader properly. Since I’m not familiar with GRUB2 it would’ve been extra workaround for me. Fortunately there was a ...
My 3-year old laptop’s DVD drive no longer works correctly, so I had to find an alternative method to install the fresh out of the oven Maverick Meerkat. So it’s USB. First I tried unetbootin but it seemed not installing the bootloader properly. Since I’m not familiar with GRUB2 it would’ve been extra workaround for me. Fortunately there was a ...
September was of course not a good time for me. After finishing my internship I was expecting to write some damn good blog articles, but fate was against me this time. Early in the last month our home router seemed to be malfunctioning. We handed it over to claim the warranties, and till then no ...
September was of course not a good time for me. After finishing my internship I was expecting to write some damn good blog articles, but fate was against me this time. :( Early in the last month our home router seemed to be malfunctioning. We handed it over to claim the warranties, and till then no Internet… I almost felt ...
As you may have already experienced, Javascript on Chrome works faster than on Firefox. But today I’ve experienced the other way when using them on a virtual machine. It was a virtual machine (VirtualBox) running Windows XP and on that Firefox seemed to be working faster and smootly than Chrome. Especially when browsing sites that have rich Javascript content Chrome ...
As you may have already experienced, Javascript on Chrome works faster than on Firefox. But today I’ve experienced the other way when using them on a virtual machine. It was a virtual machine (VirtualBox) running Windows XP and on that Firefox seemed to be working faster and smootly than Chrome. Especially when browsing sites that have rich Javascript content Chrome ...