Search results for query: *

Hi all, I have to find the people who have same last name,birth_date and org_id with different peo_id.After finding,i have to update the other tables.if the last name has more than 1 peo_id then i have to take minimum peo_id and update the other peo_id's to that min peo_id.i have written a...

I got it.I removed the page breaks and wrote format triggers. thanks

Hi, I have created a letter in reports.if the client has guardian and casemanager it will print 2 letters.if he doesn't have either of them,it should print only one letter.but i am getting 1 letter and the other one is blank.can any one help me how to avoid that blank letter. Thanks, Latha

Hi, I have created a procedure which will retrieve the data and insert into another table.but this is taking more than 30min.Can u please help how to reduce the execution time.all the columns i have used in where clause have indexes expect org_staff_id. CREATE OR REPLACE PROCEDURE...

Hi, I have created 2 reports but depending on the user selection i have to run the one report. example i have th user parameter with 2 list of values.if the user selects one option one report has to run ,if the user selects the second option another report has to run.Can anyone please let me...

Hi ALL, I have created a matrix sql using decode according to my requirement for reports.But for the same region has more than one need it is printing in 2 rows.but i want it in the same row.can any one please help me.i am sending my query and result. SELECT umn.region...

Hi, When i run the query in Toad it is taking 1 min.but when i use the same query in a report and run it , it is taking more than 3min. Can anyone help me why it is taking that much time in report builder. Thanks, Latha

Hi, I need to find the count according to some conditions.i have written the following query and i got the result. select distinct i.INS_ID , count(CASE WHEN va.ANSWER <> 'CSS' or va.ANSWER <> 'RS' THEN 1 end) "Already in Treatment", count(CASE WHEN va.ANSWER = 'CSS' THEN 1...

Hi, I need to find the score reported and no score reported for that I have written the following query and I got the result. select count(case when va.ANSWER <= to_char(sysdate) then 1 end ) "Reported a Score", count(case when (va.ANSWER is null or va.ANSWER > to_char(sysdate...

Hi, I need to find the number of days between sysdate and database column (this is varchar2 datatype).Can any one help me how to do it. Thanks, Latha

Hi, I have created a four pages letter if the client has one address.I have to generate 2 letters with same text if the client has 2 addresses.i have to put the addresses for 1 page and 3rd page .and 2rd,3rd pages are static(no database fileds).how can i create 2 letters with different...

I am trying to create a 4 page form letter. The first page contains fields from a sql select and some static text and the second page is static text with date in the middle of the text. 3rd page is same as the first page with with small changes. CAn i use the same query for the first page and...