Content between

sed -n "/COPY TABLE/,/'\.'/p" x.txt.

Line.

sed -n "/COPY TABLE/,/'\.'/p" x.txt

sed sed -n "/<Start>/,/<End>/p" <Input>

Part.

sed -e 's/<Start>\(.*\)<End>/\1/'