Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
2 Search Results Found
1 Forum: SQL & PL/SQL «» Posted on: Thu, 19 May 2016 05:58 «» By: pointers
sysdate in the pivot in clause
…IN" clause, it throws me an error. ORA-56901: non-constant expression is not allowed for pivot|unpivot values My query is - select * from (select id,l_id, l_date from t_pivot) pivot ( sum(l_id) for l_date in ( TRUNC(sysdate…
2 Forum: SQL & PL/SQL «» Posted on: Thu, 20 March 2014 08:00 «» By: saipradyumn
Pivot concept in procedures
… ORA-06550: line 17, column 65: PL/SQL: ORA-56901: non-constant expression is not allowed for pivot|unpivot values ORA-06550: line 14, column 5: PL/SQL: SQL Statement ignored IS there any alternate to use the dynamic values in pivot ? …

Current Time: Sun Dec 08 07:20:37 CST 2019