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

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: ආගිය කතා, [...]

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

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

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

It’s cool to see that Ubuntu 10.10 Maverick Meerkat is scheduled to release on 2010.10.10. In every 6 months a new Ubuntu is born. Usually it’s April and October. This time it’s three tens in a row. Yes, it’s 10.10 and I can’t even wait for the experience! Tomorrow I’ll be downloading the RC from SchoolNet. Till ...

eIndia 2010 is the India’s largest ICT event, which is to be held on 4-6 August 2010. As part of this programme, there’s an award ceremony which covers six categories; e-gov, digital learning, e-health, e-agriculture, telecenter and municipal IT. Under the telecentre category, there are three submissions from Nenasala‘s of Sri Lanka, for the Innovative Grassroots Telecentre Initiative of the ...

I have noticed that Google blogger blogs are not accessible with SLTnet if they are configured to use custom domain. For example, http://blog.shaakunthala.com is not accessible with SLTnet at the moment. This is not due to a misconfiguration of DNS, but a technical failure of SLTnet. By default, http://ghs.google.com:80 should provide a ‘Not Found’ page. But with SLTnet connections, you’ll ...

අප්‍රේල් 30 වෙනිදා ගල්කිස්සේ බීච් පාටියේදී, පිළිස්සූ කුකුළු මස් ආහාරයට ගත් ශාකුන්තල තෙමේ, එයින් ඇති වූ බලවත් අජීර්ණ තත්වය හේතුවෙන් පසු දින එලොව යන්නට ඔන්න මෙන්න තිබී යන්තම් සුවය ලැබූ වගයි෴ අයේමත් බාබකිව් කන්නෙ නෑ නෑ නෑ… නෑමයි….!!!!!!!!!! Filed under: lifestyle, Uncategorized Tagged: ආගිය කතා ...

බ්ලොග් මැරතන් නම් ඉවරයි. ඒත්… බොහොම සාටර් වැඩක් කොරලා තියෙනවා එක කණ්ඩායමක්…… ලාංකීය සිතුවිලි (http://blog.inetlanka.com). මේ අයට මගෙ සිංහල බ්ලොග් එකෙනුත් ලින්ක් එකක් දීල තිබුණ පහුගිය කාලේ…. එයාලා චෝදනා කරන විධියට සිංහල බ්ලොග්කරුවන්ගෙ සංසදයට ඒ අයත් එක්ක අවුලක් තිබුණනම් මට මගේ බ්ලොග් එකෙන් ලින්ක් දෙන්න හේතුවක් නැහැනේ…. කරගෙන යන වැඩේඩ සහය දීමක් විධියට මගෙ බ්ලොග් [...] ...

Previous Page