Oracle PL/SQL Cheatsheet

Just a tip for anyone who is interested.... This is really tough to get a good copy when you try to print this. I found it easier to copy it into a Word document and print it from there. It comes out a lot neater and much easier to read. Just thought I would pass that along. This is a great cheatsheet. It is really helpful.

Renaming a column

During class, Dan found this reference on renaming a column:
http://www.dba-oracle.com/t_rename_column_table.htm
Version 9i was the first to allow this - prior to that you had to work around.
SQL> alter table first rename column stadr to streetadr;

Loading Oracle

If you have successfully loaded Oracle at home, please let us know so people having questions can post their questions.

Welcome

This blog is for students registered in CIS50 and the professor.