Oracle PL/SQL Packages

PL/SQL package is used to group related PL/SQL code and constructs together.

There are two parts of PL/SQL package:

1. Package specification - declares the public components of the package
2. Package body - implements public and private components of the package

Below is an example of PL/SQL package.

CREATE PACKAGE reg_pkg IS
PROCEDURE getstud;
FUNCTION total_student RETURN NUMBER;
END reg_pkg;
/
CREATE PACKAGE BODY reg_pkg IS
PROCEDURE getstud IS ...
BEGIN ... END;

FUNCTION total_student RETURN NUMBER IS ...
BEGIN ... RETURN total_stud; END;
END reg_pkg;
/




Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Thoughts

Always think of the things that you want. If it’s money that you want to attract, you should think of money. If it’s relationship, you should think of relationship. If it’s car, you should think of car.

If you think of poverty, then you will attract poverty. If you think riches, you will attract riches. If you think of happiness, you will attract more happiness. If you think of loneliness, you will attract more loneliness.

You should monitor your thoughts. Don’t think of the things that you don’t want. Think of the things that you do want. In 24 hours, we have lots of thoughts. It would make you crazy if you will monitor your thoughts every moment. The easiest way to monitor your thoughts and to make sure that you have good thoughts is to ask yourself this question: “How do I feel now?”. If your answer is “I feel good”, then you’re in the right track. You should think of the good things. You might want to think of your loved ones and ask yourself the same question until your answer is “I feel good”. Keep on doing that and you will attract good things into your life.



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Prayer

Every night before you sleep, pray for the things that you want. And there is one secret that you should know about how to have an absolute faith. Know what you want and ask for it just once in your prayer. The next and succeeding nights of your prayer should not ask for it again. You should believe that you already received what you asked. Instead of asking for it again, you should be grateful for you already received what you asked. Always say ‘Thank you’ to God and feel good. That’s the absolute faith!



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Talking about the lack of money

If you’re talking to your friends or to anyone that you don’t have enough money, then you will not have enough money in the future because that’s what you attract. But if you say to them that you have more than enough, you will attract that thought.

There is a miracle or great secret in attracting more money into your life. And the secret is to give more to charity or church. The more you share, the more you will have. As you share your blessings, you should feel good. If you don’t feel good, you will never attract money or any good things to your life.



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Emotion of Love

Love is the key to every problem on earth. Without love, there will be war.

Have you ever tried to get angry with anyone? If your answer is no, you’re good at controlling your emotions. Emotion of love dominates in you. If your answer is yes, this blog would help you to eliminate any emotion of anger and emotion of hatred that reside in your heart and mind.



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Emotion of Gratitude

Be grateful for everything you have. In this way, you will attract more good things into your life. As you wake up in the morning, say thank you. Before you sleep, say thank you.



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

The great power of Smile

Smile attracts good things. Everyday, never ever forget to smile. Aside from smiling will make you younger, it will also attract good things into your life. When you smile, it means that you feel good.



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Feel Good When Giving Money to Church or Charity

When you are giving money to charity or church, you should feel good. That’s the secret of people who acquire great wealth.



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

The Power of Leverage

Using other people’s time and effort is an example of leverage. If you have a big project or work, try to use other people’s time and effort and you’ll find that the work is easier to do.

In order to be rich, you have to think on how you could use other people’s time and effort in such a way that both of you have mutual benefits. The best example here is the relationship of an employer to employees. Employees render useful services for the benefit of the employer. In return, employer pays the employees for the services they rendered. It’s just a matter of give and take. In this scenario, it is very obvious that the employer has more benefits than the employees because employer did not work hard. The employer uses his employees’ time and effort to acquire more money into his life.



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Oracle PL/SQL Anonymous Block

Anonymous blocks form the basic PL/SQL structure. It is unnamed PL/SQL block. It is used to initiate PL/SQL processing tasks from applications.

Here's the structure of anonymous block:

[ DECLARE
... optional declaration statements ... ]

BEGIN ... Start of block (Mandatory) ...
... executable statements ...

[ EXCEPTION
... optional exception handler statements ... ]

END; ... End of block (Mandatory) ...


The square brackets indicate an optional part. DECLARE keyword is optional but it is required if you declare variables. BEGIN and END are mandatory and require at least one statement between them, either SQL, PL/SQL, or both.

Here's a very basic example of anonymous block:

BEGIN
DBMS_OUTPUT.PUT_LINE("Hello, World!");
END;



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

My Dream House

The picture above is my dream house. I just want to know if the Law of Attraction really works. Napoleon Hill said "Whatever the mind of man can conceive and believe, it can achieve". W. Clement Stone said "Whatever the mind of man can conceive and believe, it can achieve through positive mental attitude".

Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

My College Days

When my high school graduation was about to end, I said "I will take BS Computer Engineering in a private school". Unfortunately, my parents can't afford the private school so I decided to study in Pangasinan State University (PSU) which is a public school. I took up PSU's entrance exam and I passed it.

I was disappointed when I learned that my preferred course doesn't exist in PSU. I took up BS Computer Science since it is a little bit close to BS Computer Engineering. Whew... :)

I did my best to get high grades for the four consecutive years. Fortunately, I got high grades and learned many things. I'm very thankful for I met Mr. Rolando Andico who encouraged me to learn PHP, MySQL, Linux, HTML, XML, and Oracle SQL. From second year college to fourth year college, I stayed to Mr Andico's office during my vacant time and every Saturday. Mr Andico encouraged me to read books and use the available computers in his office. Mr Andico's former students like Jully Manuel, Aileen Medina, Julio Cervantes, Antonio de Guzman, Rey Sarmiento, and his other former students encouraged me to learn more. I'll always remember those people who became a part of my success.

I also want to thank my classmates, schoolmates, and teachers in Pangasinan State University.



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

What is Twitter?

Twitter is now very popular in the web. It is a platform for sending frequent short messages (or tweets) to many people from your phone or the Internet, and receiving the same from others. I already have an account at Twitter. You might want to sign up now and follow me. I'll also follow you. :)



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Beautiful House in Kennon Road, Baguio City

The picture at the right was taken from Kennon Road in Baguio City. I admire its great location. I wish I could have a house like that.

I took that picture last December 25, 2008 8:15AM. What can you say about the picture?

Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Apache2 PHP5 LoadModule problem: Apache won't start

Most of the PHP programmers get this error when installing PHP and Apache:

Apache2 PHP5 LoadModule problem: Apache won't start

The reason why they get this error because they might be using Apache 2.2.x and they added this in their httpd.conf:

LoadModule php5_module C:/php/php5apache2.dll

If you're using Apache 2.2.x, this is the right line to be added in httpd.conf (please take note of the bold font below):

LoadModule php5_module C:/php/php5apache2_2.dll



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

Mines View in Baguio City Philippines

The picture at the left was taken in Mines View Park, Baguio City, Philippines. It was taken at around 4PM on December 26, 2009.Many Filipinos and other foreigners visit this popular place in Baguio City, Philippines. If you're from outside of the Philippines and not visited this place yet, I encourage you to visit this great place.

Feel free to leave your comment on this picture.

Thanks for visiting my blog :)



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!

If you need something, give that something

There’s a great power behind giving. If you give something, you will receive that something. It doesn’t care whether that something you give is good or bad. So be careful to the things that you give.

If you need smile from someone, give smile to that someone and you will receive more smiles not only from that someone but also from all the people around you.

If you are short of money and need more money, give money to your church or to your favorite charitable institutions. That works for me and to many people who know the secret of giving. Some people may say, “Only rich people could do that because they have lots of money. We the poor people could not do that.” My answer to that statement is that most rich people came from the status of being poor. When they were poor, they apply that secret. They give money to their church or to their favorite charitable institutions. And now that they’re already rich, they still keep on giving for they know the great power behind giving.

But there’s something to understand in giving. If you give, you should feel good. That way, you will receive more good things. If you feel bad while giving, you will receive bad things instead of good things.



Make money from your Website or Blog with BidVertiser
Your Ad Here for FREE!