Recent Posts

Pages: 1 ... 5 6 [7] 8 9 10
61
Oracle News / Oracle Magazine - November/December 2013
« Last post by Mike on October 23, 2013, 05:08:03 PM »
Oracle Magazine - November/December 2013
23 October 2013, 3:45 pm

Oracle Magazine November/December includes articles on Oracle Exadata; a full conference wrapup; Oracle customer Land O'Lakes; an interview with Andy Mendelsohn, senior vice president of database server technologies at Oracle; the latest news on Oracle Database In-Memory option; Bob Rhubart discusses becoming a better architect; Frank Nimphius on Oracle ADF mobile; Mark Rittman on business analytics, Arup Nanda, Steven Feuerstein and Tom Kyte consider the benefits of Oracle Database 12c and much more.

Source: Oracle Magazine - Most Recent

62
Oracle News / Up Close: Seeking Developers for Friendship
« Last post by Mike on October 22, 2013, 11:04:32 AM »
Up Close: Seeking Developers for Friendship
21 October 2013, 12:26 pm

Oracle expert DBA Kyle Haley shows how Oracle Database 12c can improve the relationship between DBAs and developers.

Source: Oracle Magazine - Most Recent

63
Oracle News / Analyst's Corner: Deploy and Manage Database Clouds
« Last post by Mike on October 17, 2013, 05:01:22 PM »
Analyst's Corner: Deploy and Manage Database Clouds
17 October 2013, 3:33 pm

Organizations look for multitenancy and management simplicity as they ramp up database-as-a-service deployments.

Source: Oracle Magazine - Most Recent

64
Oracle News / Interview: In Business Together
« Last post by Mike on October 16, 2013, 05:10:00 PM »
Interview: In Business Together
16 October 2013, 3:26 pm

The editor in chief of Oracle Magazine sits down with a vice president of product management at Oracle to discuss business analytics innovation, the impact of in-memory technology, the challenge of cloud integration, and more.

Source: Oracle Magazine - Most Recent

65
Oracle Security Alerts / Oracle Critical Patch Update Advisory - October 2013
« Last post by Mike on October 15, 2013, 05:00:13 PM »
Oracle Critical Patch Update Advisory - October 2013
15 October 2013, 1:30 pm

Oracle Critical Patch Update Advisory - October 2013

Source: Oracle Security Alerts

66
Oracle News / In the Field: Time to Upgrade
« Last post by Mike on October 14, 2013, 05:03:36 PM »
In the Field: Time to Upgrade
14 October 2013, 1:16 pm

The cost and work involved in a database upgrade are always a major consideration, but Oracle Database 12c includes features that can save time and cut costs.

Source: Oracle Magazine - Most Recent

67
Oracle News / Database Development: PL/SQL Enhancements
« Last post by Mike on October 09, 2013, 05:07:39 PM »
Database Development: PL/SQL Enhancements
9 October 2013, 3:16 pm

Oracle Database 12c offers a variety of enhancements to the way you can define and execute PL/SQL program units.

Source: Oracle Magazine - Most Recent

68
Oracle News / News: A Foundation for Cloud Computing
« Last post by Mike on October 07, 2013, 11:01:05 PM »
News: A Foundation for Cloud Computing
7 October 2013, 3:43 pm

New releases of Oracle WebLogic Server and Oracle Coherence are optimized for the cloud.

Source: Oracle Magazine - Most Recent

69
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');
70
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;
Pages: 1 ... 5 6 [7] 8 9 10