-
Error in Sql Statement
SQL> SELECT a.deptno, a.dname, a.loc,
2 rowtocol('SELECT DISTINCT job FROM emp WHERE deptno = ' ||a.deptno) as jobs
3 FROM dept a;
DEPTNO DNAME LOC JOBS
---------- -------------- ------------- -----------------------
10 ACCOUNTING NEW YORK CLERK,MANAGER,PRESIDENT
20 RESEARCH DALLAS ANALYST,CLERK,MANAGER
30 SALES CHICAGO CLERK,MANAGER,SALESMAN
40 OPERATIONS BOSTON
SQL> SELECT a.deptno, a.dname, a.loc,
2 rowtocol('SELECT DISTINCT job FROM emp WHERE LOC='NEW YORK' AND deptno = ' ||a.deptno) as jobs
3 FROM dept a;
rowtocol('SELECT DISTINCT job FROM emp WHERE LOC='NEW YORK' AND deptno = ' ||a.deptno) as jobs
*
ERROR at line 2:
ORA-00907: missing right parenthesis
-
Code:
SELECT a.deptno, a.dname, a.loc,
rowtocol('SELECT DISTINCT job FROM emp WHERE LOC=''NEW YORK'' AND deptno = ' ||a.deptno) as jobs
FROM dept a;
Double-up on the single quotes inside literal strings. Not double-quotes, two single-quotes.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|