Making multiple lines as single line

Shell Programming and Scripting
1

Hi All,

I have a spool file which as shown below. I want to make it as single line after every semicolon. In this case there should be 2 lines in vi editor.

I am not used to use sed so could you guys please help me out ?

exec spk_dba.sp_runsql('ALP','CREATE DATABASE LINK "TEST" CONNECT TO "XXXXX" IDENTIFIED BY VALUES
''062F096622A83BB1E27623421592E22372352276DBD59F20B7BB3671ADFF0B92D43C5104203DC3AD46C5F6AD500EBA34AFC198EB2A2C06F97E1C37EAEF89
028B3F60F392917B4BA63617EBF1CE7D394E8823A35E2E4BFAFBE5C909B4539FE0C163CB2470A79AA64B2655C20C1D9D4D531D752AF1162DECF41B9D71F813''
USING ''XXXXXX''');
exec spk_dba.sp_runsql('ALP','CREATE DATABASE LINK "DENEME" CONNECT TO "XXXXX" IDENTIFIED BY VALUES
''068BE2BC85C67E30EFE04FD234234C0B1C1E7D0451C6DE58435D411EEE4DA39D1C81A251C0D5BB95643A04711572CB56757CFF296FE0DE05F033FFAA8BB37C4D42
45332D4AD2ECE2B035A774A7BCF5DBE814D93A035B595D9021B71DBACE249143C1A989AC5CF5A8C478A8768EE103CB981CF865E79D897B3A5306A2995975BA''
USING ''XXXXX''');
2 
tr -d '\n' < file | awk '{print $0 RS}' RS=';'
3

appreciated !