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
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 we write “else if” in PL/SQL as ELSIF. There is an example for IF statement usage in PL/SQL. This statement will... more
Many webmasters/ bloggers want their websites/ blogs have many visitors, including me. How to increase the traffic of our website? Lot of people gave many tips about this and I’m here to summarize and collect some of the useful tips they’ve made. Make your article title SEO, good title has eye-catching topic, short and make some of your title is the keyword that highly used in search engine but still relevant with the article. Make an up to date article, when Michael Jackson died many people... more
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 course, sequence numbers, this will be useful when you need to make sequence of numbers automatically, so you don’t have to make a new column that save those numbers or insert it manually. To... 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.
