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
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 I insert a video from YouTube, some warnings and errors always occur. I search and find some tips to make YouTube Embed Video that you’ve insert is valid. Let’s take a look first with YouTube default Embed Code. <object... more
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 aware not to use it if not necessary. To make a good recursion, of course the functions must have a condition that makes it stop, so the function will not do an infinite looping. I’ve tried it... more
Okay, we have some folders that have a large amount of file. We usually use a detail-view to make us easier to manage and view these large amount of files. This detail-view can give you detailed info about your files, such as file size, file type and date modified. This picture below is my mp3s folder. In detail-view, Windows give me a detailed information about my mp3 files. The first column is the file name, followed by artist name, album name, track number, genre and rating. Detail View in Windows... 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.
