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```

can anyody please send me the dump for Oracle 10g certifications for DBA path?

1 Answers  

---

What are the factors causing the reparsing of SQL statements in SGA?

1 Answers  

---

What is a oracle database?

1 Answers  

---

What different of iner joint & outer joint with example

4 Answers  

---

Explain the use of online redo log files in oracle.

1 Answers  

---

pls explain connect by prior with example and its real time use

3 Answers  

---

Is oracle the best database?

1 Answers  

---

What are the different types of synonyms?

1 Answers  

---

Can we store images in oracle database?

1 Answers  

---

Can group functions be used in the order by clause in oracle?

1 Answers  

---

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

2 Answers  

---

What are joins..how many types of joins are there?

29 Answers   Amdocs, CSC, TCS,

---