Recent content by anju123

Thanks a lot for your response!

Hi Musafa, Thanks for your quick response. i have written a code by myself, it works fine for all year but failed for last week of 2004 and 1st week of Jan. Actually this function is calculation from 26th Dec till 1st Jan as 1week (which is correct) but it’s again calculating from 2nd jan till...

Hi Musafa, Thanks for your help but i need my week to start from sunday instead of starting from monday. ex: select to_char(to_date('26-dec-2004'),'iw') from dual; actually comes as 52nd week where as i want it to be 53 week. i have written a code by myself, it works fine for all but fails for...

Hi friends, I need your help. I need to find out the week of the year. Does anyone have any query for that or know how to calculate it. For example if user passes any date then that query should return the week of the year. Thanks in advance.

Thanks everyone, i have got the solution of my problem.

Hi friends, I need a help in Discoverer report. My Report was working fine with this date format but when on this Monday my DBA upgraded the application with new version it started giving me an error. Error is An error occurred while trying to run the query. (Inconsistent or invalid data types...

Thanks Dima! its clear to me now.

Hi! can anyone help me in finding out the reason behind this cause. When I do select length(to_char('23456','99999.99')) from dual; LENGTH(TO_CHAR('23456','99999.99')) ----------------------------------- 9 it returns the length as 9, where as I am...

Hi! Can any one help me how to convert .rpt file into .rdf in developer 2000 6i. Thanks in advance, Anju

Hi friends, I am getting a problem in developer 2000 reports 6i. when I run the report in windows and try to save that in file, it create the file but when I open that in note pad, it seems it create the file in machine language. I passed destination type= ‘File’ and destination name=...

Thanks Dima, for the reply. Anju

Hi Friends, I have one problem. There is a data base block and its multi line displayed item property is set to true (4). In post query I have written a code to display one of the items (phone number) in a format ((xxx)-xxx-xxxx). Phone number is base table item and its data type is number in...

Hi Friends, I have few queries related to Oracle database. Can anyone help me out? 1. How can we interact with two sessions in oracle database? 2. Can we pass array as a parameter in procedure and also can we pass cursor as a parameter in procedure? how? 3. Is it possible to lock row/rows in a...

Thanks, but this query takes long time to execute. is there any way to make it faster? I haven't tried your first suggestion regarding on-lock trigger yet but thanks a lot for the solution. Anju

hi friends, i have some questions: 1. I have created a screen for capturing client detail information but I am having a problem when two users query for same company detail. It blocks the other. I know the reason why it blocks but i am not getting how to display message (like some one is already...