Recent Posts

Pages: 1 ... 7 8 [9] 10
81
PSOUG / Date Diff Function Not provided by Oracle- Here is one
« Last post by Prakash on September 25, 2013, 03:49:31 PM »
Code: [Select]
CREATE OR REPLACE FUNCTION datediff (p_d1 IN DATE, p_d2 IN DATE)
   RETURN NUMBER
AS
   l_result   NUMBER;
BEGIN
   SELECT (p_d2 - p_d1) + 1 INTO l_result FROM DUAL;

   RETURN l_result;
END;
82
PSOUG / sf_week_day_order
« Last post by Prakash on September 25, 2013, 03:48:01 PM »
Is there an automated function or procedure that gives the day of the week based on day and sorts the results by week days like SUN- MON - TUE - WED - THU - FRI - SAT.

I wrote this below function that may help return an order for the passed in day

Code: [Select]
CREATE OR REPLACE FUNCTION sf_week_day_order (weekday IN VARCHAR2)
RETURN NUMBER
AUTHID current_user
IS
/******************************************************************************
   NAME:       sf_week_day_order
   PURPOSE:    Function to return the order of the day in a week SUN - WED - SAT

   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.0        9/12/2013   prakash.gumudavelly       1. Created this procedure.

   NOTES:

   Automatically available Auto Replace Keywords:
      Object Name:     sf_week_day_order
      Sysdate:         9/12/2013
      Date and Time:   9/12/2013, 10:57:46 AM, and 9/12/2013 10:57:46 AM
      Username:        prakash.gumudavelly (set in TOAD Options, Procedure Editor)
      Table Name:       (set in the "New PL/SQL Object" dialog)

******************************************************************************/
BEGIN
   IF weekday = 'SUNDAY'
   THEN
      RETURN 1;
   ELSIF weekday = 'MONDAY'
   THEN
      RETURN 2;
   ELSIF weekday = 'TUESDAY'
   THEN
      RETURN 3;
   ELSIF weekday = 'WEDNESDAY'
   THEN
      RETURN 4;
   ELSIF weekday = 'THURSDAY'
   THEN
      RETURN 5;
   ELSIF weekday = 'FRIDAY'
   THEN
      RETURN 6;
   ELSIF weekday = 'SATURDAY'
   THEN
      RETURN 7;
   END IF;
END sf_week_day_order;
83
Oracle News / Cover Feature: Plug into the Cloud
« Last post by Mike on September 23, 2013, 05:06:27 PM »
Cover Feature: Plug into the Cloud
23 September 2013, 3:22 pm

Five years in the making and boasting more than 500 new features, Oracle Database 12c is here.

Source: Oracle Magazine - Most Recent

84
Oracle News / Get Ready: Oracle OpenWorld, JavaOne, and MySQL Connect
« Last post by Mike on September 20, 2013, 09:45:43 AM »
Get Ready: Oracle OpenWorld, JavaOne, and MySQL Connect
19 September 2013, 3:14 pm

September 21-26, 2013 is conference week in San Francisco.

Source: Oracle Magazine - Most Recent

85
Oracle News / Time Capsule: Open Source Milestones
« Last post by Mike on September 16, 2013, 01:00:40 PM »
Time Capsule: Open Source Milestones
23 July 2013, 11:43 am

Which open source software started as "just a hobby" for a Finnish University Student? Find the answer in Time Capsule.

Source: Oracle Magazine - Most Recent

86
Oracle News / Up Close: Cloud Builders Unite
« Last post by Mike on September 16, 2013, 01:00:40 PM »
Up Close: Cloud Builders Unite
24 July 2013, 4:40 pm

Bloggers, tweeters, and user groups work to form a cloud builder community.

Source: Oracle Magazine - Most Recent

87
Oracle News / Peer-to-Peer: Finding Help
« Last post by Mike on September 16, 2013, 01:00:40 PM »
Peer-to-Peer: Finding Help
25 July 2013, 2:31 pm

Peers get career boosts from the cloud, My Oracle Support, and Oracle University.

Source: Oracle Magazine - Most Recent

88
Oracle News / Oracle Magazine - September/October 2013
« Last post by Mike on September 16, 2013, 01:00:40 PM »
Oracle Magazine - September/October 2013
9 September 2013, 3:02 pm

Oracle Magazine September/October includes articles on Oracle Database 12c; a full conference preview; ORACLE TEAM USA; interviews with Paul Rodwick, vice president of product management at Oracle and Kyle Hailey, Oracle ACE and DBA; the latest news on cloud computing; what's happening on OTN; Arup Nanda, Steven Feuerstein and Tom Kyte on Oracle Database 12c and much more.

Source: Oracle Magazine - Most Recent

89
Oracle News / Oracle Magazine - September/October 2013
« Last post by Mike on September 09, 2013, 05:06:56 PM »
Oracle Magazine - September/October 2013
9 September 2013, 3:02 pm

Oracle Magazine September/October includes articles on Oracle Database 12c; a full conference preview; ORACLE TEAM USA; interviews with Paul Rodwick, vice president of product management at Oracle and Kyle Hailey, Oracle ACE and DBA; the latest news on cloud computing; what's happening on OTN; Arup Nanda, Steven Feuerstein and Tom Kyte on Oracle Database 12c and much more.

Source: Oracle Magazine - Most Recent

90
Oracle News / Peer-to-Peer: Finding Help
« Last post by Mike on July 25, 2013, 05:01:34 PM »
Peer-to-Peer: Finding Help
25 July 2013, 2:31 pm

Peers get career boosts from the cloud, My Oracle Support, and Oracle University.

Source: Oracle Magazine - Most Recent

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