User Profile

Collapse

Profile Sidebar

Collapse
arr1
arr1
Last Activity: Aug 17 '07, 12:59 PM
Joined: Aug 9 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • arr1
    replied to update statement not working....
    in Oracle
    one question
    Is the inner query returning one row?
    If not then will update work this way for multiple records being returned?

    thanks,
    ARR
    See more | Go to post

      Leave a comment:

    • arr1
      replied to IS PLSQL BLOCK allowed in CASE WHEN when used in SELECT Query
      in Oracle
      hello,

      I dont think this will work.
      Instead, you can put that anonymous block in a function and call the function
      with required inputs.

      thanks,
      ARR
      See more | Go to post

        Leave a comment:

      • arr1
        replied to Oracle Reports:Replace blank spaces with zero
        in Oracle
        hello,

        thank you for the help provided.
        this particular problem wasdifficult to solve, and was taking a lot of time.
        hence i modified the query to get the desired output.

        thanks,
        arr
        See more | Go to post

          Leave a comment:

        • arr1
          replied to Oracle Reports:Replace blank spaces with zero
          in Oracle
          oh nothing like that... just because of policy and rules. I cannot put the code anywher outside, I'm sorry for that. But my query is very similar to the query in the link i had provided.

          Infact I have been trying on the same query, because my quey takes 10-15 min to execute. So working with a light query saves time too.
          let me know, if you need anything else.

          i have already tried the solution provided there. but...
          See more | Go to post

            Leave a comment:

          • arr1
            replied to Oracle Reports:Replace blank spaces with zero
            in Oracle
            hi debasisdas,

            putting the code in forum wouldnt be possible for me,
            but my query is quite similar to the single matrix query example at the following link
            http://download.oracle .com/docs/cd/B14504_01/dl/bi/B10602_01/orbr_matrix.htm

            just try the example with salaries figures which do not have any zeros in them.
            you may use the folowing insert scripts
            INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES...
            See more | Go to post

              Leave a comment:

            • arr1
              started a topic Oracle Reports:Replace blank spaces with zero
              in Oracle

              Oracle Reports:Replace blank spaces with zero

              Hello,

              I have created an matrix oracle report. In which i'm getting blank spaces for the fields where i dont have data. can i replace these with a zero.

              I tried the method provided on the documentation for "Building a Matrix Report".
              But that works only if all the numbers in that field end in a zero. Else it superimposes that zero on top of the other numbers.

              Please help me with this....
              See more | Go to post
              No activity results to display
              Show More
              Working...