Posts

Showing posts with the label Database

Oracle LPAD Function in Derby

Recently I had the opportunity of working with Derby 10.9 and I needed to convert some queries written in Oracle to Derby, and I hit this wall; Oracle has this lpad function which can add zeroes to the left of a string e.g. lpad('tech', 8, '0'); would return '0000tech' Basically what the above meant is you pass in a string called "tech", it will fill up from the left with 0s, and make sure the final string is of length 8. So how the heck do I make it work the same way in Derby? Took me one or two hours to figure it out... ij> select myname from mytabletest; MYNAME ---------- tech ij> select substr('00000000'||myname, length(myname)+1) from mytabletest; 1 ------------------ 0000tech As you can see, there are 8 zeroes, you adjust it according to the final length of the string, so if you want a longer length with more zeroes, just add more zeroes. By the way, the myname field is a varchar(10). So what happens if myname i...
Post a Comment
Read more

Popular posts from this blog

Long-Term Visit Pass - Plus (LTVP-PLUS)

http://www.ica.gov.sg/news_details.aspx?nid=12665 Good news for those of us who cannot get PR for our beloved spouse, because the Singapore government has come up with a enhanced long-term visit pass called LTVP-PLUS or LTVP+. I'll sum up the key points in the FAQ provided by ICA so you don't have to go through one big page. Do let me know if I missed out anything or correction is required by dropping a comment. GENERAL LTVP+ will be in effect from 01 Apr 2012. LTVP+ holders will enjoy extended duration of residency, public healthcare subsidies and easier access to employment. No separate application required for LTVP+; an application for LTVP will automatically include your spouse for LTVP+, if eligible. LTVP applications submitted from 01 Feb 2012 will automatically be considered for LTVP+. The first approved LTVP+ will grant 3 years residency and subsequent renewal will be 5 years. Current holders of LTVP will be considered for LTVP+ on next renewal. If holde...
Read more

How to Marry a Thai in Singapore

Image
You should refer to here -  https://www.rom.gov.sg/reg_info/rom_marriage.asp Please spend some time to go through and understand the information on that section (legal provision, other information, filing of notice, solemnization and etc), if your still not sure, feel free to drop a comment here or you can use their FAQ . The ROM website did a really good job of putting together the information that you need in a well-organized manner. I've done it once and I think the guide is very easy to follow. The only hiccup I've had with my marriage is during the  Appointment for verification & Statutory Declaration where both of us were required to read out a wall of text and my wife had difficulty getting past the first few lines and the counter guy got fed up and told my wife to stop. Definitely my oversight as I didn't arrange for an interpreter beforehand but luckily, there was a licensed interpreter at the scene and we managed to get her to do the interpretation ...
Read more

Commission Calculator for DBS Vickers SG Stocks

Made this little tool to help me calculate the costs of buying or selling a stock, just enter number of shares and price and it will show both buy and sell costs at the same time. Can even choose by cash upfront, online or phone and it will calculate using respective rates. Cash Upfront ONLINE By Phone Shares: Price: Value: Commission: Clearing Fee: ...
Read more