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
Hi, create table t_pivot (id number, l_id number, l_date date); begin insert into t_pivot values (1, 10, sysdate); insert into t_pivot values (2, 20, sysdate-2); insert into t_pivot values (3, 20, sysdate-2); insert into t_pivot values (4, 2, sys...
2 Forum: SQL & PL/SQL «» Posted on: Thu, 20 March 2014 08:00 «» By: saipradyumn
Pivot concept in procedures
Hi , I am able to run the following pivot query successfully. SQL> SQL> SELECT * 2 FROM (SELECT job, deptno, sum(sal) sal 3 FROM SCOTT.emp 4 GROUP BY job, deptno) PIVOT(sum(sal) FOR deptno IN...

Current Time: Sun Jun 16 22:01:26 CDT 2019