Space is removing at end of the line While running the insert script in sql*plus, space is removing. Can you please help us is there any plus command available in Oracle to not remove space at end of the line.

Ex: After the text 'Ameerpet,' we have space in the insert script. I have run this command through sql*plus it was success but in output space got removed.

insert into emp values(1,'&lt;p style="font-weight: bold; margin-top: 10px;"&gt;Mithrivanam, Ameerpet, 
Hyderabad, Telangana, 500018&lt;/p&gt;');


Output:

&lt;p style="font-weight: bold; margin-top: 10px;"&gt;Mithrivanam, Ameerpet,
Hyderabad, Telangana, 500018&lt;/p&gt;
If you really want to have that specific space and line break, you should not rely on enviroment settings, but explicitly specify it:

insert into emp values(1,'&lt;p style="font-weight: bold; margin-top: 10px;"&gt;Mithrivanam, Ameerpet, ' || chr(10) ||
'Hyderabad, Telangana, 500018&lt;/p&gt;');