var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Single Quote in PLSQL
I am new to this group and have a question.
I have to select name from database with SELECT query. Buy if ther is single quote in name I have to ignore it.
eg. if name is Vijay'Garg it should appear vijay garg (' replaced with space)
Can you give me solution like
SELECT convert(name, ''', '') from Table
SQL> select * from a;
SQL> select replace(sch,'''',' ') from a;
Oracle can do wonders !