User Profile

Collapse

Profile Sidebar

Collapse
pragatiswain
pragatiswain
Last Activity: Jan 7 '09, 09:33 AM
Joined: Nov 16 '06
Location: India
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • pragatiswain
    replied to listener refused error
    I faced this problem in Oracle 8i. Only solution is Connection pool manager (CPM) should release all the DB connections after certain time-out interval defined in Connection pool manager if they are not used.
    You have have to manage connections using Connection pool manager.
    Lets say, your CPM creates a connection pool of maximum 10 connections. CPM should keep track of Total DB connections, Total exhausted connections.
    Lets...
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to insert into a data field
    TO_DATE(DATE_FI ELD || TIME_FIELD, <DATE_FORMAT> )
    DATE_FORMAT based on stored value in fields DATE_FIELD and TIME_FIELD
    example : 'MM/DD/YYYYHH24MISS'

    Hope this helps....
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to RoundUp script
    Write a oracle function with the following logic
    RoundUp(INPUT_V AL, INPUT_DEC)

    IF (INPUT_DEC >= 0) THEN
    BEGIN
    FOR 1..INPUT_DEC
    INPUT_VAL := INPUT_VAL * 10;
    LOOP;
    INPUT_VAL:= TRUNC(INPUT_VAL + 1);
    FOR 1..INPUT_DEC
    INPUT_VAL := INPUT_VAL / 10;
    LOOP;
    END;
    ELSE
    BEGIN
    INPUT_DEC = INPUT_DEC * (-1);

    FOR 1..INPUT_DEC...
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to Parallel Operation
    Select
    Insert
    Update
    Delete
    Can be done in parallel for performance improvement provided the m/c on which oracle server is running has more than one processors....
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to For.....loop
    Can try this one too.

    declare
    ibaseAmt number(10,2);
    iTotalAmt number(10,2);
    iMonth Number(2);

    Begin
    ibaseAmt := 1024;
    iMonth := 1;
    iTotalAmt:=ibas eAmt;
    dbms_output.put line('Month:'|| iMonth ||',Deposit Amt For This

    month: $'|| ibaseAmt ||', Total Amount Deposited: $' || iTotalAmt);
    While (iTotalAmt < 2047.50 )

    ibaseAmt := ibaseAmt/2;...
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to Oracle Function
    To convert to Character you need to use To_Char(integer ) function which basically gives you the ascii character corresponding to that integer value.

    For your example, I guess, you really don't need that....
    See more | Go to post

    Leave a comment:


  • Subquery keeps the sql more clear.
    May be you have to see the plan, cost and execution time of both the queries and choose the better one....
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to solve the query for me please
    Try this:

    declare
    iBaseSal number(10,2);
    iYr number(2);
    begin
    iBaseSal:=35500 ;
    iYr:= 1;

    For iYr= 1..6
    loop
    if (iYr > 1 and iYr <= 4) then
    iBaseSal:= iBaseSal * 1.04;
    if (iYr > 4) then
    iBaseSal:= iBaseSal * 1.055;
    dbms_output.put line('For Year:' || iYr || '-->' ||'Salary' || iBaseSal);
    end loop
    end

    Hope...
    See more | Go to post

    Leave a comment:


  • Please provide the "host string" and corresponding entry from tnsnames.ora
    for my reference to analyze the problem....
    See more | Go to post

    Leave a comment:


  • Howz this:

    Select * from (Select * from employee order by sal desc) where rownum < n+1
    Minus
    Select * from (Select * from employee order by sal desc) where rownum < n...
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to Trigger - Data from Multiple table
    If child table data is committed or inserting in the childtable happens in the same transaction, then there is no problem. Do as Suvam has suggested you.

    But if insertion in Child table happens in another session and not commited, you can not see the data. So, you have to design the application accordingly....
    See more | Go to post

    Leave a comment:


  • Suvam is right...
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to Query on Trigger
    TR1 will execute only for that user having access on the trigger....
    See more | Go to post

    Leave a comment:


  • I also stress more on security in a real production environment.
    Unix Environmental variables are user/session specific, which other users/sessions can't see.
    Set environmental variables for oracle User ID / PWD. which you can put in Unix user's .profile or ask the user at the time of login to unix environment.

    Hope this helps...
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to triggers
    It just doesn't store the status of the objects....
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to permanent to temporary
    Check this out.

    SQL> grant unlimited tablespace to <MY_USER>;
    --- Then Check Priviledges, should show "UNLIMITED TABLESPACE"
    SQL> select * from session_privs;

    Then try doing what you wanted to do....
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to Materialized View
    For Better understanding, go to
    http://www.adp-gmbh.ch/ora/concepts/materialized_vi ew.html...
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to data dictionary views
    I am not much experienced in this as I am just a user, not a DBA.
    May be the object user_data_files is not there as that user didn't create any tablespace/ doesn't have priviledge to create table space....
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to Dependencies in plsql
    See the answer @ http://www.thescripts. com/forum/showthread.php? p=2241625#post2 241625...
    See more | Go to post

    Leave a comment:


  • pragatiswain
    replied to triggers
    Object status is not recoded in Data dictionary. Status can be "Vadid" or "Invalid".
    Tables, sequences, and synonyms are always valid. But view, procedure, function, or package may get invalid, if the dependent objects are altered or deleted/ doesn't exist.
    Lets say a Stored Procedure SP1 is dependent on Table1. If Table1 is altered or deleted/ doesn't exist, SP1 becomes invalid. That info. is stored in USER_OBJECTS....
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...