Rename a Column Oracle

Midterms “season” has begun at university. So far 1 down (databases) few more to go this week and over the coming weeks. I already got the result of my databases midterm, it was way better than I expected.

I thought I had lost more than 2 points (yes I was 2 points short of a full mark :-P), especially in a the fill in the blanks part where I kept thinking “this should be filled here, oh wait no this looks similar as well, maybe its here, maybe here?…”

The exam had a practical part where we had to use Oracle, create some tables and run some queries.…

Database Problems

If you tried to visit my blog a while ago you were probably greeted with an ugly WordPress error about database problems… My bad…

What happened? Well, I had this lab for my database class, I decided to give it a try on MySQL running in my VPS. I thought, why not create username X? I got some funny errors in MySQL which I decided to ignore, simply because I thought it was a syntax error.…