Recent Posts

Pages: 1 ... 6 7 [8] 9 10
71
PSOUG / Re: Date
« Last post by Prakash on October 07, 2013, 09:57:27 AM »
This is just an idea - it need to be tried on your schema and system. Thinking that you want a grand total (sum) for certain months.

Code: [Select]
SELECT "Grand Total - June 2009 - September 2009", SUM(plan_total)
FROM (SELECT TO_CHAR(c.END_DATE,'MM-YYYY') years,
   SUM (b.plan_total_lcl) plan_total,
   SUM (b.actual_total_LCL) actual_total
   FROM KCST_BUDGET_PERIOD_SUM a,
   KCST_CURRENCY_LINES b,
   KNTA_PERIODS c
   WHERE a.BUDGET_ID = (SELECT z.PRJ_BUDGET_ID FROM KCRT_FG_PFM_PROJECT z WHERE z.REQUEST_ID = 43985)
   AND a.currency_line_id = b.currency_line_id
   AND c.period_id = a.period_id
   GROUP BY TO_CHAR(c.END_DATE,'MM YYYY')
   ORDER BY 1) X
WHERE to_char(Years,'MM-YYYY') between to_char('01-06-2009', 'MM-YYYY') to to_char('01-09-2009','MM-YYYY');
72
PSOUG / Re: Date Question
« Last post by Prakash on October 04, 2013, 02:04:41 PM »
/* Formatted on 10/4/2013 4:02:34 PM (QP5 v5.240.12305.39476) */
SELECT CASE
          WHEN TO_CHAR (TO_DATE (SYSDATE, 'dd/mm/yyyy'), 'DAY') = 'MONDAY'
          THEN
             SYSDATE + 4
          WHEN TO_CHAR (TO_DATE (SYSDATE, 'dd/mm/yyyy'), 'DAY') <> 'MONDAY'
          THEN
             SYSDATE - 1
       END
          expected_date
  FROM DUAL;
73
Oracle News / Database Cloud: Many in One
« Last post by Mike on October 03, 2013, 05:01:40 PM »
Database Cloud: Many in One
3 October 2013, 3:24 pm

Create many databases in one database instance with the Oracle Database 12c multitenant architecture.

Source: Oracle Magazine - Most Recent

74
PSOUG / exact fetch returns more than requested number of rows
« Last post by Prakash on October 03, 2013, 01:49:11 PM »

-- Example to show error message - "exact fetch returns more than requested number of rows"
Code: [Select]
DECLARE
   x   DUAL.dummy%TYPE;
BEGIN
   SELECT dummy
     INTO x
     FROM DUAL, (SELECT * FROM all_users);
END;

--Solution to correct this is by fetching rows that can be accommodated into the catching variable.
Code: [Select]
DECLARE
   x   DUAL.dummy%TYPE;
BEGIN
   SELECT dummy
     INTO x
     FROM DUAL;
   -- SELECT * FROM all_users; --Can't do this here
END;

-- This error occurs when more number of rows are retrieved and being assigned to a variable
-- that can hold only one single value. You need to retrieve only row(s) that can be held in the
-- catching variable
75
Oracle News / Mash Up
« Last post by Mike on October 02, 2013, 05:04:05 PM »
Mash Up
2 October 2013, 12:17 pm

Get bite-size information on gadgets, apps, and books.

Source: Oracle Magazine - Most Recent

76
Oracle News / Feature: Faster
« Last post by Mike on September 30, 2013, 05:02:48 PM »
Feature: Faster
30 September 2013, 11:44 am

ORACLE TEAM USA uses Oracle technology to deliver extreme speed in the America's Cup.

Source: Oracle Magazine - Most Recent

77
Oracle News / News: Cloud Computing Breakthrough
« Last post by Mike on September 26, 2013, 05:04:10 PM »
News: Cloud Computing Breakthrough
26 September 2013, 12:00 pm

Oracle unveils new multitenant architecture in Oracle Database 12c.

Source: Oracle Magazine - Most Recent

78
Oracle News / Ask Tom: Oracle Database 12c, Part 1
« Last post by Mike on September 26, 2013, 05:04:10 PM »
Ask Tom: Oracle Database 12c, Part 1
26 September 2013, 12:00 pm

Now that Oracle Database 12c is here, our technologist takes you through some key features: improved defaults, bigger datatypes, and top-N queries.

Source: Oracle Magazine - Most Recent

79
Oracle News / News: Cloud Computing Breakthrough
« Last post by Mike on September 26, 2013, 05:04:10 PM »
News: Cloud Computing Breakthrough
26 September 2013, 12:00 pm

Oracle unveils new multitenant architecture in Oracle Database 12c.

Source: Oracle Magazine - Most Recent

80
Oracle News / Ask Tom: Oracle Database 12c, Part 1
« Last post by Mike on September 26, 2013, 05:04:09 PM »
Ask Tom: Oracle Database 12c, Part 1
26 September 2013, 12:00 pm

Now that Oracle Database 12c is here, our technologist takes you through some key features: improved defaults, bigger datatypes, and top-N queries.

Source: Oracle Magazine - Most Recent

Pages: 1 ... 6 7 [8] 9 10