Hi Jey, Please see the below procedures (integer to varchar or char). S

I need an oracle query for convert Char to Integer?. Can any
one help me how to do this?

Question Posted / moorthy g

3 Answers
6378 Views
I also Faced
E-Mail Answers

Answer Posted / moorthy g

Hi Jey,

Please see the below procedures (integer to varchar or char).
SQL> CREATE TABLE DEPT1 AS SELECT *FROM DEPT
SQL> Truncate table dept1;
SQL> alter table dept1 modify(deptno varchar2(20));
SQL>insert into dept1 select *from dept;
SQL> SELECT *FROM DEPT1

Note:
1. If you want to modify in information please the load type
truncate load or not. (May it will be truncate load only)

Best Regards,
Moorthy. G

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is Data Caches size?

1044

What is rank index in rank transformation?

1016

Can u generate reports in Informatica?

1032

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1204

what is unit testing?tell me proceedure

2176

Which version configuration tool used in ur project?

3190

What is informatica?

1086

How to create Target definition for flat files?

1168

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1943

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1924

How do you load only null records into target?

1154

Different qualification between a related rotate toward the sky and isolates look upward?

940

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1237

If informatica has its scheduler why using third party scheduler?

1204

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2042