TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Riddhi Valecha
444
3.3k
412.7k
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..
Reply
Answers (
1
)
validation of hyphen in the beginning or at the end
Validation of viewstate MAC failed