[Experimental] If you are a JIRA system administrator, have you ever come across the requirement of partially exporting JIRA into XML – probably for importing individual projects into another JIRA instance? If yes, this might work for you. However, my work is incomplete and experimental. This worked with a small JIRA instance (100 issues), and failed with a huge JIRA ...

Wunderlist killed its app for Ubuntu long time back. And then it was bought by Microsoft, so I hardly think there will be a Linux app ever again. For a long time I didn’t use Wunderlist, but I thought of giving it a try once again. I figured out that pinning Wunderlist tab on Firefox works to some extent. Today ...

Post-upgrade first World problems are here. A friend who recently upgraded to Ubuntu 16.04 Xenial Xerus LTS told me that Cisco AnyConnect VPN doesn’t work anymore. So I wanted to give it a try. In Ubuntu 14.04 what you’d normally do is installing the three packages network-manager-openconnect, network-manager-openconnect-gnome and openconnect (or may be two of them – can’t recall). However, ...

Truecrypt died two years back. Despite their warning I continued to use it for encrypting some of my data, because I believe Truecrypt was rather killed by a hidden hand – not actually because of any unfixable vulnerabilities. So, straight to the topic; a new Ubuntu LTS is here and everyone is upgrading. I wanted to install it from the ...

So, that happened and I had to spend a considerable amount of time choosing new passwords. I really didn’t write about how I manage my passwords. I thought about writing this tip because it’s a game of battle between convenience and confidentiality. People choose weak passwords because they are easy to remember. But easy to guess at the same time. ...

I screwed it up again. I logged into one of my e-mail accounts from a shared computer owned by someone else. This is something I never do (unless there’s a top urgency) because I fear keyloggers. So now, time has come to change the passwords. Next factor of two factor authentication will keep me protected, but still need to fix ...

These days I’m working on a JIRA project which may require working with XML backups and project import tool. The JIRA instance I’m currently working on has over one million issues in thousands of projects (including defunct) – that collectively make the XML backup gigantic. Have you ever come across the situation where you want to delete some of the ...

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 ...

රටේ දැන් දැන් සිද්ධ වෙන බරපතල සිද්ධිත් එක්කම මට එකපාරටම පරණ යමක් මතක් වුණා. 2005 අවුරුද්දෙ උසස්පෙළ නිමා කරල රජයේ විශ්වවිද්‍යාලයකට යන්න සුදුසුකම නූලෙන් මිස් වෙලා රාජගිරියෙ රසායන විද්‍යා ආයතනයෙ උපාධිය හදාරන්න යන කාලෙ ඇහිච්ච, හිත කලකිරවන වචන කීපයක්. එක දවසක් අකාබනික රසායනය පිළිබඳ දේශන පවත්වපු මහාචාර්ය වරයෙක් දේශනයෙ කොටසක් ඉවර වෙලා පොඩි අතුරු කතාබහක් පටන් ගත්තා. පොඩි බ්‍රේක් එකක්. ...

රටේ දැන් දැන් සිද්ධ වෙන බරපතල සිද්ධිත් එක්කම මට එකපාරටම පරණ යමක් මතක් වුණා. 2005 අවුරුද්දෙ උසස්පෙළ නිමා කරල රජයේ විශ්වවිද්‍යාලයකට යන්න සුදුසුකම නූලෙන් මිස් වෙලා රාජගිරියෙ රසායන විද්‍යා ආයතනයෙ උපාධිය හදාරන්න යන කාලෙ ඇහිච්ච, හිත කලකිරවන වචන කීපයක්. එක දවසක් අකාබනික රසායනය පිළිබඳ දේශන පවත්වපු මහාචාර්ය වරයෙක් දේශනයෙ කොටසක් ඉවර වෙලා පොඩි අතුරු කතාබහක් පටන් ගත්තා. පොඩි බ්‍රේක් එකක්. ...

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; ...

ලංකාවේ එක්තරා විශ්වවිද්‍යාලයක උපාධි අපේක්ෂක (undergraduate) මිත්‍රයෙක් දවසක් Java සම්බන්ධ assignment එකක් කරගන්න බැරුව මගෙන් උදව් ඉල්ලුවා. පරිගණක විද්‍යාව හදාරපු ඕනම කෙනෙක් දන්නවා sorting algorithms ගැන. මේකත් අන්න එහෙම sorting algorithm එකක්. ඒකෙ එක තැනකදි මම enhanced for loop පාවිච්චි කරලා array එකක් iterate කරන හැටිත් කියල දුන්නා. ඒ කිව්වෙ මෙන්න මෙන්න මේ වගේ එකක්, // x is an array ...

ලංකාවේ එක්තරා විශ්වවිද්‍යාලයක උපාධි අපේක්ෂක (undergraduate) මිත්‍රයෙක් දවසක් Java සම්බන්ධ assignment එකක් කරගන්න බැරුව මගෙන් උදව් ඉල්ලුවා. පරිගණක විද්‍යාව හදාරපු ඕනම කෙනෙක් දන්නවා sorting algorithms ගැන. මේකත් අන්න එහෙම sorting algorithm එකක්. ඒකෙ එක තැනකදි මම enhanced for loop පාවිච්චි කරලා array එකක් iterate කරන හැටිත් කියල දුන්නා. ඒ කිව්වෙ මෙන්න මෙන්න මේ වගේ එකක්, // x is an array ...

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,   ...

Previous Page