1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

how to ask questions

Discussion in 'Introduce Yourself' started by anand, Nov 28, 2010.

  1. anand

    anand Guest

    hi, i am anand a new user to this oracle forum. i don,t know how to use this forum. if any body know please tell me.
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,990
    Likes Received:
    252
    Trophy Points:
    1,455
    Hi, Anand, just like this thread, post your question in a relevant category of the forum.
     
  3. Kranti006

    Kranti006 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    what is the error table for order import interface...
    pls can any one tell...?
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Redondo Beach, California
    Hi Kranti,

    You can ask questions here in their respective sections for quicker responses. And even it's easy to identify them if they were under respective sections. We can see those sections under forums tab section. Following is the navigation:

    Club-Oracle Forums Sections wise Navigation
     
  5. Abigail111

    Abigail111 Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    Hello,i am new too. I have the same question with you
     
  6. GSN

    GSN Guest

    Hi Karthik and Anand,

    Go to desired forums and to your top left corner you can find NEWTOPIC*. Just click on it and post your queries.Admin or other members will answer to your question.

    GSN. :)
     
  7. mustak

    mustak Guest

    what are the interface tables for project and task conversion
     
  8. sambuduk

    sambuduk Forum Advisor

    Messages:
    243
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Mustak ,

    First of all post the question in relevant section.

    There is an API called PA_PROJECT_PUB for Project and project Task interface/conversion.

    Regards
    Sambasiva Reddy.K
     
  9. saikumar pittla

    saikumar pittla Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    hyderabad
    CREATE OR REPLACE procedure xxorc_actual_SEMI(principal_amount number,interest_rate number,start_date date,end_date date)
    as
    Time_Monthly number;
    Interest_Amounts number;
    Time_Semi_Annual number;
    P_STARTDATE DATE :=START_DATE;
    P_ENDDATE DATE :=END_DATE;
    days number;
    begin
    days :=((to_date(end_date,'dd-mon-yyyy'))-(to_date(start_date,'dd-mon-yyyy')));
    Time_Semi_Annual :=months_between (p_enddate, p_startdate) /6;
    for i in 1..Time_Semi_Annual loop
    Interest_Amounts :=(Principal_Amount * Interest_Rate*days/360/100)/Time_Semi_Annual;
    dbms_output.put_line(ROUND(Interest_Amounts,2)||','||'start date: '|| p_startdate || ' end date:' || add_months(p_startdate -1,6));
    p_startdate := add_months(p_startdate,6) ;
    end loop;
    end;

    in leap year the interest amount will be differences pls check and update code
     
  10. RAMKUMAR

    RAMKUMAR Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Trivandrum
    Hi Team,

    We using windows platform . We are try to implement Oracle RAC grid setup

    While in RAC setup , we choose a ASM method .

    We not able to share a common disk region between two windows server

    Please share a complete steps for windows environment .