about raise exception

According to user guide, both Raise Notice & Raise Exception will write
message to database log. Which system table is the database log about?

By the way what is the difference between Raise Notice & Raise Exception?


Jack