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
When we make a blog or site, we usually wonder, who is visiting our site? Where they are coming from? We want to know how interesting our blog is. We want to improve our blog, but how we do that? We don’t know what visitors like, so I have a suggestion to that matter. It is a site meter. First step, you must sign up first and choose Site Meter Basic Free Fill the form Your Site’s URL with your URL blog/ site Fill the form Your Site’s Name with your site’s name of course And... more
Recently, I have started using a great web search service that allows me to earn money from searching in my normal way. It`s quick and free to set up, keeps you up to date on your earnings and pays out monthly. What you have to do is sign up from here. After you signing up, you will get your account ID and password. Keep it safe, because you must log in with your first password before you can change your password. After log in, you will see a page that show news, today searches, earnings and your... 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.
