Recent content by urchin556

Thanks. I really appreciate your help.

Thanks. I dont know how many records will be returned.So is there any way to handle that. rather than doing this for i in 1..3 loop thanks a lot again

Hi , I have a package which uses a record type(defined in specification) TYPE cont_rec IS RECORD (cont_id Number ,cont_number Number ,cont_number_modifier Number ,s_l_id Number); TYPE cont_tbl IS TABLE OF cont_rec INDEX BY BINARY_INTEGER; and in package body a procedure is called...

I need to write a procedure which will purge a table having more than 8 crores records based on the parameter passed by the user.We have open a cursor and in loop we are deleting one by one and when the count reaches 50,000 we issue commit so the rollback segment problem can be avoided.But this...

Hi friends, I have a report which has 3 breakgroups ..means i have 3 repeating frames in my layout. The 3rd frame displays all the employees of the company.My problem is I want to show all the dept for the displayed employees at header level i.e. Withing first frame and those should be...

The second option is to create write a code in after parameter form and then use it as lexical parameter. For e.g After parameter form if :p_start_date is not null then lp_date := ' and date_received >= :p_start_date ' end if; and in the main query add the lexical parameter &lp_date This...

I am submitting a concurrent program and inside that there is a for loop and in this loop a oracle standard API is called which i can not touch. This API submits multiple concurrent requests for a particular report with in a for loop so for a single run of main concurrent program a number of...

Hi Guys, My query is taking lot of time and i had try to reduce the time taken by it. After all the things i have done following are the statistics 7 recursive calls 13 db block gets 3040505 consistent gets 37502 physical reads 0 redo size...

Hi Guys, I am making a matrix report in which there are 3 cells.I am taking this report format into excel with fields as comma seperated so in the layout i had put ',' after every field.But in matrix if there is no record for that row and column it doesnt print ' ,' which is in the...

Hi Guys, I need a urgent solution for a problem.I am using the following query select ename from emp where deptno =10 Now I will declare a bind variable and if user passes 'A' then the query will run as it is and if he passes B then it should run the above query with this additional...

Hi guys , I need to make a matrix report like the following Description Year(2002 Full),Year(2002 Till Date),Year(2002 Till Month),Year(2003 Full),Year(2003 Till Date),Year(2003 Till Month) Year its easy to get in the query as the following select item,sum(qty)to_char(v_date,'YYYY') from...

Hi Guys, Can Anyone help me regarding PageBreak Before/ After property in detail and when it can be used.Any help with be highly appreciated.

Could anyone tell me what minimum widow records property is all about.Could u explain with a small example

Thanks Buddy it works

HI guys i am making a matrix report in which the 'DATE BOOKED IN" will be my columns.the problem is that its not getting order by properly. for e.g it should show JAN-01,FEB -01 ,MAR-01 instead of this it is showing data in the following manner JAN-01,JAN-02,JAN-03,FEB-01. Please suggest me any...