Answer / rr

select to_number('5672345') from dual

Answer / 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

Answer / ankit kansal

First of all Oracle supports implicit conversion between char to number if the specified text is of number type only.
*********************************************
Lets say sql>select '111'+1 as ans from dual;
ans
---
112
*********************************************
Here, 112 is the output you received it does not matter '112' as string.
But For precautions you can write your query as
***********************************************
sql>select to_number(trim('111'))+1 from dual;
***********************************************

which transformation uses cache?

3 Answers   Keane India Ltd,

---

How to create Target definition for flat files?

0 Answers   Informatica,

---

Explain the flow of data in Iinformatica?

1 Answers  

---

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

Can we create multiple integration service on single repository?

0 Answers  

---

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

---

why dimenstion tables are denormalized in nature ?

3 Answers  

---