PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Using single and double quotes in an expression in PSQuery

edited Apr 2, 2013 8:02AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered ✓
I am creating custom queries in PS Query in tool 8.51 and in one case, I am creating a case statement.
I am testing for NULL and for ' ' (space) and after the END statement I want to include AS "DEPT_ID" so that my SQL is generated accurately.

PS Query will not let me use both single and double quotes, even tho it is required in this case for the Oracle SQL to come out correct.

How do I use both single and double quotes in my expression? Has any done anything similar and found a work around?

2nd part of question is then it does not appear when I use the AS "DEPT_ID" (omitting the ' ' for testing) other expressions, referring to the field name "DEPT_ID" (yes, I used it as a field name and edited the field so the title was DEPT_ID and the unique name is DEPT_ID as well) it does not find that DEPT_ID is a valid column name.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center