Thanks everyone for your help. I ran backup online log and also cleared up some space on the drives. Its fine now.

Thanks for your replies. I'm still trying to get this work and I'm not sure how I can do this with a view.

I'm thinking of inserting a record into...

Jeff, that is a very good question. But thats how the application is been set up. Depending on the case_seq number, the description in the form_items appears on the application...

Jeff, Thanks. The view gives me the output of the select query.

create view test (case_seq,description,case_cred,number)

as SELECT b.case_seq,a.description

,a.case_cred

...

Jeff,

To create a view to generate the case_seq from the form_items table like below:

create view caseseq (case_seq)

as

select b.case_seq from form_items a,case_form b where

b.case_name='test' and a.case_cred=b.case_cred order by a.description;...

Oh?? WIll you be able to help me with that??? Not sure how I can create for this.

Thanks much.

Craig, In the above example, the inserting record in case_form table will be the 2nd record for case_name='test'. So, yes the existing record with case_seq=2 for case_name='test' should be updated...

Jack,

When I will first do an insert ('are','F','A/R Auth Table') into form_items table.

After this, I have to do an insert into case_form table with case_name='test' and case_cred='are' But...

Sorry everyone for not explaining clearly in my first message. I request to please ignore my previous message.

Here is what I need. Below are two tables:

select * from form_items

case_credform_typedescription

arc ...

Ok. THank you very much everyone for your help.

I tried below

This worked.

insert into test values (9999999999999999990) didnt work. So I guess the maximum value for numeric datatype...

Ok Thanks. We are just looking for a datatype we can go with the number of digits.. So the numeric datatype goes with number of digits?? I just tried inserting...

Thanks. But application people want to know more about the width rather than the storage size. Like in Oracle we say number(38), it can hold 38 digits.

Thank you

Yes, we actually wanted not between.

Thanks, all.

Thanks for all your comments. I've changed the code to use between and the execution time has reduced. THe application team is currently happy with it now. If they come...