Search:

Hi All,

I have a requirement as follows;

A procedure will be called from the front end ..
Immediately the out put of the procedure should be extracted into .csv file and the file should open...

[QUOTE=krishnaindia2007;29570]>>input 1) weekly or 2) specified : date1 and date 2

Thanks Krishna,

I was thinking to do it using one select but for different condition..
select ,,,,,,,,,,,,,...

Thanks Krishna......

I got the output as desired...

I need one more thing...

I have two select stataments

1) Select sum(decode((received_dte - input_dte ),0,1,0)) " 0 days" ,
...

Thanks for your patience.......I am close to my out put but
I needed the output for the weeks starting from monday..
the above query gives the output starting form tuesday..


Thanks,
Vijay

Hi ,

I need some light on the following issue..

I have a table which has a date field proceed_data.
This table contains about past 6 months data.

I need to select fields from this table on...

Here is the table structure

create table PROMISE
(
POLICY NUMBER(7),
CURR_DTE DATE,
INPUT_DTE DATE,
RECEIVED_DTE DATE
)

I have table tab1 with 3 date fields date_1 , date_2 and date_3.
table tab1 can contain 6 months of data.

My requirement is I need difference b/w date_1 and date_2
based on the date_3 range...

I have a Requirement to extract data fron database into .csv file...
I m using utl_file pckg to do so...
But But before writing into the file , I am fetching the records using cursors...
I can...

I am using a query which looks like

Select col1, col2,
fn_date_covert(dat_col1) - fn_date_covert(dat_col2) differnce
From table1, table2
where join (table1, table2)
and ...