Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

2163

How many lubricating holes are there in cylinder?

680

how works encoder in plc

739

Percentage losses in power generation?

1664

why should moser bear india hire you?

747

what three "domains" are considered during analysis modeling?

4971

What problem did you encounter and how did you overcome them?

986

1. I want to create an installment method payment term whereby my customer pays 50% as Advance Payment & 50% Net 45 days. How to configure the 50% advance payment term in OBB8 as system does not take negative days say -1 . I have created Z100 as 50% Advance Payment & 50% Net 45 days, Z101 as 50% Adv Pyt and Z102 as 50% Net 45 days in OBB8 and then assigned the same in OBB9 to Z100, 1, 50%, Z101 and Z100, 2, 50%, Z102. But the payment terms Z101 should be having -1 days instead of 0 days. How to configure this or achieve the payment term of advance payment? 2. My purpose is that during FB70, I should get a warning message that advance payment has not yet been received for this customer having this installment payment term Z100. It should not let me post the invoice unless 50% adv pyt has been received. At present we are not using Down Payment functionality. But I assume that without the Down Payment functionality the same cannot be achieved. Please confirm this. How can I achieve the above requirements? 3.Dear Group - Our Purchasing Dept has asked me to create a new payment term with the following terms: "Payable 90% upon delivery, 60 days net, 10% upon acceptance, 60 days net". So when we receive the invoice, we get a 10% discount off the total price, due within 60 days. The balance is due 60 days after that. Any ideas on how I would configure this using transaction OBB8. IT IS VERY URGENT FOR ME KINDLY SEND ME THE ANSWER ON MY E.ID-sahu.suryakanta@hotmail.com.

3207

Is there a standard depth of gravel fill in Substation Switchyard? Please give a design/drawing. Thank you.

2817

whatis Home interface and Remoteinterface? with example?

818

An electron is injected into a region of uniform magnetic flux density with the components of velocity parallel to and normal to the flux. What is the path of the electron?

955

How to Finddistance between two points?

823

What is the main purpose of c.f.b.c.boiler

454

What is the use of FAM and other green flourescent dyes ?

803

What are actions? Why did you use them in your project?

683