In PL/SQL* Oracle, we can use conditional statement like other programming language, such as CASE and IF statement. How to do it in PL/SQL? Here’s the syntax for IF statement.
IF condition THEN
statements;
[ELSIF condition THEN
statements;]
[ELSE
statements;]
END IF;
Just remember, I write ELSIF, it’s on purpose and it’s not mistyping, in this case [...]
After a long sleep, I’m back and I want to start with a new topic, database. Okay, the database I’m talking about is Oracle, with using PL/SQL commands. The first time of this topic, I will talk about making sequence in Oracle. What is sequence? We can imagine sequence as a table that keep, of [...]
What can I get by validating XHTML in my blog? Well, some people say it can help Uncle Google to read and crawl your site, because Uncle is older and older and more hard to do reading. Before I use this code, my blog home page is always not valid due to a reason, after [...]
What exactly recursion is in programming? Recursion is a function that calls the function itself. Thus, in the body of function there is a command that called the function itself. If you use it well, it can solve a problem much more simple and easy. Recursion itself uses a large amount of memory, so be [...]
Let’s get to the point, what’s the different beetwen Circular and Linear? Just like previous post, the different is the head is always move around or you can say dynamic. The first and the last data is likely become linked to another one. If we do enqueue, the tail will be point to the new [...]
This time, we will talk about Boyer Moore string searching. It’s not like brute-force, it will search a substring from the back and go forward till the first char of string. For example, we search a substring EXAMPLE within HERE IS A SIMPLE EXAMPLE string. I can’t explain it well, so this below maybe rather [...]
This post is the second part of how to install Oracle Database 10g. After you finished installing the database, you can start by installing the listener. Just open Net Consfiguration Assistant in start menu -> all programs, usually found at Oracle - OraDb10g_home1 (default name in start menu) -> Configuration and Migration Tools -> Net [...]
These days, who don’t know Oracle? Many firms and DBA use this software to keep them earn money and keep their database that contains many sensitive information. But unfortunately, installing Oracle is a bit difficult, because for the beginner, they don’t know many words, words that they never hear before, and moreover Oracle gave many [...]
This part of Linear Single Linked List will tell you how to delete a node at any index. It’s simple like adding a data, you just have to change the node pointer to other that next to the node that you want to delete. If you want to delete the most front data, you have [...]
Hey, back to programming again in data structure. It’s now about Linked List, a linear single linked list it’s about to be explained in this post. We can imagine this like a chain, every data has a link to another data. Single Linked List is different from array. In array, we can only insert a [...]
In some case, there is a few that use Microsoft Office 2007. Most of them still using Microsoft Office 2003, and Microsoft Office 2007 brings a new format, smaller file size and new extension, like .docx that replace old .doc. But somehow, Microsoft Office 2003 can not open this new format. This is of course in Microsoft Word 2007, you have to save as Word 97-2003 Document. Unfortunately, you forgot to change your word document into .doc format and you couldn’t open it in your office computer because their computer didn’t use Microsoft Office 2007. There’s an important document and project to be shown to your superior, you couldn’t do anything but begging to delay it to the next day, scolded, salary-cut, kicked from the job, go home and tell to your wife that you didn’t bring any money and your wife left you, wait wait, these are not the main problem, but these things can be happened to your life. So for the main problem, how can I always remember to save as... more
Does Windows XP or Vista not running as usual? Some missing shortcut and Windows wallpapers could make people feel uneasy and annoying. Maybe you’ve installed some programs but not successfully installed on your computer. After you’ve installed it, Windows can’t get itself run normally. Can’t run Task Manager, Windows always displaying error messages, you don’t have to format Windows. Windows has the built-in System Scan to check the current system files with the original... more
Let’s get to the point, what’s the different beetwen Circular and Linear? Just like previous post, the different is the head is always move around or you can say dynamic. The first and the last data is likely become linked to another one. If we do enqueue, the tail will be point to the new data. If you can see the picture below, you will know that the data are never move like linear queue, but the head node. This head node always move when you do dequeue and enqueue new data. Circular... more
w1953s-pf Yes, it is an LCD monitor that has reasonable price with low consumption energy and also for me has an elegant design. It has some differents with 1953T, such as connection port, W1953S-PF only with analog-RGB connection that I think LG can cut the price just for only est. USD 125 now. For response time, W1953S-PF is set to 5 ms, while w1953T has 2 ms, this is the main factor that can drop the price of W1953S below W1953T. For W1953S, it is 18.5″ and W1953T is 19″. This LCD... more
Hello, world! I am Feby Purnama Tanzil. I live in Indonesia and still do college in Petra Christian University. With this blog I want to share my life and experience and want to help to solve your problem or find what you’re looking for. Oh, and I want to try to build a good blog. With this blog, I want to try something new, something that I’ve never done before. I want to improve my English with this blog, learn to write and learn to manage something that I have. And actually, I want to learn about PHP and other things related to it, it’s very interesting to me. I hope your comments soon can help me to improve this blog, the contents and appearance. And something I must tell you, I’m not so good with English, so if you find something weird, just tell me, give me comment about that and I will fix it. I’m looking for your comments. Thank you.
