How to convert character types to numeric types?
Answer / Pooja Rastogi
To convert character types (VARCHAR2, CHAR) to numeric types (NUMBER), you can use the TO_NUMBER function. Here's an example:nn```sqlnSELECT TO_NUMBER(column_name) FROM table_name;n```
| Is This Answer Correct ? | 0 Yes | 0 No |
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What are the factors causing the reparsing of SQL statements in SGA?
What is a oracle database?
What different of iner joint & outer joint with example
Explain the use of online redo log files in oracle.
pls explain connect by prior with example and its real time use
Is oracle the best database?
What are the different types of synonyms?
Can we store images in oracle database?
Can group functions be used in the order by clause in oracle?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,