Search results for query: *

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...

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

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...

hi Friends, I just want to know whether implicit cursor is fast or explicit cursor??i know when they are used but when u have select statement which will retrieve only 1 record..we use implict cursor and we can use explicit cursor as well.which will be faster and why?

Hi Friends, In my sql script i am running the following query and if the condition matches i want to run the query inside decode.How its is possible?? select decode(1,1,'select version_no from sit_version;', null) query_result from dual;

hi friends, i have a script which is as follows: clear screen ; prompt | prompt |Current Set of Books ID:&&sob prompt |Current Organization ID:&&org prompt |Current Business ID :&&bus prompt | prompt | 1 - (AOL) - AOL Insert Scripts prompt | prompt |...