Large objects are known as LOBs. CLOBs are character large objects, and BLOBs are binary large objects.
You can work with LOBs using the same techniques you use for smaller data types, unless the objects are too large to fit into memory. When a LOB is too large to fit into memory, you must use streaming techniques to move the data.
Streaming involves "chunking" data, which means moving data in chunks to keep from using too much memory.