-
ORA-22818: subquery expressions not allowed here
Hi all
suggestion required.
iam getting this error. how to handle this or write this query.
SQL> CREATE MATERIALIZED VIEW MV_TMP_CALENDAR_DAYS AS
SELECT B.PORTFOLIO_GROUP_ID,
A.CAL_DAY_DT,
TRIM(A.CAL_MONTH_STR) REPORT_PERIOD,
TO_CHAR(CAL_DAY_DT, 'DD') -
(SELECT COUNT(*) FROM SOURCE_SYSTEM_HOLIDAYS B
WHERE TO_CHAR(A.CAL_DAY_DT, 'YYYYMM') = TO_CHAR(B.CAL_DATE, 'YYYYMM')
AND B.CAL_DATE <= A.CAL_DAY_DT) CURRENT_WORK_DAYS_NUM,
TO_CHAR(LAST_DAY(CAL_DAY_DT),'DD') -
(SELECT COUNT(*) FROM SOURCE_SYSTEM_HOLIDAYS B
WHERE TO_CHAR(A.CAL_DAY_DT, 'YYYYMM') = TO_CHAR(B.CAL_DATE, 'YYYYMM')) ALL_WORK_DAYS_NUM
FROM CCRT_CALENDAR_DIM A,
PORTFOLIO_GROUPS B;
(SELECT COUNT(*) FROM SOURCE_SYSTEM_HOLIDAYS B
*
ERROR at line 7:
ORA-22818: subquery expressions not allowed here
Thnx,
Luv
Kanna
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
|