They are usually small snippets of javascript that can be stored as a bookmark, then called up to provide specific functions.
See BookMarklets for an extensive list of bookmarklets for Opera.
Other sites offering bookmarklets :
CategoryOpera
CategoryTechnical