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

4168

When should an artificial (or derived) primary key be used?

603

Where are tables created?

916

What differentiates pediatric nephrology from adult nephrology, and how does your approach vary when treating kidney diseases in children?

1

what is role of sap administrator in pi & ep?

2161

What the difference between rtx 2070 and 2080?

1

How do you monitor and track messages flowing through SAP Process Orchestration? Are there any specific tools or dashboards you use?

1

What is buffering in c++?

1070

what are the differences between as2 and as3?

3464

What Are The Steps Involved In The Concreting Process, Explain?

1336

Is c high or low level?

1016

what is functional level? : Windows server 2008

371

What is variance in r?

81

What does setautocommit do?

982

Compare salient pole and cylindrical rotor machines.

1894