Riddhi Valecha

Riddhi Valecha

  • 441
  • 3.3k
  • 411.5k

Oracle Query - Single Quotes and Characters

Jun 23 2015 4:37 AM
Hi all...
 
I have a variable -
PQUERY Varchar2(4000);
 
My QUERY is -
 
PQUERY  := PQUERY || 'select e.FName, e.LName, e.Age, e.Salary from Emp e where e. dtadded between to_date( 'Fromdate', 'dd-MON-yyyy') and to_date ('ToDate' , 'dd-MON-yyyy')'
 
Here -
 FromDate and ToDate are variables.
 
How to insert single quotes and characters in this string - Please help..

Answers (1)