I need an oracle query for convert Char to Integer?. Can any
one help me how to do this?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 1 Yes | 1 No |
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;
***********************************************
Is This Answer Correct ? | 0 Yes | 0 No |
what is correlated query?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is standalone command task?
What is meant by incremental aggregation?
why u go for dimensions ?
why union transformation is active transformation?
Can you use one mapping to populate two tables in different schemas
what is shortcut in informatica? difference between shortcut,reusable object?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the exact difference b/w IN and EXIST in Oracle..?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.