Also if you have time, I'm having trouble with the other trigger I have to write. These things are a real pain...

I have another table called NewsFeed with columns newsFeedID(INTEGER), feedMessage(VARCHAR2(100)).

4. Create a trigger after insertion on UserBlog that:
a. Inserts a row into NewsFeed using seq_newsFeedID to generate a primary key.
b. The feedMessage should be the username then a day description followed by the blogEntryTitle. If the date is today or yesterday, the day description should be "Today" or "Yesterday". Otherwise it should be "X days ago". Examples:
i. "Brad--Today--Blog Title"
ii. "Brad--Yesterday--Blog Title"
iii. "Brad--7 days ago--Blog Title"

I have to go to work right now so I can't really work on it anymore tonight, so I would really appreciate any help! Thanks again.